The Sciences

Downtime

Cosmic VarianceBy Sean CarrollJun 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.

1 free article left
Want More? Get unlimited access for as low as $1.99/month
Already a subscriber? Log In or Register
1 free articleSubscribe
Want unlimited access?

Subscribe today and save 70%

Subscribe

Already a subscriber? Log In or Register
More From Discover
Recommendations From Our Store
Shop Now
Stay Curious
Join
Our List

Sign up for our weekly science updates.

 
Subscribe
To The Magazine

Save up to 70% off the cover price when you subscribe to Discover magazine.

Copyright © 2021 Kalmbach Media Co.