HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlModerate

error 2013 (hy000) lost connection to mysql server during query while load of mysqldump

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
errorlostwhileduringquerymysqldumploadmysqlhy000server

Problem

I'm trying to load mysqldump and I keep getting following error:


ERROR 2013 (HY000) at line X: Lost connection to MySQL server during
query

/etc/my.cnf:

[mysqld]
max_allowed_packet = 16M
net_read_timeout = 30
net_write_timeout = 60
...
[mysqldump]
max_allowed_packet = 16M


I tried to increase these values, but I keep getting that error no matter what( What else can I do to overcome this error?

Solution

If all the other solutions here fail - check your syslog (/var/log/syslog or similar) to see if your server is running out of memory during the query.

Had this issue when innodb_buffer_pool_size was set too close to physical memory without a swapfile configured. MySQL recommends for a database specific server setting innodb_buffer_pool_size at a max of around 80% of physical memory, I had it set to around 90%, the kernel was killing the mysql process. Moved innodb_buffer_pool_size back down to around 80% and that fixed the issue.

Context

StackExchange Database Administrators Q#124964, answer score: 11

Revisions (0)

No revisions yet.