How to use ‘SHOW PROCESSLIST’ and ‘SHOW FULL PROCESSLUIST’ using MySQL on the command line

To see what’s happening on a busy MySQL server, use this:

mysql -uroot -e "show full processlist"

If you want to do this continuously, try this:

watch -n1 'mysql -uroot -e "show full processlist"'

Share this article

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top