Guys i am despert here, already get this problem for a week sometime suddenly get high load, and still dont find where is the problem yet
normally the top result like this, load only 0.71, only have 200+ tasks
screenshots : i291.photobucket.com/albums/ll284/basketmen/topnormal3.jpg
other screenshots : i291.photobucket.com/albums/ll284/basketmen/topnormal2.jpg
but sometime suddenly get high load (usually 1-3 times a day), load very high 90-200, with 500+ tasks
screenshots : i291.photobucket.com/albums/ll284/basketmen/tophighload1.jpg
other screenshots : 291.photobucket.com/albums/ll284/basketmen/tophighload2.jpg
Daily Process Log, i already repair and optimize all table, like you can see the mysql process is very low (in white line, not in yellow or red line), so its looks like the problem is not in mysql
The red line is maybe apache
screenshots : i291.photobucket.com/albums/ll284/basketmen/DailyProcessLog.jpg
Nb1. I use a dedicated server, only host 1 site, here is my server specs
Intel Single Xeon E3110 3.0ghz L2 cache 6MB
Memory 4 GB DDR2 RAM
Harddisk 500 GB Sata 7200rpm
Cent OS 5.4
WHM/Cpanel
Nb2. I already check no backup/cronjob or related scheduled active right now
Nb3. I already disabled the feature one by one, Even i already block all search engine spider now using robots.txt disallow for 2 days, no spiders again in my website until the problem found, its ok i just need to found the source problem
Nb4. I dont think my hosting support can help it, and they cost very expensive for that extra managed service ($69/hour), i want to find the source problem by my self, please analyze and give advice to found the source problem
its your disk io
look at your 2nd screenshot 96.2 wa.
get a faster disk.
what do you host/run? blog, forum, image manipulation, video encoding?
its running a forum,
current harddisk are Harddisk 500 GB Sata 7200rpm, what do you recommend?
do you think no problem with other hardware, like the memory?
|
its running a forum,
current harddisk are Harddisk 500 GB Sata 7200rpm, what do you recommend? do you think no problem with other hardware, like the memory? |
it looks like the machine has started to use some swap memory, but doesnt seem too bad yet.
the high disk oi number seems to be the problem. im betting you’re getting a bunch of reads/writes with your db. maybe get a seperate disk for db, or maybe even another machine altogether.
how much of those 500gb are you currently using? have you thought about using a solid state drive?
what do you think if i add Memory 4 GB DDR2 RAM again? so the total will be 8GB, do you think its enough so not get high load again?
maybe. when you server falls back to using swap, that could be when your disk io sky rockets.
Might be helpful to see the full process list. Sort processes by longest running or the most memory being used. But my guess here is your disk is the culprit.
mysqladmin status
hdparm -tT /dev/sda
Increase RAM, optimise your my.cnf so MySQL uses caching more efficiently.
That said, a single 500GB hard drive is pretty pitiful - if you’re not using any of it at all think about moving to an SSD or if not a high RPM SAS drive. Forums are primarily SQL driven I/O is going to be your bottleneck.
Something you might want to think about after optimising but possibly before throwing more hardware at the situation is using something like varnish in front of your web site for non logged in users. This will cache pages/threads for ‘guests’ (you can set the caching period as well, but even setting it as low as 1-5 minutes will still give the impression of a busy forum, but cut down on your SQL query load massively)