Yeah, we know, you can't read the blog. We are once again the victim of frequent "This Account Has Exceeded Its CPU Quota" errors. Apparently we have a bunch of slow mysql queries, and need to optimize our indices. Which might be very straightforward, if any of us knew what those words meant. Dammit, Jim, I'm a doctor, not a database manager! Here is the kind of error message we're getting:
# Sat Jun 9 01:23:22 2007 # Query_time: 4 Lock_time: 0 Rows_sent: 27359 Rows_examined: 83792 SELECT comment_post_ID, post_title FROM (wp_comments LEFT JOIN wp_posts ON (comment_post_ID = ID)) WHERE comment_approved = '1' AND comment_type NOT LIKE '%pingback%' AND comment_type NOT LIKE '%trackback%' ORDER BY comment_date DESC
Full of important information, I'm sure, but I have no idea what it means or how to fix it. We might just change web hosts as a way to sidestep the problem, but that ...
