PDA

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