{"id":1235,"date":"2007-06-09T10:49:20","date_gmt":"2007-06-09T15:49:20","guid":{"rendered":"http:\/\/blogs.discovermagazine.com\/cosmicvariance\/2007\/06\/09\/downtime\/"},"modified":"2007-06-09T10:49:20","modified_gmt":"2007-06-09T15:49:20","slug":"downtime","status":"publish","type":"post","link":"https:\/\/preposterousuniverse.com\/blog\/2007\/06\/09\/downtime\/","title":{"rendered":"Downtime"},"content":{"rendered":"

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!<\/p>\n

Here is the kind of error message we’re getting:<\/p>\n

# Sat Jun 9 01:23:22 2007
\n# Query_time: 4 Lock_time: 0 Rows_sent: 27359 Rows_examined: 83792
\nSELECT
\n comment_post_ID, post_title
\n FROM (wp_comments LEFT JOIN wp_posts ON (comment_post_ID = ID))
\n WHERE comment_approved = ‘1’
\n AND comment_type NOT LIKE ‘%pingback%’ AND comment_type NOT LIKE ‘%trackback%’
\n ORDER BY comment_date DESC<\/p><\/blockquote>\n

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?<\/p>\n

Update:<\/strong> 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.<\/p>\n","protected":false},"excerpt":{"rendered":"

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, […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-1235","post","type-post","status-publish","format-standard","hentry","category-blog"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/posts\/1235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/comments?post=1235"}],"version-history":[{"count":0,"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/posts\/1235\/revisions"}],"wp:attachment":[{"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/media?parent=1235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/categories?post=1235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/preposterousuniverse.com\/blog\/wp-json\/wp\/v2\/tags?post=1235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}