Dual xeon with 4 sites - MySQL causing horrible loads

2025-04-14

I have a client who runs FSRS which I moved to a dual xeon 2.8, 1GIG RAM, RHE3 about 3 days ago. He has 3 sites that run the above script. I have done some tweaking and have also had Acunett overlook the server and make changes to apache and MySQL. I have upgraded from MySQL 4.0 to 4.1. Unfortunately what ever is done with this server the loads for MySQL never come under control. This is the second server (last one was a p4 2.8) that we have had the client on.

Here is my /etc/my.cnf file

[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
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=8
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

load average: 32.98, 20.12, 15.52 can get as high as 101.38 like it did yesterday. In the last 2 1/2 days the site has gotten 9828 Unique visitors. I have tried to contact the person who wrote the script to find out if anything could be done but have yet to hear from him.

Here is a top view....

28832 mysql 15 0 38988 38M 932 S 1.7 3.8 0:11 0 mysqld
28846 mysql 15 0 40908 39M 932 S 1.5 3.9 0:02 3 mysqld
28860 mysql 15 0 42744 41M 932 R 1.4 4.1 0:01 0 mysqld
28898 mysql 15 0 45652 44M 932 S 1.4 4.4 0:00 0 mysqld
28900 mysql 15 0 45652 44M 932 S 1.3 4.4 0:00 3 mysqld
28910 mysql 15 0 45652 44M 932 S 1.3 4.4 0:00 2 mysqld
28839 mysql 15 0 39960 39M 932 S 1.2 3.8 0:02 2 mysqld
28879 mysql 15 0 45100 44M 932 S 1.1 4.4 0:00 3 mysqld
28892 nobody 15 0 13808 12M 2188 D 1.1 1.2 0:00 1 httpd
28836 mysql 15 0 39564 38M 932 S 1.0 3.8 0:01 1 mysqld
28893 nobody 15 0 17364 15M 2212 D 1.0 1.5 0:00 1 httpd
28888 nobody 15 0 17208 15M 2172 D 0.9 1.5 0:00 2 httpd
28894 mysql 15 0 45652 44M 932 S 0.9 4.4 0:00 0 mysqld
23008 nobody 16 0 24816 21M 1760 D 0.8 2.1 0:02 1 httpd
23012 nobody 15 0 32800 25M 2008 D 0.8 2.5 0:03 1 httpd
28841 mysql 15 0 40268 39M 932 S 0.8 3.9 0:01 3 mysqld
28852 mysql 15 0 41704 40M 932 S 0.8 4.0 0:01 3 mysqld
22995 nobody 16 0 20844 18M 2192 S 0.7 1.8 0:03 3 httpd
23011 nobody 16 0 19668 17M 2532 S 0.7 1.7 0:03 1 httpd
28868 nobody 15 0 4932 3672 2080 S 0.7 0.3 0:00 3 httpd
28870 mysql 15 0 44024 42M 932 R 0.7 4.2 0:00 3 mysqld
28891 nobody 15 0 17228 15M 2188 D 0.7 1.5 0:00 3 httpd
11 root 15 0 0 0 0 RW 0.6 0.0 1:27 1 kswapd
28908 mysql 15 0 45652 44M 932 R 0.6 4.4 0:00 3 mysqld
28866 nobody 15 0 4872 3604 2032 S 0.5 0.3 0:00 0 httpd
28897 mysql 16 0 45652 44M 932 S 0.5 4.4 0:00 1 mysqld
11392 nobody 15 0 17676 15M 1988 D 0.4 1.5 0:25 0 httpd
22996 nobody 16 0 41620 32M 2036 D 0.4 3.2 0:03 3 httpd
11350 nobody 15 0 17464 15M 1928 D 0.3 1.5 0:28 3 httpd
23002 nobody 15 0 29768 27M 2064 D 0.3 2.7 0:03 2 httpd
28830 mysql 16 0 38688 37M 932 S 0.3 3.7 0:11 3 mysqld
28865 nobody 15 0 11648 9M 2020 S 0.3 0.9 0:00 3 httpd
28889 nobody 15 0 8100 6564 1912 S 0.3 0.6 0:00 2 httpd
28890 nobody 15 0 14188 12M 2196 D 0.3 1.2 0:00 1 httpd
12 root 16 0 0 0 0 RW 0.2 0.0 2:27 0 kscand
28729 root 16 0 1232 1232 872 R 0.2 0.1 0:00 3 top
28844 mysql 15 0 40648 39M 932 S 0.2 3.9 0:02 1 mysqld
28853 nobody 16 0 17172 15M 1996 S 0.2 1.5 0:01 2 httpd
28864 nobody 16 0 4980 3728 2096 S 0.2 0.3 0:00 2 httpd
28903 mysql 15 0 45652 44M 932 S 0.2 4.4 0:00 3 mysqld

Zend is installed and we tried to install MMcache but it broke the script.

Any ideas???? Dual xeon with 4 sites - MySQL causing horrible loads