VERY High Server Load, Please Help!

Hello WHT,

First of all I am newbie at server optimization, ssh commands etc. so I really need your help!

My MySQL usage is quite high 171.57 %CPU same with my server load and it really slowed down my site, its probably because of my poorly coded mysql queries and overall mysql optimization so i removed most of the features on my site that use lots of mysql queries and reboot the server, after the reboot the site was fine for a few minutes but server loads goes to the roof again...

the info below is after second reboot

Fedora i686
Kernel Version: 2.6.14-1.1653_F***mp
Hardware Information:
Intel P4 Hyperthread Processor 3.0Ghz
1GB RAM
2 x 80GB IDE
Control Panel: WHM/cPanel

# uptime
23:27:59 up 29 min, 1 user, load average: 144.80, 129.14, 87.43

cpsrvd up
Server Load 145.34 (2 cpus)
Memory Used 30 %
Swap Used 0.00 %
Disk md2 (/) 11 %
Disk md0 (/boot) 21 %
Disk shm (/dev/shm) 0 %
Disk md1 (/tmp) 3 %

# netstat -nt | grep :80 -c
683

#top
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4743 mysql 16 0 733m 352m 1412 R 30.2 35.4 0:00.16 mysqld
4288 mysql 25 0 733m 352m 1412 R 20.8 35.4 0:19.71 mysqld
4037 mysql 25 0 733m 352m 1412 R 18.9 35.4 0:40.32 mysqld
4217 mysql 25 0 733m 352m 1412 R 18.9 35.4 0:26.99 mysqld
4338 mysql 25 0 733m 352m 1412 R 18.9 35.4 0:15.91 mysqld
4600 mysql 25 0 733m 352m 1412 R 18.9 35.4 0:04.90 mysqld
4240 mysql 25 0 733m 352m 1412 R 17.0 35.4 0:22.01 mysqld
4625 mysql 25 0 733m 352m 1412 R 17.0 35.4 0:04.65 mysqld
4108 mysql 25 0 733m 352m 1412 R 15.1 35.4 0:36.60 mysqld
4197 mysql 25 0 733m 352m 1412 R 9.4 35.4 0:21.77 mysqld
4599 mysql 25 0 733m 352m 1412 R 5.7 35.4 0:04.04 mysqld
4746 root 15 0 2276 1108 704 R 3.8 0.1 0:00.04 top
3393 nobody 16 0 10536 4184 1692 S 1.9 0.4 0:02.03 httpd
3450 nobody 16 0 10640 4664 2124 S 1.9 0.5 0:01.87 httpd
1 root 16 0 1744 568 492 S 0.0 0.1 0:00.69 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 39 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0

Is this just really a problem on my mysql queries or is there anything else wrong with my server?

Please let me know if you need more info...

Thanks a lot

 

 

 

 

Top