killing a process?
Posted: Tue Oct 07, 2008 9:55 am
Hi,
suddenly there is a too many connections 1040 on my site to access phpmyadmin.
on doing a SHOW PROCESSLIST; from backend it seems that one of the process has misbehaved and it starting the connections; so how do i kill the processes
I get something like
how to kill this process?
suddenly there is a too many connections 1040 on my site to access phpmyadmin.
on doing a SHOW PROCESSLIST; from backend it seems that one of the process has misbehaved and it starting the connections; so how do i kill the processes
I get something like
Code: Select all
mysql> SHOW PROCESSLIST;
+-------+------------+-----------+--------+---------+--------+--------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------------+-----------+--------+---------+--------+--------------------------+------------------------------------------------------------------------------------------------------+
| 40396 | user1 | localhost | joomla | Query | 730153 | Waiting to get writelock | REPAIR TABLE `jos_acajoom_lists`,`jos_acajoom_mailings`,`jos_acajoom_queue`,`jos_acajoom_stats_detai |
| 40398 | user1 | localhost | joomla | Query | 730152 | Waiting to get writelock | REPAIR TABLE `jos_acajoom_lists`,`jos_acajoom_mailings`,`jos_acajoom_queue`,`jos_acajoom_stats_detai |
| 40399 | user1 | localhost | joomla | Query | 730048 | Waiting for table | REPAIR TABLE `jos_acajoom_lists`,`jos_acajoom_mailings`,`jos_acajoom_queue`,`jos_acajoom_stats_detai |
| 40400 | user1 | localhost | joomla | Query | 730048 | Waiting for table | REPAIR TABLE `jos_acajoom_lists`,`jos_acajhow to kill this process?