[wp-trac] [WordPress Trac] #16966: Query Causing MySQL to use all resources / crashes server

[WordPress Trac]

#16966: Query Causing MySQL to use all resources / crashes server
--------------------------+-----------------------------
 Reporter:  user65        |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Query         |    Version:  3.1
 Severity:  critical      |   Keywords:  dev-feedback
--------------------------+-----------------------------
 Hello, I have the following posts for information and resources:
 http://wordpress.org/support/topic/database-maxing-cpu-usage-after-
 upgrade-to-31
 http://wordpress.org/support/topic/mysql-slow-queries-wordpress-31

 My issue is that my host is telling me to move the wp-posts table to a
 different server, or different database... or SOMETHING. I dunno.

 There is a query that is eating up all of my resources, This only happened
 since upgrading to 3.1. This query is available in the post I started -
 Database Maxing CPU Usage after Upgrade to 3.1.

 I was thinking about using the modified query.php, but the ticket is a
 mess! http://core.trac.wordpress.org/ticket/10964

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/16966>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software