Debugging

October 20th, 2007 - 13:00 | 4 comments

Down to a basic theme as there’s something, somewhere in the depths of my site, breaking the database and affecting other sites on the same server. I feel rather bad about this. It doesn’t seem to be caused by any of the obvious plugin candidates, so I’m leaning towards it being some odd code in the theme. Hopefully. I’ll strip and revamp my main theme (actually I may just start again, given how messy it’s become over the past couple of years).

-----

4 Responses to “Debugging”

1 ED Oct 20th, 2007 at 7:12 pm

Flick on the settings to highlight long running queries, perhaps?

Perhaps you can monitor what queries are being executed as well and then trace that back?
2 PooterGeek Oct 20th, 2007 at 7:23 pm

Good suggestions. I installed mtop to monitor MySQL queries, but whatever it is that’s causing the problem is intermittent and sucks up memory so suddenly that I’ve never caught it in the act. The really annoying thing is that when the site goes down the server stays up for a while, but doesn’t let us ssh in.
3 Ed Oct 21st, 2007 at 10:05 pm

I wondered about cron jobs or rss feeds.

Have u got caching enabled? Perhaps a bit of query caching might help?
4 Ed Oct 21st, 2007 at 10:05 pm

(specifically wp-cron)

-----

Commenting Policy: Thoughts, observations, argument, debate and all other conversational wonderments are encouraged, but personal attacks or general trolling will result in your comment being deleted and your account/IP banned. If you're nice, however, you get strawberries.