Aborted connection 11545 to db: 'eximstats' user: 'eximstats' host: `localhost' (Got
After optimizing my.cnf, all is working fast but I am receiving this:
Aborted connection 11545 to db: 'eximstats' user: 'eximstats' host: `localhost' (Got timeout reading communication packets)
my.cnf:
PHP Code:
[mysqld]
user=mysql
set-variable = max_connections=500
safe-show-database
set-variable = max_allowed_packet=16M
skip-innodb
set-variable = query_cache_limit=1M
set-variable = query_cache_size=12M
set-variable = query_cache_type=1
set-variable = interactive_timeout=80
set-variable = wait_timeout=45
set-variable = connect_timeout=14400 // I have lifted this up as advised this would solve this issue - obviously doesn't
set-variable = thread_cache_size=24
set-variable = key_buffer=12M
set-variable = join_buffer=1M
set-variable = table_cache=1024
set-variable = record_buffer=1M
set-variable = sort_buffer_size=2M
set-variable = read_buffer_size=2M
set-variable = max_connect_errors=10
set-variable = thread_concurrency=2
set-variable = myisam_sort_buffer_size=16M
server-id=1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=4096
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
set-variable = key_buffer=16M
set-variable = sort_buffer=8M
set-variable = read_buffer=8M
set-variable = write_buffer=8M
[myisamchk]
set-variable = key_buffer=16M
set-variable = sort_buffer=8M
set-variable = read_buffer=8M
set-variable = write_buffer=8M
[mysqlhotcopy]
interactive-timeout