2

This question already has an answer here:

I'm using MySQL Community Server 5.7.15-log and MySQL Connector/ODBC 5.3.6 on Windows 2012 and getting a lot of these messages:

[Note] Aborted connection X to db: 'Y' user: 'Z' host: 'localhost' (Got an error reading communication packets)

I have max_allowed_packet set to 1G:

mysql> SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet';
+--------------------+------------+
| Variable_name      | Value      |
+--------------------+------------+
| max_allowed_packet | 1073741824 |
+--------------------+------------+
1 row in set (0.14 sec)

mysql> 

Any advice?

marked as duplicate by Paul White May 23 '17 at 15:11

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • How much RAM? I would not recommend having max_allowed_packet higher than 2% of RAM. – Rick James Oct 3 '16 at 5:12
  • "Any advice?" Any idea what was experienced and what was happening on the other side of the connections at the time of the error? What error if aby did the client library or calling code see? I ask that because I assume this message is from the server (not the client) error log, but you might want to make that clear. – Michael - sqlbot Oct 3 '16 at 5:31
  • Refer: percona.com/blog/2016/05/16/… They explained it very nicely. – user125368 May 23 '17 at 9:55

Browse other questions tagged or ask your own question.