Optimizing Dedicated Server

[Moonlight]

I am looking for some advice about how to optimize a Dedicated Server to run vBulletin correctly.

I have a Pentium 4, 2.4 Ghz, 1 gig RAM, 80 gig HD using CPanel.

I have installed MySQL 4.0.13, using the hack for using FULLTEXT search feature from MySQL, PHP Accelerator, vBulletin 2.3.1.

The server is having trouble handling the load.

There is currently 101 users connected and the load is above 1.

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!

[Chris M]

IMO there is nothing wrong with the load (i get loads of 2.00 1.20 0.97 and worse)...

But if you really want to optimise vBulletin, try installing a few "forumhome optimisation" hacks - One by Xenon, one by filburt, and any hacks that you have installed, make sure the templates are included in the "$templatesused" and that you try and run as few queries as possible...

Satan

[cirisme]

There's an entire forum on this on vbulletin.com.(the configuration forum )