WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] Different Apache MYSQL versions affect commenting performance

[Resolved] Different Apache MYSQL versions affect commenting performance

  • Continuing on from my previous unanswered post:
    http://wordpress.org/support/topic/60701

    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!

Viewing 6 replies - 1 through 6 (of 6 total)
  • How much 4.x slower for you than 3.x? Is this milliseconds or tens of seconds? Is that machines identical? CPU, OS, memory..

    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.

    Are all the sites using the same plugins?

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

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

    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 “127.0.0.1”.

    Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Resolved] Different Apache MYSQL versions affect commenting performance’ is closed to new replies.
Skip to toolbar