Server Optimization Request

[gemanda]

Any help would be greatly appreciated! We're seeing server loads that are not at all proportionate to our user load, and no one can figure it out.

I'm attaching the requested info in a txt doc for ease of use.

Any questions, please let me know. Thanks!

[eva2000]

You're server load is for entire server and all shared sites not just your forums so the load isn't just yours.... If there are alot of shared VPS a/cs on the server then the load could be due to other sites in a cumulative effect.

Try the following suggestions and see if it helps

1. Upgrade PHP to 4.4.2
2. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards


[mysqld]
socket=/var/lib/mysql/mysql.sock
character-sets-dir=/usr/share/mysql/charsets/
safe-show-database
old_passwords
back_log = 50
skip-innodb
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 = 1800
thread_cache_size = 512
wait_timeout = 30
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

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

[mysqlhotcopy]
interactive-timeout


3. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367 - please remove Zend Optimizer from php.ini before installing APC Cache

4. If you just upgraded to vB 3.5.x try to disable these 4 options:

Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?

Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums

Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread

Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search

5. Edit httpd.conf values from

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 2
MaxSpareServers 5
StartServers 15
MaxClients 100

AND Maxrequestsperchild value = 5

to

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 6
MinSpareServers 15
MaxSpareServers 20
StartServers 15
MaxClients 150

AND Maxrequestsperchild value = 5000

restart apache

[gemanda]

You're server load is for entire server and all shared sites not just your forums so the load isn't just yours.... If there are alot of shared VPS a/cs on the server then the load could be due to other sites in a cumulative effect.

Huh...that's odd, because they're swearing to me that the load is my site only...

Thanks for the settings, I'll give them a go this weekend! :D

[gemanda]

Everything done except the APC...that failed miserably. I just cannot get it to run for all the tea in China.

Will try again tomorrow, I guess!