Set time limit on SQL query in mySQL
Posted on 2006-04-06
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.