Rogue MySQL Process / Service
View Single Post
11-29-2007, 09:30 PM
La Vida es Sueño
Join Date: Sep 2007
I don't believe you are able to set a MySQL query time-out, unless things have changed since around 4 months ago. You can, however, run the following command to see which query is running that is draining resources:
is an optional clause. You will also obviously need to have the privileges to see every process list, else you'll just be able to view your own. Email your web-host for further information on that side of things.
Remember though that it
be one single query, but rather your PHP that has got stuck in a loop and executing the same query, or bunch of queries, over-and-over again.
Hope this helps you!
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.
View Public Profile
Send a private message to Wildhoney
Visit Wildhoney's homepage!
Find More Posts by Wildhoney