Server Optimization
[HARDWARE]
Intel Celeron 1.7 GHz, 400 MHz FSB
1 GB ECC RAM
60 GB hard drive
500 GB Monthly
[MY.CNF]
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
safe-show-database
set-variable = max_connections=300
set-variable = key_buffer=128M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=64
set-variable = wait_timeout=15
set-variable = connect_timeout=10
set-variable = max_connect_errors=10
set-variable = thread_concurrency=2
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = interactive_timeout=30
skip-innodb
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
[HTTPD.CONF]
Timeout 300
KeepAlive On
MaxKeepAliveRequests 0
KeepAliveTimeout 15
ServerLimit 1024
StartServers 16
MinSpareServers 16
MaxSpareServers 64
MaxClients 300
MaxRequestsPerChild 0
[TOP]
19:38:13 up 8 min, 1 user, load average: 15.20, 7.75, 3.34
259 processes: 247 sleeping, 12 running, 0 zombie, 0 stopped
CPU states: 83.1% user 7.1% system 0.0% nice 0.0% iowait 9.7% idle
Mem: 1022796k av, 715280k used, 307516k free, 0k shrd, 8956k buff
654832k actv, 1580k in_d, 3684k in_c
Swap: 1052248k av, 40292k used, 1011956k free 70864k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
1116 root 15 0 6748 4336 4248 S 92.7 0.4 4:14 0 httpd
1034 mysql 15 0 6180 5048 1320 S 4.9 0.4 0:31 0 mysqld
[OTHER]
Only one website is on the dedicated server, a Invision Board forum.
Usually there is around 100-200 users, with peak around 400
When there is many users the load sometimes gradually climbs to 40+, and the website stops functioning, or is extremely slow.
Does anyone see anything wrong with these things? Why does load always seem to gradually climb and not go back down? Any suggestions and improvements? I would like to reduce my server load. Thanks.
