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