[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:  scribu
     Type:  defect (bug)       |      Status:  reviewing
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Query              |     Version:  3.1
 Severity:  critical           |  Resolution:
 Keywords:  reporter-feedback  |
-------------------------------+------------------------------

Comment (by user65):

 Thought so, thanks.

 I ran it from the Command Shell in Webmin.

 This is what I got back:

 {{{
 > SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN
 wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
 INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id =
 wp_term_taxonomy.term_taxonomy_id)  WHERE 1=1  AND
 wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN
 ('34') AND wp_posts.post_type = 'post' AND (wp_posts.post_status =
 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER
 BY wp_posts.post_date DESC LIMIT 0, 10
 bash: -c: line 0: syntax error near unexpected token `('
 bash: -c: line 0: `SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts
 INNER JOIN wp_term_relationships ON (wp_posts.ID =
 wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON
 (wp_term_relationships.term_taxonomy_id =
 wp_term_taxonomy.term_taxonomy_id)  WHERE 1=1  AND
 wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN
 ('34') AND wp_posts.post_type = 'post' AND (wp_posts.post_status =
 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER
 BY wp_posts.post_date DESC LIMIT 0, 10'

 }}}

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