CPU Throttling – MySQL slow queries –

  • Hi lads,
    I’m having a problem with CPU Throttling in the last days. It’s driving me crazy, cause I’m kind of in a dead end:

    – WordPress database has been cleaned up of post revisions and old metakeys.
    – Cache plugin instaled (W3)

    I have no clue why I’m using that much CPU, my sites are plain WordPress websites with less than 100 posts at most.
    site: espalandroid.net

    Some help or light about how to fix this issue would be much appreciated.
    Thanks

    I still get plenty of slow mySQL queries like theses:

    # Sat Dec  4 14:11:32 2010
# Query_time: 1.666564  Lock_time: 0.478759 Rows_sent: 0  Rows_examined: 0
use espaland_wrd3;
SELECT option_value FROM wp_options WHERE option_name = 'menu_items' LIMIT 1

# Sat Dec  4 14:11:32 2010
# Query_time: 1.696572  Lock_time: 0.000243 Rows_sent: 1  Rows_examined: 7
use espaland_wrd3;
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (1557) ORDER BY t.name ASC

# Sat Dec  4 14:12:46 2010
# Query_time: 2.218030  Lock_time: 0.735441 Rows_sent: 1  Rows_examined: 9
use espaland_wrd3;
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1674) ORDER BY t.name ASC

# Sat Dec  4 14:12:49 2010
# Query_time: 2.542569  Lock_time: 0.000418 Rows_sent: 1  Rows_examined: 7
use espaland_wrd3;
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1731) ORDER BY t.name ASC

# Sat Dec  4 14:13:10 2010
# Query_time: 3.116935  Lock_time: 0.036779 Rows_sent: 5  Rows_examined: 30
use espaland_wrd3;
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_posts.ID NOT IN (69) AND wp_term_taxonomy.taxonomy = 'post_tag'  AND wp_term_taxonomy.term_id IN ('105', '18', '22', '45')  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 0, 10

# Sat Dec  4 14:13:12 2010
# Query_time: 2.175977  Lock_time: 0.000357 Rows_sent: 10  Rows_examined: 180
use espaland_wrd3;
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_posts.ID NOT IN (1748) AND wp_term_taxonomy.taxonomy = 'post_tag'  AND wp_term_taxonomy.term_id IN ('241', '92', '222')  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 0, 10
  • The topic ‘CPU Throttling – MySQL slow queries –’ is closed to new replies.

Tags