Mobilepedia website tuning

MobilePedia Website Tuning

Issue

The issue reported by customer is slowness in website

Understanding / Observation

As the page taking time to open is of around 60-70 secs, as on the page there is lot of calulations happening at the code level as told by customer,And we analyse the system at the excution time cpu utilization of mysql goes to 90-100 % and even memory cunsumption is also high, got the issue with,the free memory left.

Solution / Process

Server Information:

VPS kloxo based Server 
OS : CentOs 6.4 x86_64
Ram : 2 GB
Main Services Running : tcpserver, named, php, xinetd, httpd, mysql, nrpe, kloxo

Note: As this is kloxo based site but we have done some apache level changes in httpd.conf buy cli

We have add the below parameter in httpd.conf :

StartServers       3
MinSpareServers    3
MaxSpareServers   10
ServerLimit      50
MaxClients       50
MaxRequestsPerChild  2000
KeepAlive  off
Timeout 40

save & exit;

restart the httpd and then observer cpu utilization come to 80-90 % and very small difference in free memory left but the execution time of the web pages repoted got minimised to 20-30 secs in our network.