Register for an account

X

Enter your name and email address below.

Your email address is used to log in and will not be shared or sold. Read our privacy policy.

X

Website access code

Enter your access code into the form field below.

If you are a Zinio, Nook, Kindle, Apple, or Google Play subscriber, you can enter your website access code to gain subscriber access. Your website access code is located in the upper right corner of the Table of Contents page of your digital edition.

The Sciences

Downtime

Cosmic VarianceBy Sean CarrollJune 9, 2007 7:49 PM

Newsletter

Sign up for our email newsletter for the latest science news

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 sounds like work. Any other suggestions? Update: The particular problem mentioned here has been traced to a particular plugin and fixed. We've eliminated all of the noticeably slow mysql queries, but the problem persists. Once in a while an apparently ordinary request ("GET" a certain page, for example) takes 30 seconds, for no discernible reason. We've optimized the database, and even created some new indices, although I'm not even sure if that helps or hurts things. Maybe it will fix itself.

    2 Free Articles Left

    Want it all? Get unlimited access when you subscribe.

    Subscribe

    Already a subscriber? Register or Log In

    Want unlimited access?

    Subscribe today and save 70%

    Subscribe

    Already a subscriber? Register or Log In