[wp-hackers] Problems ?

[Ryan Boren]

On Mon, 2005-03-07 at 11:23 -0500, Carthik Sharma wrote:
> Just a mild reminder, if I may :
> 
> Since Jason seems to be inclined to help, and so too Farook, maybe we
> could nail down the exact queries that caused at least a few of the
> problems?
> 
> I know that recreating problems such as these are not the easiest
> thing to do, and I am not webhost, so I am wondering what the best
> approach would be, to identify the query or WP code responsible for
> the problems as in the ones described by Jason. Jason posted three
> log-sections earlier, but without knowing what caused those problems
> where mysql errored out (insufficient memory), I can't see a way
> forward - with respect to improving the source.
> 
> Maybe michel_v or dougal or matt can look into the aspect of posting
> through xmlrpc that caused the problem Jason referred to?
> 
> Maybe rboren can provide some insight over what he thinks might have
> caused the problem on his account?

Well, I got error 12 for awhile again today.

WordPress database error: [Got error 12 from table handler]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`,
count(ID) as posts FROM wp_posts WHERE post_date < '2005-03-29 00:42:00'
AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date)
ORDER BY post_date DESC

That query is made by get_archives() when retrieving by month.  It's
usually a short running query.  It simply makes a list of months.

Anyhoo, if you're curious to see what queries are made and how long they
take to run, try the attached plugin.  It dumps a list of queries into
wp_footer(), which isn't a pretty thing to put on your production blog.
Save it for a testbed.  You have to define SAVEQUERIES in wp-config for
the plugin to work (directions in the plugin).

Ryan