1

Error code: 2013. Lost connection to MySQL server during query

1
2
3
4
5
6
7
8
9

[mysqld]
max_allowed_packet = 64M
connect_timeout = 30
net_read_timeout = 120
net_write_timeout = 120
innodb_buffer_pool_size = 6G
wait_timeout = 28800
interactive_timeout = 28800

1

mysql> SHOW GLOBAL STATUS LIKE  'Aborted_connects';

1

mysql> SET GLOBAL connect_timeout = 10;

1
2
3
4
5
6
7

mysql> SHOW GLOBAL STATUS LIKE  'Aborted_connects';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| Aborted_connects | 0     |
+------------------+-------+
1 row in set (0.00 sec)