TalkPHP - View Single Post

Wildhoney · 11-29-2007, 09:30 PM

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:

sql Code:

SHOW FULL PROCESSLIST

FULL 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 may not 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!

11-29-2007, 09:30 PM	#2 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	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: sql Code: SHOW FULL PROCESSLIST `FULL` 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 may not 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.