I have this nagging problem that come up again and again once or twice a month
[COLOR=#FF0000]High Server CPU Load !!!
Then i have to [COLOR=#0000FF]reboot the server, i have no other options…
During the course of my trouble shooting i have learnt that database server shows over [COLOR=#FF0000]3000 concurrent connections from the web server, Where as there are not that many users in the organization !!!, The average concurrent users is generally between [COLOR=#0000FF]50-100.
Also, my free memory gets exhausted completely !!!
I have also run the pt-kill command to check the queries that are taking more than 30 seconds to execute, i do get them and i also use the pt-kill utility to kill those, but it does no good
I also tried this query from Peter Zaitsev locate at mysqlperformanceblog but in vein
What i would like to know is, Why does it only happen some time, and how can i isolate the cause of the issue, What is the reason behind this crash and why can my server not keep up !!
Any suggestions would be highly appreciated !!
Thank you all !