Portal Home > Knowledgebase > Articles Database > MySQL causing my server to run slow
MySQL causing my server to run slow
| Posted by GrannyCorp, 09-03-2008, 11:57 AM |
| I have an AMD 1.7MHz server running cPanel/WHM and Fedora 4. For some time it has been increasingly getting slower and slower. I'm stumped as to why. It only has nine accounts on it, one of which is of reasonable size using a phpBB forum with 1500 members, two are purely used for emails and the other six are very small websites, some only used as storage space. My server load is normally sitting in the high 6's but when I stop MySQL it plunges back down to very low 0's and 1's. When it restarts right enough it rockets back up to its normal 6's.
Can someone help?
Many thanks
|
| Posted by Sheps, 09-03-2008, 12:46 PM |
| Look at your slow queries log, or enable the slow queries log and take a look in there.
Might shed some insight as to why it is going slow. Other then that. How much ram? Are you closing up on your max available diskspace for /var? Have you tried looking at the processlist for MySQL and seeing what it lists?
|
| Posted by The Universes, 09-03-2008, 02:08 PM |
| Can you post your "top" output?
Use mytop to monitor the queries made and look for ones that are taking a long time to complete?
|
| Posted by GrannyCorp, 09-03-2008, 02:57 PM |
| Any good?
Many thanks
|
| Posted by The Universes, 09-03-2008, 03:06 PM |
| Can you post the header portion of top as well. Just wanted to make sure you dont have iowait or excessive swapping.
|
| Posted by GrannyCorp, 09-03-2008, 04:57 PM |
| Many thanks
|
| Posted by The Universes, 09-03-2008, 06:03 PM |
| It doesn't look like there is much CPU usage then. Grab one when the server is under heavy loads.
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
