MySql commands - SHOW FULL PROCESSES in addition to watch

Posted 2 years ago

The below commands show what’s going on with SQL processes, -e is to execute the following command and then quit. Below I also include the use of “Watching” the process list so it’s not what’s happening at that moment.

mysql -e "show full processlist"

mysql -e "show full processlist\G"

Or watch the process list

watch 'mysql -e "show full processlist\G"'

Alternatively, dump the process list into a .txt file

mysql -e "show full processlist\G" > ~/processlist.txt