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'
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;
mysql> kill process Id# ;