[wp-trac] Re: [WordPress Trac] #9984: MySQL CPU usage hits 500%+ and Site Crashes up on Approving Comments

[WordPress Trac]

#9984: MySQL CPU usage hits 500%+ and Site Crashes up on Approving Comments
--------------------------+-------------------------------------------------
 Reporter:  syedabbas     |       Owner:                                         
     Type:  defect (bug)  |      Status:  new                                    
 Priority:  high          |   Milestone:  Unassigned                             
Component:  Comments      |     Version:  2.7.1                                  
 Severity:  major         |    Keywords:  MySQL CPU, High CPU Usage, Comments Bug
--------------------------+-------------------------------------------------

Comment(by filosofo):

 Replying to [ticket:9984 syedabbas]:
 > Following query is found lined up in the database
 > "SELECT c . * , p . * FROM wp_comments c INNER JOIN wp_posts p ON p."

 I don't see any query using "c" as an alias for wp_commments in 2.7.1 or
 any queries like that, so I bet it's a plugin.  Try disabling all plugins
 to see if the problem goes away.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/9984#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software