Support » Fixing WordPress » Working in dashboard intolerably slow.

  • I hope what I’m about to do is not frowned upon, but I’m getting truly desperate. It is becoming almost impossible to update our site when working on making changes and the like.

    Several days ago I posted the following and have received no responses at all. So I’m posting again in the hope that someone new might see it and be able to offer some suggestions as to what the problem might be. Thanks:
    ——————————————-
    I recently noticed that a site I’m working on is intolerably slow, not when a visitor is looking at it, but when we’re working on it.

    I wrote my hosting service to see if there was some kind of problem. This is what he wrote back:
    ———————————–
    I found this in the logs which could be the reason why WordPress is slow…

    baggettfamilyfarm.com [Mon Nov 04 11:28:59 2013] [error] [client 76.164.194.74:53561] AH01215: WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.post_date DESC LIMIT 0, 16 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
    —————————————
    He suggested I check with the forum to see if anyone could explain to me if this could be the reason for the slowness, what might be going on, and how I might be able to fix it.

    Thanks for any help. At this point, it’s almost impossible to work with the site.

    Martin

Viewing 3 replies - 1 through 3 (of 3 total)
  • Can you recreate your server environment and WordPress install on a local testing machine (or a server development environment)? Then install the Developer plugin in this test environment and enable the various developer plugins (part of the developer plugin) to try and figure out what’s happening?

    In the back of my mind I’m wondering if you’re on a shared server hosting account and your site and possibly others on the same server have gotten complex enough that they’re putting enough strain on the shared resources to cause such issues… You may need to graduate to a more advanced hosting plan (virtual private server).

    Hum, I am rather newbie at WP but I encountered slowness problems. So I installed

    “P3” and “Debug Objects” plugins for WP in order to have better diagnostic. For Debug Objects, latest release is bugged but on wordpress.org’s plug-in support page, there is a link to github’s latest alpha version which does work.

    You will see quickly how many queries you have, if there are arrors and what part of loading times are due to what.

    For me, I upped Apache’s PHP memory usage limit to 128 MB in wp-config file and added other lines aimed at reducing workload in an .htaccess at the site root and it really reduced slowness…

    For caching :

    <ifmodule mod_expires.c>
    <filesmatch ".(jpg|jpeg|png|gif|js|css|swf|ico)$">
    ExpiresActive on
    ExpiresDefault "access plus 1 months"
    </filesmatch>
    </ifmodule>

    For compression:

    <filesmatch ".(php|html|css|js)$">
    SetOutputFilter DEFLATE
    </filesmatch>
    Thread Starter martinrice

    (@martinrice)

    bemdesign and Kryssprollz, thanks so much for this information. It gives me something to try.

    I once tried to install WP on a local testing machine but it didn’t go that well. However, I was just messing around. Now that it’s serious, I’ll give it another try.

    But first I might try the suggestions made by Kryssprollz. It might be easier to start that way.

    Thanks again,
    Martin

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Working in dashboard intolerably slow.’ is closed to new replies.