WordPress.org

Ready to get started?Download WordPress

Forums

Need help understanding Slow Query Log (2 posts)

  1. relaxedguy
    Member
    Posted 4 years ago #

    Here's the output from tonights running of the MySql slow query log at my host, MediaTemple. I'm having a difficult time understanding which query is slow. Is it a plugin (I use many, but just yesterday the blog text would load in 5 seconds (ads and twitter feed are of course slower).

    I have 3,000 posts and 6,000 comments.

    I'm also curious why http://tools.pingdom.com/?url=http://onlinedatingpost.com shows my main html page as taking up to 8 seconds to download.

    Strange that some days it's fast, others the page load can be 15 seconds total. I am on the Media Temple Grid Server so I know that I can run up against resource issues but this is an ongoing vexing problem. I've tried removing all plugins several times, doesn't seem to help much.

    Here is the slow query log:

    ### 5 Queries
    ### Total time: 33, Average time: 6.6
    ### Taking 6 , 6 , 6 , 7 , 8 seconds to complete
    ### Rows analyzed 6197, 6197, 6197, 6197 and 6197
    SELECT ID, post_author, post_date, post_date_gmt, post_status, post_name, post_modified, post_modified_gmt, post_parent, post_type FROM wp_posts WHERE ( (post_status = 'XXX' AND (post_type = 'XXX' OR post_type = 'XXX')) OR (post_status = 'XXX' AND post_type = 'XXX') ) AND post_password='XXX' ORDER BY post_modified DESC;

    SELECT ID, post_author, post_date, post_date_gmt, post_status, post_name, post_modified, post_modified_gmt, post_parent, post_type FROM wp_posts WHERE ( (post_status = 'publish' AND (post_type = 'post' OR post_type = '')) OR (post_status = 'publish' AND post_type = 'page') ) AND post_password='' ORDER BY post_modified DESC;

    ### 1 Query
    ### Total time: 28, Average time: 28
    ### Taking 28 seconds to complete
    ### Rows analyzed 6736
    SELECT /*!XXX SQL_NO_CACHE */ * FROM wp_comments;

    SELECT /*!40001 SQL_NO_CACHE */ * FROM wp_comments;

    ### 1 Query
    ### Total time: 20, Average time: 20
    ### Taking 20 seconds to complete
    ### Rows analyzed 4899
    SELECT /*!XXX SQL_NO_CACHE */ * FROM wp_posts;

    SELECT /*!40001 SQL_NO_CACHE */ * FROM wp_posts;

    ### 1 Query
    ### Total time: 6, Average time: 6
    ### Taking 6 seconds to complete
    ### Rows analyzed 0
    use dbXXX_onlinedatingpost;
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'XXX';

    use db2873_onlinedatingpost;
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';

    Any idea whats going on?

    Ill try the W3 Total Cache this week, wanted to see if there was anything else I should do first.

  2. relaxedguy
    Member
    Posted 4 years ago #

    W3 Total Cache is amazing! I'm still optimizing the settings but it took my page load times down to 4 seconds, impressive.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.