TalkPHP - View Single Post

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

I don't see anything in that little list. In fact all but 1 are internal MySQL queries run from, possibly, a cron. Have a look at the MySQL reference document for the SHOW PROCESSLIST command. It seems the privilege you require is the super privilege, else you will just be able to view your own thread, as seen in the above list you've shown us.

Your host no doubt has the super privilege and that's why they were able to inform you of the query. However, could you not ask them to provide further information to allow you to debug? If it's a non-stop PHP loop then it may be difficult to diagnose if it's via cron because you will never see the default memory limit error once all the memory has all been exhausted.

11-30-2007, 08:09 PM	#4 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	I don't see anything in that little list. In fact all but 1 are internal MySQL queries run from, possibly, a cron. Have a look at the MySQL reference document for the `SHOW PROCESSLIST` command. It seems the privilege you require is the super privilege, else you will just be able to view your own thread, as seen in the above list you've shown us. Your host no doubt has the super privilege and that's why they were able to inform you of the query. However, could you not ask them to provide further information to allow you to debug? If it's a non-stop PHP loop then it may be difficult to diagnose if it's via cron because you will never see the default memory limit error once all the memory has all been exhausted. __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.