Best Server configuration for Heavy vBulletin Forums

July 28th, 2010

Vbulletin logo

I was tortured for long time trying to get my growing forum working with out issue and MySql Errors

that was annoying , and after 1 year searching for a solution , i understand that the key to solve this problem is all about the hard disk of the server

i made a cool but a little expensive server configuration that solved all forum issues/errors

and these are list of error’s that stopped appearing on my site after the new server setup

mysql_connect(): Too many connections

Error code 1153: Got a packet bigger than ‘max_allowed_packet’ bytes

Socket Connection Error

Lost connection to MySQL server during query

MySQL server has gone away

my forum get about 100k unique visitors daily, so this configuration might not be for , but you will get the idea

4 HD’s SCSI 15k rpm

RAID 10

or if you can spend some more money of this and make sure 100% that everything is fine , you might want to have a look at

the SSD ( Solid Stat Drive ) which has built-in memory,

these HD’s mentioned above are the best on the market today , and if you add the RAID 10 controlled you will get incredible performance , for writing and reading from database

and i had also 18 GB of RAM

and the processor was Dual XEON 5570 QuadCore

and now i will show you how my MySql config file was optimized

[mysqld]
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 384M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800

thread_cache_size = 384
wait_timeout = 7200
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 1000
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size =128M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
default-storage-engine = MyISAM

[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

Thats It , i think there will be no problem serving busy forums with these configurations

Incoming search terms for the article:

Share|

Categories: Dev / Design, Technical

Tags: configuration, connections, database, database error, error, memory, mysql, server, time out, vbulletin Leave a comment

2 Comments

CLPK23-180 August 11th, 2011
Magnificent put up, helped me out. Maintain up the first class posts!
jackie August 28th, 2011
Hi, I read mostly all the post of this blog. Many thanks for the useful post.Keep on posting.Do you have facebook account?.Thanks.Regards

wShare