[wp-trac] [WordPress Trac] #19973: Query Maxing Out CPU

[WordPress Trac]

#19973: Query Maxing Out CPU
--------------------------+------------------------------
 Reporter:  ballhogjoni   |       Owner:  ballhogjoni
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  3.3.1
 Severity:  major         |  Resolution:
 Keywords:  needs-patch   |
--------------------------+------------------------------

Comment (by ballhogjoni):

 Ok I tried a few other pages...like category and tag pages, plus I tried
 the dashboard of the admin. I didn't see it in the debug plugin.

 That term_taxonomy_id in the query points to the nav_menu taxonomy in the
 wp_term_taxonomy table, this record has a term_id of 18492. When I view
 record 18492 in the wp_terms table I see the term's name = Top Menu and
 slug = top-menu

 Don't know if that helps, but I appreciate you working with me.

 This is the output when I run show full processlist.

 {{{
 mysql> SHOW FULL PROCESSLIST;
 +----------+--------------+-------------------------------------------+----------------------+---------+------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 | Id       | User         | Host                                      | db
 | Command | Time | State          | Info
 |
 +----------+--------------+-------------------------------------------+----------------------+---------+------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 | 17270255 | leechprotect | localhost                                 |
 leechprotect         | Sleep   | 4013 |                | NULL
 |
 | 17286335 | root         | localhost                                 |
 NULL                 | Query   |    0 | NULL           | SHOW FULL
 PROCESSLIST
 |
 | 17286349 | username     | static.cloud-ips.com:35551 | dbname | Query
 |    0 | preparing      | SELECT count(*) as c FROM wp_posts WHERE ID IN
 (SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id =
 18562) AND ID IN (SELECT post_id FROM wp_postmeta WHERE meta_key =
 '_menu_item_menu_item_parent' AND meta_value = '56783') ORDER BY
 menu_order |
 | 17286351 | username     | static.cloud-ips.com:35552 | dbname | Sleep
 |    2 |                | NULL
 }}}

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