[resolved] Different Apache+MYSQL versions affect commenting performance (7 posts)

  1. mooiness
    Posted 9 years ago #

    Continuing on from my previous unanswered post:

    Did some more testing, this time using two machines on Apache 2.0.55 and PHP 4.4.2. One however running MYSQL 3.23.58 and the other running MYSQL 4.1.16.

    The one running the newer version of MYSQL takes a long time for a comment to be published. Everything else works fine.

    So in conclusion, I have found out the following re: performance of comments -
    Apache 2.0.55 + MYSQL 4.x --> slow
    Apache 2.0.55 + MYSQL 3.23.* --> normal
    Apache 1.3.34 + MYSQL 4.x --> normal

    Haven't test out Apache 1.3.34 with MYSQL 3.23.x though. SSL or no SSL does not make a difference as thought so.

    I run a variety of web apps on the above 3 machines and they are all ok with no noticable performance difference.

    This is not a show stopper but it would be good to have some idea why this is happening with WordPress. Thanks!

  2. khimichcom
    Posted 9 years ago #

    How much 4.x slower for you than 3.x? Is this milliseconds or tens of seconds? Is that machines identical? CPU, OS, memory..

  3. mooiness
    Posted 9 years ago #

    Yup similar specs - Intel Pentium-4 2.8/3.0 Ghz, 1GB RAM and all running Fedora Core 3.

    Slower as in 10 seconds slower. You wait and wait, thinking that nothing is happening but then you get the email notification about the new comment (via Gmail notifier) and the page is still processing.

    Like I said, it's not a show stopper because the comment still comes through but it may annoy a visitor obviously.

  4. skippy
    Posted 9 years ago #

    Are all the sites using the same plugins?

  5. mooiness
    Posted 9 years ago #

    Yes identical. I've even disabled all the plugins just to be sure. So whilst testing, it was all bare bones.

  6. khimichcom
    Posted 9 years ago #

    If its 10 seconds I would recomend you to check dns-resolving settings and after that possibly you need to check sendmail setup

  7. mooiness
    Posted 9 years ago #

    khimichcom: You are right, it was DNS causing sendmail to be slow, and hence commenting to be slow.

    I never thought to look at that because I have been receiving automated system emails from the machine fine - but because they are cron mails sent in the middle of the night, I never knew how slow it took.

    My solution: added a fully qualified domain name into my /etc/hosts for the address "".


Topic Closed

This topic has been closed to new replies.

About this Topic