• I see queries like this which require a lot of time to be executed and during this time the CPU load is high and the blog not accessible. I am almost sure that these queries related to “related posts”. Any idea how to fix the problem?

    | 11871 | user_blog | localhost | dentnews_blog | Query | 2 | Copying to tmp table | SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘??? ??? ??? |
    | 11878 | user_blog | localhost | dentnews_blog | Query | 34 | Copying to tmp table | SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘??? ??? ??? |
    | 11920 | user_blog | localhost | dentnews_blog | Query | 7 | Copying to tmp table | SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘??? ??? ??? |

Viewing 1 replies (of 1 total)
  • Thread Starter Christos Chatzaras

    (@cybercr33p)

    Full queries are like this:

    SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('�^�ο�^� �^��^�ν και κ η �^�ην με �^��^�ι �^�ο �^��^�ην ο �^�$
     from wp_posts
     left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 2190 )
                    left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
                    AND tagrel.object_id = wp_posts.ID)
                    left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
                    AND tagtax.taxonomy = 'post_tag')
     left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 2190 )
                    left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
                    AND catrel.object_id = wp_posts.ID)
                    left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
                    AND cattax.taxonomy = 'category')
     where (post_status IN ( 'publish',  'static' ) and ID != '2190') and post_date <= '2008-10-15 19:42:45'  and post_password =''  and post_type IN ('post', '$
     group by id
     having score >= 5 and tagscore >= 1 order by score DESC limit 3;
Viewing 1 replies (of 1 total)
  • The topic ‘MySQL high load’ is closed to new replies.