Is there a way to limit the time a mysql process can take? I have a site with a large mysql database (1.3 Gb). And sometimes a process hangs and is taking up all server resources.
So is there a way to automatically kill a mysql process when it takes more than a number of seconds?