• After update to WP 3.1.1 in our most important project running wordpress, we are facing serious problems with MySQL slow queries that are causing our site going down frequently.

    Slow queries look like this one:

    # Query_time: 66.859010  Lock_time: 13.069493 Rows_sent: 0  Rows_examined: 252242583
    SET timestamp=1303739202;
    SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (92) AND wp_posts.ID IN (
    					SELECT object_id
    					FROM wp_term_relationships
    					WHERE term_taxonomy_id IN (77)
    					GROUP BY object_id HAVING COUNT(object_id) = 1
    				) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 1190, 10;

    I disabled and enabled plugins with no clue, and also tried to use Theme-Check to verify possible code incompatility but we are getting a blank page running plugin.

    This WP install runs on a dedicated box plenty of resources and right now our site is complete off.

    What could be happening? Could anyone help us?

    Thanks in advance!

  • The topic ‘Slow queries after WP 3.1.1 update’ is closed to new replies.