MySQL queries causing high load

  • Hi,

    I’m seeing a lot of this queries in mysql console process list

     Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND wp_posts.ID NOT IN (251312) AND (
  wp_term_relationships.term_taxonomy_id IN (255)
) 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, 3

    and these cause mysql high cpu usage. Can you help?

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘MySQL queries causing high load’ is closed to new replies.