Set time limit on SQL query in mySQL

I have some new pages and every so often I get a query (usually during testing) that starts hogging the resource and all the other queries slow to a halt. I am wondering it there is a variable in mySQL that I can set to kill processes that are over a certain time limit. I use phpMyAdmin and see a "Time" column and the longer ones need to be killed. I would like for the DB to do this if they reach a certain limit.

Thanks

T
LVL 2
td234Asked:
Who is Participating?
 
todd_farmerCommented:
No, there is no way to do this automatically.  If the query is actively returning data (not idle), MySQL provides no mechanism to kill it after reaching a certain time threshold.
0
 
td234Author Commented:
Thanks once again Todd.
0
 
todd_farmerCommented:
Sorry there's not a better answer - I expect we will see this type of enterprise-level administrative support pretty soon.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.