Request for help with server optimization
 

I would like to request some advice, and here are my latest server answers to the sticky thread. Thanks very much in advance!

1. Dedicated server

2. Server Specs:
Intel Xeon Conroe 3060, 2x 2.4G cores, 4M L2
4GB RAM
2x Western Digital 250-Gig SATA-II, 7200rpm (Software RAID 1)
CentOS 5.3 (Linux 2.6.18-128.1.6.el5 #1 SMP Wed Apr 1 09:10:25 EDT 2009
x86_64 x86_64 x86_64 GNU/Linux)
Apache 2.2.10 pre-fork (from cPanel)
MySQL Ver 14.12 Distrib 5.0.67
PHP 5.2.6

3. vBulletin version: 3.8.1

4. Database tables: MyISAM

5. Default MySQL from cPanel

6. Top stats:
top - 20:37:09 up 21:12, 1 user, load average: 1.54, 0.98, 0.95
Tasks: 125 total, 1 running, 124 sleeping, 0 stopped, 0 zombie
Cpu0 : 61.0%us, 38.0%sy, 0.0%ni, 1.0%id, 0.0%wa, 0.0%hi, 0.0%si,
0.0%st
Cpu1 : 13.0%us, 3.0%sy, 0.0%ni, 82.0%id, 2.0%wa, 0.0%hi, 0.0%si,
0.0%st
Mem: 4037812k total, 2306272k used, 1731540k free, 292800k
buffers
Swap: 2048184k total, 4160k used, 2044024k free, 1067440k cached

7. /etc/my.cnf
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock

skip-locking
safe-show-database
#skip-innodb

max_connections = 500
max_user_connections = 40

key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 4M

table_cache = 1024
thread_cache_size = 10

wait_timeout = 10800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10

tmp_table_size = 16M

query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1


[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

#log_slow_queries=/var/log/slow-queries.log
#log-long-format
#long_query_time=6

8. MysQL Stats:
see http://server.passboards.org/mysql-stats.txt

9. there are other items on the server, but they are static html pages

10. average users online 100-200 max users 650, cookie timeout 7200

11. PHPInfo: http://server.passboards.org/phpinfo.php

12. KeepAlive Off
MaxKeepAliveRequests - default
KeepAliveTimeout - default (not defined)
MinSpareServers - default (not defined)
MaxSpareServers - default (not defined)
StartServers - default (not defined)
MaxClients - default (not defined)
MaxRequestsPerChild - default (not defined)

13. No 2GB+ log files reported.

14. uname + cpuinfo:

asoandrew@server [~]# uname -a
Linux server.passboards.org 2.6.18-128.1.6.el5 #1 SMP Wed Apr 1 09:10:25
EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

asoandrew@server [~]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 38912
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 38912
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

/proc/cpuinfo: http://server.passboards.org/cpuinfo.txt