#&#@*!!

In case you were wondering why I haven’t been online for the past two days, here’s the explanation from our (former) host:

Unfortunately, your WordPress site is causing what is called “slow queries” on your database server.

A slow query is a query that examines a high amount of rows over a long period of time. The more the query has to examine and the longer the query
takes to do so, the harder it can be on the server. In that you are hosting on a shared hosting server, such queries can become problematic for other users.

WordPress, being a dynamic site, would normally run such queries on every to almost every access on the site. One recommendation would be to setup a
caching utility if you haven’t already, which would prevent the software from having to run so many queries. You may also wish to check with the
Wordpress forums for any thoughts on reducing the impact WordPress might have on a database server.

Here are some example queries that we are referencing:

# User@Host: susiemad[susiemad] @  [209.68.6.23]
# Query_time: 163  Lock_time: 0  Rows_sent: 1  Rows_examined: 32054
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND
HOUR(wp_posts.post_date)=’19’ AND MINUTE(wp_posts.post_date)=’8′ AND
YEAR(wp_posts.post_date)=’

2007′ AND MONTH(wp_posts.post_date)=’12’ AND
DAYOFMONTH(wp_posts.post_date)=’24’ AND wp_posts.post_type = ‘post’ AND
(wp_posts.post_status = ‘publish’)  ORDER BY wp_posts.post_date DESC LIMIT
0, 15;

# User@Host: susiemad[susiemad] @  [209.68.6.23]
# Query_time: 191  Lock_time: 0  Rows_sent: 1  Rows_examined: 10328
SELECT p.* FROM wp_posts AS p  WHERE p.post_date < ‘2007-12-21 20:37:49’
AND p.post_type = ‘post’ AND p.post_status = ‘publish’  ORDER BY
p.post_date DESC LIMIT 1;

# User@Host: susiemad[susiemad] @  [209.68.6.23]
# Query_time: 14  Lock_time: 0  Rows_sent: 1  Rows_examined: 64108
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND
wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’)  ORDER
BY wp_posts.ID ASC LIMIT 0, 1;

# User@Host: susiemad[susiemad] @  [209.68.6.23]
# Query_time: 32  Lock_time: 0  Rows_sent: 1  Rows_examined: 32054
use susiemad_wordpress;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND
HOUR(wp_posts.post_date)=’16’ AND MINUTE(wp_posts.post_date)=’24’ AND
YEAR(wp_posts.post_date)=’2004′ AND MONTH(wp_posts.post_date)=’10’ AND
DAYOFMONTH(wp_posts.post_date)=’31’ AND wp_posts.post_type = ‘post’ AND
(wp_posts.post_status = ‘publish’)  ORDER BY wp_posts.post_date DESC LIMIT
0, 15;

Unfortunately, given the number of problems the database has caused we will have to ask your review of the above and a discussion on correcting the problem prior to our re-enabling the database.