We have wordpress website with around 100k posts.
It is hosted on a dedicated server with a quad processor and 8gb memory. From time to time the server freezez and overloads.
It seems to be due to mysql overloading and using most of the CPU.
I am looking for a mysql and Centos guru to find out what is causing this issue and resolve it.