debugsqlModerate
error 2013 (hy000) lost connection to mysql server during query while load of mysqldump
Viewed 0 times
errorlostwhileduringquerymysqldumploadmysqlhy000server
Problem
I'm trying to load
ERROR 2013 (HY000) at line X: Lost connection to MySQL server during
query
I tried to increase these values, but I keep getting that error no matter what( What else can I do to overcome this error?
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 = 16MI 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.
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.