MySQL 4.1 reject connection

This is a MySQL4.1 on Windows 2003 web server with 2GB memroy and dual xeon.

Current MySQL connection is between 40 -70 per second. The database size is around 1GB, php message board web site.

Every few minute, mysql will reject connection for a few seconds then back to normal. Connectivity is ok when there are over 100 concurrent connection but may be rejected when there is 40 connection.

mysql.ini:

basedir="C:/Program Files/MySQL/MySQL Server 4.1/"
datadir="C:/Program Files/MySQL/MySQL Server 4.1/Data/"
default-character-set=latin1
default-storage-engine=INNODB
max_connections=500
query_cache_size=256M
table_cache=256
tmp_table_size=185M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=369M
key_buffer_size=318M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#skip-innodb
innodb_additional_mem_pool_size=13M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=7M
innodb_buffer_pool_size=616M
innodb_log_file_size=50M
innodb_thread_concurrency=16
#secure-auth
#secure-auth
#old-passwords

 

 

 

 

Top