To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command
show processlist;
To see the full SQL command, use
show full processlist;
You can also use the following command from the bash command prompt
mysql --skip-column-names --batch -e 'show processlist'
To see the number of SQL processes, use
mysql --skip-column-names --batch -e 'show processlist' | wc -l
