apache/php performance question
 

Ok this is a test if gfy is still a webmaster board :winkwink:

on a dedicated server I got wordpress on a virtual host (apache2/php4.3.2/mysql3.23) on peaks there are about 200-300 people online. problem is the server reacts very slowly on peaks. strange thing is all other virtual hosts are normal. server load is at ~0.2, cpu 10-25%, RAM (1GB) only 150-200mb free

what my be the matter? any tips on how i could tweak apache/php/sql?

thanks!

First off to peak perform apache there are a few things that probably need to be done first.

Secondly why are you using apache 2 ... it's not stable in a performance system yet.

Third if you need someone to tune your apache and server for peak performance with php and mysql hit me up 44-33-144 or servers @ jfpdude.com

thanks. sent you auth. request

send again I approved it but don;t see you on my list

I'd highly recommend upgrading to php 4.3.11 before doing anything else. Anything < 4.3.10 is vulnerable to nasty buffer overflow exploits.

Apache 2 is perfectly stable. I've got several machines with 6 months +/- uptime on them running apache 2.

Upgrade mysql to 4, turn on query caching and you'll see a significant increase in speed. Might not be your only problem, but that will help a lot, especially with a mysql heavy site like a blog.

Have atleast zend optimizer on your server if not zend accelerator

Some possibilities:

Presuming you're on a unix system and have access sufficient to run vmstat, see if you can get an idea of what runtime is being devoted to. Depending on what you're serving those 200 or so people, you may be running into bottlenecking to storage or (if you have an older machine) networking. Bottlenecks would be revealed by a high amount of CPU time devoted to system or wait states, with associated high levels of io pages in and out.

Another possibility is that your processes absorb enough runtime RAM to cause the machine to go into swap. vmstat would reveal that as well in swap pages in/out.

HTH. :thumbsup