Optimization problems, slow Mysql queries

  • mpromptu

    (@mpromptu)


    17 years, 11 months ago

    I can’t log into my WordPress admin right now because my account has been suspended… when I called Bluehost (my server), they said the server was getting hit too many times by slow queries and I needed to optimize something… (I wasn’t sure what they were talking about). They did have me get the mysql_slow_queries folder and I have a lot of things that look like this:

    # Sat Mar 1 06:33:27 2008
    # Query_time: 2 Lock_time: 0 Rows_sent: 10 Rows_examined: 88104
    use friendl5_wrdp1;
    SELECT DISTINCT wp_comments.* FROM wp_comments LEFT JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status = ‘publish’ OR post_status = ‘static’) AND comment_approved= ‘1’ AND post_password = ” AND comment_type = ” ORDER BY comment_date DESC LIMIT 10

    Can someone please help me fix this and get my account back?

Viewing 2 replies - 1 through 2 (of 2 total)
  • bernardborealis

    (@bernardborealis)

    17 years, 10 months ago

    This is most commonly caused by poor, or lack of indexing. When you have a field with a very large amount of entries and a query takes a long time to browse it for what it is looking for, this may result in extra CPU time. If you set up an index for that field, it will make it much easier for the query to find what it is looking for and you’ll avoid a lot of CPU usage that way. (you can do this through phpmyadmin)

    moshu

    (@moshu)

    17 years, 10 months ago

    Bernard, STOP digging up months old post that are mentioning bluehost!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Optimization problems, slow Mysql queries’ is closed to new replies.

Tags