high cpu and time processes... load average high

[alexd]

is there any way to stop this ?

00:31:54 up 3 days, 20:05, 1 user, load average: 10.40, 11.56, 14.34
139 processes: 130 sleeping, 7 running, 0 zombie, 2 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 187.8% 0.0% 10.4% 0.0% 1.4% 0.0% 0.0%
cpu00 92.2% 0.0% 6.1% 0.0% 1.5% 0.0% 0.0%
cpu01 95.6% 0.0% 4.3% 0.0% 0.0% 0.0% 0.0%
Mem: 511384k av, 475256k used, 36128k free, 0k shrd, 9952k buff
348084k actv, 41380k in_d, 6720k in_c
Swap: 1044216k av, 418000k used, 626216k free 104500k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
15301 mysql 15 0 88276 56M 1256 S 116.4 11.2 9:25 1 mysqld
22931 root 15 0 7784 608 524 S 81.5 0.1 937:15 1 httpd
24635 root 15 0 1312 1312 912 R 0.3 0.2 0:00 0 top
1 root 15 0 508 476 452 S 0.0 0.0 0:11 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
5 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
6 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1

[kris1351]

The first thing would to optimize your my.cnf so it can handle quicker and better. Another big thing is that you only have 512mb memory and you need to upgrade it.

[EdRooney]

What are the optimal setting for my.cnf?

[alexd]

Hi:

1) I have tested each configuration possible in my.cnf... I have tested about 30 possibilities... i do not know what is the optimum one...

2) I refer to processes that eat a lot of CPU... i mean... is there any way to set in the system that NO process can grow so much ?

[hostcp3]

If this is not a long term issue and has only started in the last week, REBOOT

will clear up a lot of old processes which appear to be getting locked on.

Hi:

1) I have tested each configuration possible in my.cnf... I have tested about 30 possibilities... i do not know what is the optimum one...

2) I refer to processes that eat a lot of CPU... i mean... is there any way to set in the system that NO process can grow so much ?

[chirpy]

Clearly the biggest problem that you have is memory thrashing. Your swap file use is simply too high and the server is in desperate need of another 512MB of RAM. It's either that, or remove apps/processes that you do not need, or move some users off of the server to another one. Inevitably, there are only finite resources and the server as configured is in excess of them.

Rebooting is not necessary at all - that's a Windows response, Linux simply doesn't need it, unless you're installing a new kernel.