We are currently on Amazon EC2 on Medium Instance. We wanted to know if our Apache
Worker MPM configuration is correct or do we need to tweak this to best suit our requirement:
Server Configuration:
Intel(R) Xeon(R) CPU E5430 @ 2.66GHz, 2 cores
8 GB Ram
OS: Ubuntu Linux 12.04.1
Kernel & CPU: Linux 3.2.0-31-virtual on x86_64
PHP running on Fcgi
Apache Worker MPM configuration:
<IfModule mpm_worker_module>
StartServers 5
MinSpareThreads 5
MaxSpareThreads 10
ThreadLimit 64
ThreadsPerChild 25
ServerLimit 688
MaxClients 688
MaxRequestsPerChild 10000
</IfModule>
KeepAlive Off
KeepAliveTimeout 5
TimeOut 300
Traffic on the server:
Almost 1000 PHP processes running (High traffic)
600 PHP processes (Normal traffic)
No. of Users online at a given time:
150-160 (High traffic)
90-100 (Normal traffic)
MySQL CPU usage is around:
90-100% (high traffic)
40-50% (normal traffic)
Also, MySql Max connections: 150
Could anyone recommend the best possible configuration for Worker MPM. What could be an ideal Max. Clients?
Do we also need to tweak the MySQL settings?