httpd and mysqld keeps failing!
I have about 35 accounts on the server and none really busy, my most active account has only 30 users online at any given time. Though he has a game on his message boards which causes lots of refreshes and at a fast rate.
Here is my.cnf:
PHP Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=512K
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
PHP Code:
top - 11:14:25 up 22:22, 1 user, load average: 14.29, 13.72, 10.47
Tasks: 244 total, 10 running, 233 sleeping, 1 stopped, 0 zombie
Cpu(s): 67.8% us, 28.8% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 3.4% si
Mem: 970848k total, 680712k used, 290136k free, 30708k buffers
Swap: 917272k total, 3088k used, 914184k free, 413024k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8749 mysql 16 0 98436 27m 3756 R 32.8 2.9 0:02.87 mysqld
5596 mysql 16 0 98744 27m 3756 S 26.2 2.9 0:13.71 mysqld
9655 nobody 15 0 14048 8108 10m S 13.1 0.8 0:00.12 httpd
9462 mysql 16 0 98436 27m 3756 S 8.2 2.9 0:00.96 mysqld
9630 nobody 15 0 14064 8148 10m S 4.9 0.8 0:00.47 httpd
9632 root 16 0 3448 1008 1624 R 3.3 0.1 0:00.43 top
9639 nobody 15 0 14044 8124 10m S 3.3 0.8 0:00.29 httpd
9653 nobody 15 0 13764 7788 10m S 3.3 0.8 0:00.03 httpd
3300 toastedg 15 0 6260 2928 4060 S 1.6 0.3 0:03.49 proftpd
9428 mysql 16 0 98436 27m 3756 S 1.6 2.9 0:01.16 mysqld
9442 mysql 17 0 98436 27m 3756 R 1.6 2.9 0:00.51 mysqld
9626 nobody 15 0 14616 8724 10m S 1.6 0.9 0:00.48 httpd
1 root 16 0 3160 460 1320 S 0.0 0.0 0:01.38 init
2 root 34 19 0 0 0 R 0.0 0.0 0:00.16 ksoftirqd/0
3 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
4 root 10 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
5 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
19 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
29 root 15 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
30 root 15 0 0 0 0 S 0.0 0.0 0:03.58 pdflush
32 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
20 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
31 root 15 0 0 0 0 S 0.0 0.0 0:18.96 kswapd0
105 root 25 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
172 root 15 0 0 0 0 S 0.0 0.0 0:20.40 kjournald
1021 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
1555 root 16 0 3088 568 1300 S 0.0 0.1 0:18.33 syslogd
1559 root 16 0 1932 448 1248 S 0.0 0.0 0:00.06 klogd
1592 root 16 0 1624 556 1300 S 0.0 0.1 0:00.14 rpc.idmapd
1661 nobody 16 0 5536 2196 3744 S 0.0 0.2 0:00.39 proftpd
1672 root 16 0 2868 740 1372 S 0.0 0.1 0:00.00 smartd
1681 root 19 0 2176 464 1240 S 0.0 0.0 0:00.00 acpid
2651 named 18 0 44268 9584 4776 S 0.0 1.0 0:00.00 named
2686 root 16 0 3952 1432 3440 S 0.0 0.1 0:00.00 sshd
2699 root 16 0 2896 828 1688 S 0.0 0.1 0:00.10 xinetd
2717 root 15 0 9436 3260 6116 S 0.0 0.3 0:03.06 chkservd
2779 mailnull 16 0 7528 1784 6284 S 0.0 0.2 0:00.18 exim
PHP Code:
root@hostname [~]# pidof mysqld
9463 9462 9461 9460 9459 9455 9454 9453 9452 9444 9442 9432 9430 9429 9428 9427 9424 9423 8811 8798 8795 8794 8788 8786 8784 8782 8762 8761 8753 8751 8749 8738 8718 8717 8716 8715 8708 8251 8250 8225 8224 8223 8221 8216 8214 8210 8208 8207 8202 8200 8198 8196 8192 8186 5727 5725 5718 5717 5714 5706 5705 5700 5698 5697 5693 5691 5690 5689 5684 5682 5678 5677 5676 5670 5669 5667 5664 5663 5661 5660 5653 5652 5651 5646 5643 5634 5626 5625 5622 5618 5612 5605 5603 5602 5601 5598 5596 5595 5594 5592 5591 5590 5589 5587 5586 5585 5582 5578 5577 5574 5572 5540 5539 5533 5532 5531 5530 5529 5515 5514 5512 5511 5510 5508 5506 5490 5487 5484 5479 5478 5474 5473 5472 5471 5469 5468 5464 5463 5462 5461 5460 5450 5449 5443 5441 5439 5433 5432 5431
root@hostname [~]# pidof httpd
9458 9457 9456 9449 9448 9443 9426 9425 9422 9421 9420 9419 9418 9417 9416 9415 9414 9413 9412 9411 9410 9409 9408 9407 9406 9405 9404 9403 9391 9389 9388 9387 9386 9385 9384 9383 9382 9375 9374 9373 9372 9370 9369 9368 9270 9251 9250 9248 9246 9245 9244 9224 9223 9221 9206 9205 9204 9203 9202 9201 9190 9189 9188 9187 9186 9185 9152 9151 9150 9149 9148 9147 9146 9145 9144 9143 9142 9141 9140 9139 9138 9137 9136 9134 8953 8952 8950 8943 8942 8940 8937 8928 8927 8924 8923 8920 8919 8918 8916 8915 8914 8913 8912 8911 8910 8909 8908 8907 8906 8905 8904 8903 8902 8901 8900 8899 8898 8897 8896 8895 8894 8890 8889 8888 8887 8886 8885 8884 8883 8882 8880 8879 8878 8877 8876 8875 8874 8873 8871 8870 8869 8868 8867 8866 8865 8863 8862 8861 8860 8859 8851
