Configuring Dedicated Server for vBulletin
I have a Pentium 4, 2.4 Ghz, 1 gig RAM, 80 gig HD using CPanel.
I have installed MySQL 4.0.12, using the hack for using FULLTEXT search feature from MySQL, PHP Accelerator, vBulletin 2.3.
The server is having trouble handling the load.
I recently restarted the HTTPD service, but normaly when I have let say 80 users, the server load becomes high. (It is near always above 1, sometime above 2)
Here is the top of the mysqlinfo.php output :
1:43pm up 2 days, 7 min, 0 users, load average: 0.86, 1.26, 1.27
130 processes: 111 sleeping, 4 running, 15 zombie, 0 stopped
Mem: 1023104K av, 1001456K used, 21648K free, 0K shrd, 97016K buff
Swap: 2048276K av, 23324K used, 2024952K free 731604K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
27514 nobody 17 0 6664 6180 3560 R 28.4 0.6 0:00 httpd
27563 nobody 16 0 1068 1068 832 R 16.1 0.1 0:00 top
27577 nobody 16 0 7072 6584 3488 R 8.4 0.6 0:00 httpd
27582 nobody 16 0 0 0 0 RW 0.0 0.0 0:00 httpd
Http processes currently running = 13
Mysql processes currently running = 51
Netstat information summary
2 SYN_RECV
2 SYN_SENT
4 FIN_WAIT1
5 ESTABLISHED
25 LISTEN
168 FIN_WAIT2
426 TIME_WAIT
Does anyone know what I should be doing to improve it?
Apache Config :
Timeout 300
KeepAlive On
MaxKeepAliveRequests 500
KeepAliveTimeout 8
MinSpareServers 5
MaxSpareServers 25
StartServers 8
MaxClients 512
MaxRequestsPerChild 0
MySQL Config :
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
max_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 128
wait_timeout = 3600
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 48M
query_cache_type = 1
skip-innodb
[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
Thanks!
