MySQL - How to Limit Process Execution Time?
One of my hosted customers seem to be executing a mysql query which does not close. The process remains open for hours and the CPU Load Avergae goes upto 50.00 rendering the server unstable.
My question; is there any mysql configuration parameter which can be defined to limit the mysql process to say 60seconds. I would want the mysql process to auto close after execution.
Any help will be much appreciated.
Many thanks!
P.S. When i login to mysql and issue the command
show full processlist;
It would show me the following process stuck in memory for hours till i restart mysql. As soon as i restart mysql; this process is killed and server load comes down to almost zero.
+------+------+-----------+------+---------+------+--------------+-------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+------+---------+------+--------------+--------------+
| 2884 | username | localhost | db_name | Query | 7295 | Sending data | select * from hit_counter where hittime >= '20040101000000%' and hittime <=
'20050201235959%' and url like '%www.domain.com%'
