I have a site on a dedicated, has been running smoothly for 2 months now, and suddenly with no reason, the site slowed down dramatically. I checked to make sure it wasn't a ddos, and concluded that it wasn't a ddos since the apache wasn't overloaded and the site is still up but just take a long time to load. I got a feeling it's something to do with Mysql but can't find the problem. Can someone help? I can pay $$$, by the way it's running CentOS, DirectAdmin
Run the following query in MysqL: "show processlist" That will show you all the users connected to MySQL and what they are doing at that exact second. If you see any that look suspicious, then type "kill xx" where xx is the ID of that user. That will kick them off the server. What you could have is a bunch of zombie processes running wild on your database, which would slow it down if you have a lot of them.
Sometimes, you have to repair database ..This will improve the performance after that. A full check on your server is require since we are not sure whether it is mysql causing the problem.. -- joseph