[wp-trac] [WordPress Trac] #19901: Speeding up Dashboard and Comment moderation SQL load

[WordPress Trac]

#19901: Speeding up Dashboard and Comment moderation SQL load
-------------------------------------------------+-------------------------
 Reporter:  FolioVision                          |       Owner:
     Type:  enhancement                          |  markjaquith
 Priority:  normal                               |      Status:  accepted
Component:  Performance                          |   Milestone:  3.4
 Severity:  major                                |     Version:  3.3.1
 Keywords:  has-patch 2nd-opinion needs-testing  |  Resolution:
-------------------------------------------------+-------------------------

Comment (by wonderboymusic):

 I just ran these queries on eMusic's production database cluster. Our
 wp_comments table (InnoDB) has only 300,000 rows -

 original query: 161ms
 5 queries: 98.2ms

 I think most large-scale MySQL users are defaulting to InnoDB, if for no
 reason other than row-level locking. Facebook swears by InnoDB and their
 MySQL perf team is focusing a lot on InnoDB row cache and InnoDB buffer
 pool for Timeline (which is stored in MySQL).

 This is a nice improvement, but there are way more dangerous queries in
 core related to full-table scans of LONGTEXT columns. Our wp_usermeta
 table has 11,000,000 rows and gets pounded by them - but that's off-
 topic...

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