MySQL Forums
Forum List  »  General

error: 2013: Lost connection to MySQL server at 'reading initial communication packet', system error: 54
Posted by: Daniel Gerzo
Date: May 11, 2009 06:43AM

Hello,

we are running a pretty busy mysql server and every now and then we get the following message from your php app. The app is connecting to a remote mysqld:

error: 2013: Lost connection to MySQL server at 'reading initial communication packet', system error: 54

Do you guys have an idea what may cause this?

Server version: 5.1.34 FreeBSD port: mysql-server-5.1.34
FreeBSD 7.2-RELEASE #1: Mon May 4 16:03:55 CEST 2009
CPU: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz (1995.01-MHz K8-class CPU)
Cores per package: 4
usable memory = 8582840320 (8185 MB)

my.cnf:
[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
bind-address = xx.xx.xx.xx
port = 3306
socket = /tmp/mysql.sock
skip-name-resolve
skip-locking
long_query_time = 3
slow_query_log = /data/mysql/mysql-slow-queries.log
key_buffer = 1G
max_allowed_packet = 32M
table_cache = 2048
wait_timeout = 30
interactive_timeout = 30
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
join_buffer_size = 4M
myisam_sort_buffer_size = 256M
thread_cache_size = 8
max_heap_table_size = 768M
tmp_table_size = 768M
thread_concurrency = 8
ft_min_word_len=3
ft_stopword_file=/data/mysql/stopwords.txt
max_connections=3072
max_connect_errors=9999
collation_server=utf8_unicode_ci
character_set_server=utf8
server-id = 1
tmpdir = /tmp/

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 384M
sort_buffer_size = 384M
read_buffer = 24M
write_buffer = 24M

[myisamchk]
key_buffer = 384M
sort_buffer_size = 384M
read_buffer = 24M
write_buffer = 24M

[mysqlhotcopy]
interactive-timeout

Thanks!



Edited 1 time(s). Last edit at 05/11/2009 06:43AM by Daniel Gerzo.

Options: ReplyQuote


Subject
Written By
Posted
error: 2013: Lost connection to MySQL server at 'reading initial communication packet', system error: 54
May 11, 2009 06:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.