high cpu usage

[Grey F0x]

hello
i have a vps with 550 ram and 8core cpu with 1,5ghz dedicated cpu for every core and i have a high cpu usage

here are some logs

top - 20:33:13 up 9:22, 0 users, load average: 0.08, 0.02, 0.01

Tasks: 23 total, 1 running, 22 sleeping, 0 stopped, 0 zombie

Cpu(s): 0.1%us, 0.0%sy, 0.0%ni, 99.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st

Mem: 563200k total, 136420k used, 426780k free, 0k buffers

Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

1 root 15 0 1872 664 564 S 0 0.1 0:00.65 init

1742 daemon 15 0 21848 9928 3292 S 0 1.8 0:45.04 httpd

11865 postfix 15 0 4752 1628 1316 S 0 0.3 0:00.00 pickup

15510 postfix 15 0 4788 1984 1644 S 0 0.4 0:00.03 local

26178 root 18 0 1564 620 492 S 0 0.1 0:00.28 syslogd

26217 root 25 0 2600 1336 1084 S 0 0.2 0:00.00 mysqld_safe

26258 mysql 15 0 95820 20m 4580 S 0 3.8 0:17.64 mysqld

26259 root 25 0 1480 504 440 S 0 0.1 0:00.00 logger

26328 root 15 0 20992 9188 3408 S 0 1.6 0:00.10 httpd

26345 daemon 17 0 19796 6828 2020 S 0 1.2 0:00.00 httpd

26407 root 15 0 4748 1624 1304 S 0 0.3 0:00.23 master

26418 postfix 18 0 4792 1728 1388 S 0 0.3 0:00.28 qmgr

26420 root 18 0 4856 1096 768 S 0 0.2 0:00.00 sshd

26442 root 18 0 4556 668 400 S 0 0.1 0:00.00 squid

26444 daemon 16 0 7228 5164 1568 S 0 0.9 0:09.88 squid

26454 root 15 0 2140 896 708 S 0 0.2 0:00.04 cron

26472 daemon 18 0 1344 296 244 S 0 0.1 0:00.00 unlinkd

26475 daemon 15 0 21876 9964 3292 S 0 1.8 0:48.74 httpd

26485 daemon 15 0 21844 9m 3292 S 0 1.8 0:46.61 httpd

26486 daemon 16 0 25768 13m 3296 S 0 2.4 0:47.48 httpd

26487 root 15 0 9540 5932 1400 S 0 1.1 0:00.12 miniserv.pl

32503 daemon 15 0 2164 972 764 R 0 0.2 0:00.00 top

32606 postfix 18 0 4816 1696 1372 S 0 0.3 0:00.02 cleanup

the id is 99% my forum has 1300 members and 7000 posts.

any suggestion?

thank you

[envonge]

Your cpu usage is basically 100% idle how is that a lot of usage?

[rct2·com]

the id is 99% my forum has 1300 members and 7000 posts.

id = IDLE :)

[Grey F0x]

:blink: :blush: oups sorry i thought that it was 99% usage.
an other stupid question in the system overview i can not see the ram usage

Current Server Load 0.00
Total Server Memory MB
Available Physical Memory MB

do you know why?
thank you

[rct2·com]

No. But from your original post:

Mem: 563200k total, 136420k used, 426780k free, 0k buffers

Swap: 0k total, 0k used, 0k free, 0k cached

That suggests that your server is either very, very lightly loaded, or you have a sub-optimal Apache and MySQL configuration. MySQL would LOVE to cache a lot of your tables in memory if you let it. :)

You also have NO disk allocated as meory cache [Swap: 0k total]. That isn't very clever either.

[Grey F0x]

thank you but how can i change all this settings?
and make the best performance?
thank you

[rct2·com]

As I understand it, the 'swap' size is decided when the operating system is installed. I don't know how to change it post-installation, sorry.

As for MySQL tuning, there are no hard and fast rules. It all depends on actual database usage. I have found www.mysqltuner.com useful, but it needs lots of iterations and gradual changes over time.