For a while now, I've received service messages that a query against a WordPress database was killed for running over a minute. It happens for two separate installs. This was originally just an occasional occurrence, but has recently increased to every few days, and I was curious if anyone else has seen this, maybe figured out exactly what the cause is, or could provide some ideas for hunting it down. The only plugins I've found for scanning queries involve things that happen while moving around in the application. But these errors always happen when I'm not in there, so appear to be from some scheduled process. (Posting of items is handled via queue, and the notices do not correlate either with me creating items or with publishing.) I haven't found a plugin or whatever that'll log that sort of thing. The query in question is:
The thing about it is that as far as I can tell, it's completely stock(ie. not obviously from a plugin). asked 20 Jan '13, 05:49 Su Generis |
When a stock WP query is running slow, the cause is usually a general high load condition on your server, probably not caused by your own processes. If you think this might be the case, then feel free to ignore the warning, or open a support ticket if you need us to look into it further for you. answered 21 Jan '13, 10:11 seanf [Notifications weren't set up properly.] Yeah, I also filed a ticket at the time regarding performance and it turned out a db process was eating the server. Seems to be mostly under control for the moment; back to the much-more-occasional rate of incidence.
(28 Jan '13, 10:44)
Su Generis
|