Show MYSQL Processes

MYSQL Process List

There could come a time when the database or website seems to lag and the pages take longer than normal to load. The problem could exist if there are relational database queries which do not use indexes, or queries are written in a manner for which poor performance occurs.

Web Host Manager

To see processes with Web Host Manager,  
1) Select 'Home' >'SQL Services' >'Show MYSQL Processes'

Shell command
The command below will give you all mySQL running and sleeping process status then select the sleeping process id and kill it using SSH. Open SSH and show the process ids. Then, open mySQL and kill the id.

Show processes with Linux
# mysqladmin pr 

Show processes with mySQL
mysql> show processes;


Kill Process
mysql> kill process Id# ;

September 5, 2012 by kent