WordPress.org

Ready to get started?Download WordPress

Forums

WP EXTREMELY slow / sluggish on os X server (25 posts)

  1. greenhornet
    Member
    Posted 7 years ago #

    I've got several installations of WP on the same OS X 10.4.8 server. They are all linked to different mysql databases on a different 10.4 server on the same network. Lately the page load times have gotten up into the 1-2 minute range. Other pages with heavy Flash content on the same server load very quickly by comparison.

    I'm looking for some advice on how to troubleshoot this.

  2. greenhornet
    Member
    Posted 7 years ago #

    --bump

  3. vkaryl
    Member
    Posted 7 years ago #

    Sounds like something you need to discuss with your host provider.

  4. davidchait
    Member
    Posted 7 years ago #

    look at error logs?

    sounds like mysql could be an issue, if non-sql pages load fine.

    can also try wp-cache2. that'll eliminate (I think) mysql from the equation.

    -d

  5. greenhornet
    Member
    Posted 7 years ago #

    I AM the host provider vkaryl. They are both my servers.

    David,
    Any idea what logs I'm looking for?

    Is wp-cache2 a mod?

  6. davidchait
    Member
    Posted 7 years ago #

    no clue. mysql logging of some form (I don't know what capabilities it has) might help. again, presuming that it's taken inordinate lengths of time on certain queries.

    wp-cache2 is a plugin that caches the majority of the 'static' output for a given url request to a file, and can serve it back up rather than hitting the db.

    but, before that, my guess is maybe some other plugin, or some other config issue. if you have other mysql apps that don't have issues, then it's more likely to be a plugin.

  7. vkaryl
    Member
    Posted 7 years ago #

    *shrug* Sorry - there's no way of knowing that if you don't specify.

  8. WPChina
    Member
    Posted 7 years ago #

    I have struggled with loads for a few months, and I too both own my own servers and host on VPSs for all my wordpress blog installations. However all my servers have been Linux varieties.

    wp-cache does help a lot, but there are still problems with how loads are carried on the servers when using wordpress.

    I have one wordpress installation that previously was on a VPS that was not on a server I owned and it has about 20 different plugins working: it had massive load issues that disappeared when wp-cache was added. After about 3 months of using wp-cache, it is still trouble-free :)

    But, I have another wordpress installation that has only about 3-4 plugins active and was also having massive load issues on a VPS. We used wp-cache, but that didn't help much. I then moved it to my own dedicated server and my technician still saw major problems in how mysql was being queried. Odd, but it is still having major problems and I just moved it to Laughing Squid hosting since others on this forum say they should be able to handle WordPress hosting. I made the move a few days ago and will know in about a week if my problems have disappeared.

    Granted, many other software out there like drupal, phpnuke, xoops and others do have similar mysql query problems, but since I'm working with wordpress and not those others, I'd like to see how wordpress' core functions can best be optimized in the future :)

  9. greenhornet
    Member
    Posted 7 years ago #

    I'm going to give wp-cache a try and will post the results here. I've never been thrilled about caching unless you absolutely have to. I've got other php / mysql sites running on the server that seem to be okay.

    If it works I may leave it on until future wp updates eliminate the need.

    Chin, I'd be interested to know if Laughing Squid solves your issues in case this doesn't fix mine.

  10. greenhornet
    Member
    Posted 7 years ago #

    No luck with wp-cache. I'm now completely out of ideas.

    Pages take quite a long time to load and then 'pop' on the page all at once.

  11. peiqinglong
    Member
    Posted 7 years ago #

    Are you using technorati or some other service that connects to another blog to get information? I noticed that technorati slows down my main site because it goes out and looks for new tags and what not before the page actaully loads.

    Perhaps you have some PHP code that is quering something that is huge and takes a long time to parse through?

  12. peiqinglong
    Member
    Posted 7 years ago #

    What's your website addy?

  13. Samuel Wood (Otto)
    Tech Ninja
    Posted 7 years ago #

    Something I discovered recently was extreme slowdown in an instance of WordPress due to Apache having excessively huge logfiles. The access log on the thing was a few hundred meg, and this slowed it down to the point of unusability. Happened when a log rotator script got broken.

    Might check that as well.

  14. WPChina
    Member
    Posted 7 years ago #

    greenhornet, it takes a little while for wp-cache to work. Seriously, give it a couple days. It did help lots for me on some blogs, but I have one particular one where it helped lots, but still has a long way to go.

    I am now working on laughing squid as of about an hour ago. seems slow, but I will give it a few days to check.

  15. greenhornet
    Member
    Posted 7 years ago #

    wp-cache seems to cause the main page to be blank but serves it up once I reload (in firefox). Other than that I can't really see that much of improvement. I'm going to read the mysql docs and see what I can figure out.

  16. Chris_K
    Member
    Posted 7 years ago #

  17. greenhornet
    Member
    Posted 7 years ago #

    I moved mysql to the same server and the load time seems about the same. At least I can eliminte latency due to traffic between the two servers.

  18. greenhornet
    Member
    Posted 7 years ago #

    Some steps that I have taken based on the above suggestions:

    - I checked my log file size. It's relatively small (18.6mb). I have it set to archive every 7 days.
    - I turned off stat reporting and akismet anti-spam.
    - I would prefer not to post my domain but I'll IM you if you really want to have a first hand look.
    - Turned off wpcache. It's been running for two weeks. I can't see a difference in this case.

  19. greenhornet
    Member
    Posted 7 years ago #

    "Perhaps you have some PHP code that is quering something that is huge and takes a long time to parse through?"

    I think this is possible. I know that it is happening on every single page load. I don't know what kind of code would do that, or how to check for that matter but it seems plausible.

  20. greenhornet
    Member
    Posted 7 years ago #

    Can anyone suggest a php page with some very basic code that I could use as a test?

  21. greenhornet
    Member
    Posted 7 years ago #

    Surely someone has some sort of test page???

  22. cchurch
    Member
    Posted 7 years ago #

    Out of curiosity, greenhornet, is Performance Caching turned on (default) or off for your WP sites? You might try turning if off and then running in test to see if performance improves. For some sites with a lot of static content, OS X Server's performance caching can actually cause performance degradation. Probably at least worth testing...

  23. Samuel Wood (Otto)
    Tech Ninja
    Posted 7 years ago #

    If you want to see what queries WordPress is executing on any given page, you can do this:

    Add this to your wp-config.php file:
    define('SAVEQUERIES', true);

    Then add this to the bottom of your index template (or any other template.. I recommend the footer.php file):

    <?php
    if (SAVEQUERIES) {
    echo "<!--\n";
    foreach ($wpdb->queries as $q) echo "$q\n";
    echo "-->\n";
    }
    ?>

    This will output most of the SQL that WordPress runs in an HTML comment. It's useful for debugging. Make sure to turn it back off in a production environment. You can turn it off by simply setting it to false instead of true, or by just removing the line from the wp-config.php file again.

  24. afinucane
    Member
    Posted 6 years ago #

    I was having the same problem on OS X 10.4.9 (client, not server) and isolated it to the firewall. I had stealth mode enabled. Turning off stealth mode seems to have solved the slow load times.

  25. Garcya
    Member
    Posted 6 years ago #

    I've searched all topics around here, nobody seems to resolve the problem of a slow load, my blog is loading VERY SLOW, over 1 minute load, admin page same problem. I don't know how to install wp-cache because i can't acces the shell to do that command line, so any other sugestions? my blog http://www.Garcya.us/blog .
    PS : my other website http://www.Garcya.us works just fine!

Topic Closed

This topic has been closed to new replies.

About this Topic