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"'