The Ultimate Guide to High Availability with MariaDB

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

When I am trying to execute a query from some large table it turns out that connection to DB is lost: ERROR 2013 (HY000): Lost connection to MySQL server during query I am running a query directly on the DB server:

I have allready issued some configuration in my.cnf but the problem persist:

net_read_timeout=600 net_write_timeout=180 wait_timeout=86400 interactive_timeout=86400

  1. max_allowed_packet=128M key_buffer_size = 2560M max_allowed_packet = 7500M thread_stack = 1M thread_cache_size = 16 innodb_buffer_pool_size = 20G read_buffer_size = 128M read_rnd_buffer_size = 256M sort_buffer_size = 3G query_cache_size = 1024M innodb_force_recovery = 4

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.