Apache and MySQL issue, slows down machine badly
I have put into a test server
P4 2.8GE
1024MB DDR Ram
120GB SATA Harddisk
Fedora Core 2
DirectAdmin
Everytime when there is someone logging into the forum which locates into that server, in the "top" it appears many httpd PID and MySQL PID. Which this do not happen to my Fedora Core 1 server.
This seems to be abnormal so I come here and asked. It ususally if there is 100 connections, it will count as 1x PID of httpd. But now is 100x PID of httpd! and user is naming as apache
Then it is slowing down the MySQL query time to 15seconds for 9 queries~
In the old machine, it should be around 4 seconds because it was a Celeron 2.0Ghz and 512MB DDR Ram, Fedora Core 1
hope someone could help.
Also, the server is idle, the Tasks is 180~ sleeping~
sample of the top..because the forum is closed for checking..so thats why it doesnt show a lot of httpd in the top
top - 13:04:29 up 1 day, 13:10, 1 user, load average: 0.00, 0.00, 0.00
Tasks: 178 total, 1 running, 177 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.5% us, 0.7% sy, 0.0% ni, 98.8% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 1018644k total, 779796k used, 238848k free, 115792k buffers
Swap: 2040244k total, 0k used, 2040244k free, 537588k cached
9264 root 16 0 2600 968 1620 R 0.7 0.1 0:00.40 top
9195 apache 15 0 20444 12m 17m S 0.3 1.2 0:00.07 httpd
9196 apache 15 0 20444 12m 17m S 0.3 1.2 0:00.05 httpd
9211 apache 15 0 20992 13m 17m S 0.3 1.3 0:00.06 httpd
9214 apache 15 0 20444 12m 17m S 0.3 1.2 0:00.04 httpd
1 root 16 0 2504 464 1316 S 0.0 0.0 0:05.23 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
8 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
9 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/1
10 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
11 root 12 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
12 root 15 0 0 0 0 S 0.0 0.0 0:00.10 pdflush
Tasks: 178 total, 1 running, 177 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.5% us, 0.7% sy, 0.0% ni, 98.8% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 1018644k total, 779796k used, 238848k free, 115792k buffers
Swap: 2040244k total, 0k used, 2040244k free, 537588k cached
9264 root 16 0 2600 968 1620 R 0.7 0.1 0:00.40 top
9195 apache 15 0 20444 12m 17m S 0.3 1.2 0:00.07 httpd
9196 apache 15 0 20444 12m 17m S 0.3 1.2 0:00.05 httpd
9211 apache 15 0 20992 13m 17m S 0.3 1.3 0:00.06 httpd
9214 apache 15 0 20444 12m 17m S 0.3 1.2 0:00.04 httpd
1 root 16 0 2504 464 1316 S 0.0 0.0 0:05.23 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
8 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
9 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/1
10 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
11 root 12 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
12 root 15 0 0 0 0 S 0.0 0.0 0:00.10 pdflush
Thanks
