View Full Version : Server optimization required? VB is crashing IIS
Adnan
Tue 13th Jan '04, 7:58am
Hi,
Time to time the Forum stops. IIs crashes and the forum becomes very slow or stops.
Pls find attached server details,
http://forum.antu.com/
Adnan
eva2000
Wed 14th Jan '04, 3:40am
1. upgrade to vB 2.3.4
2. change my.cnf to below and restart mysql and see how that goes
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
bind-address = 127.0.0.1
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 = 64
wait_timeout = 2400
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
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
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=xxxx
password=*****
QueryInterval=1
vBulletin® v3.8.0 Beta 3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.