MySQL show processlist

To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command

show processlist;

1	show processlist;

To see the full SQL command, use

show full processlist;

1	show full processlist;

You can also use the following command from the bash command prompt

mysql --skip-column-names --batch -e 'show processlist'

1	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

1	mysql --skip-column-names --batch -e 'show processlist' \| wc -l