thisyounThe last three days my blog has been racking up tons of MySQL slow queries which has caused BlueHost to suspend my account each evening. The quieries seem to be all over the board in terms of which databases and tables are causing them, so it appears to be a general Wordpress issue. BlueHost support had me install wp-cache and later wp-super-cache plug-ins to help fix the problem, but each time it seems to temporarily work but before I know it I'm being bombarded again.
Below are 4 sample queries I've received recently, but there have been several other different types. We've recently (in the past 3 weeks) received an increase in traffic (up from ~17k pageviews daily to ~26k) but nothing has changed in the past two days.
Any help is EXTREMELY appreciated. Thanks in advance
# Thu Apr 23 10:00:49 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use thisyoun_wrdp1;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
# Thu Apr 23 10:01:18 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use thisyoun_wrdp1;
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 10642 AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt < '2009-04-23 14:20:10'
# Thu Apr 23 10:01:24 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use thisyoun_wrdp1;
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category') AND tt.count > 0 ORDER BY t.name ASC
# Thu Apr 23 10:01:24 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SET NAMES 'utf8'
peps974