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