Hello,
 
we're using mysql 3.23.33 on a separate Linux server, but about 50% of all
connections go wrong and get an error like this: "Aborted connection 84620
to db: 'xxx' user: 'yyy' host: `aaa.bbb.cc.ddd.' (Got timeout reading
communication packets)". There are 3 frontends (Sun) webservers. We're
making about 15 connections per second. Has anybody any tips about the
configuration and give advice about how to prevent those errors. 
 
Sander.
 
my.cnf parameters: 
 
[client]
port            = 3306
socket          = /tmp/mysql.sock
 
# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
set-variable    = key_buffer=256M
set-variable    = max_connections=255
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=256
set-variable    = sort_buffer=1M
set-variable    = record_buffer=1M
set-variable    = myisam_sort_buffer_size=64M
set-variable    = thread_cache=16
set-variable    = thread_concurrency=8
log-bin
server-id       = 1
 
set-variable    = interactive_timeout=60
set-variable    = wait_timeout=60
set-variable    = connect_timeout=10
 
[mysqldump]
quick
set-variable    = max_allowed_packet=16M
 
[mysql]
no-auto-rehash

[isamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M
 
[myisamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M
 
[mysqlhotcopy]
interactive-timeout

 
 

Reply via email to