2

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?

Improve this question
3
  • How much RAM? I would not recommend having max_allowed_packet higher than 2% of RAM.
    – Rick James
    Oct 3, 2016 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, 2016 at 5:31
  • Refer: percona.com/blog/2016/05/16/… They explained it very nicely.
    – user125368
    May 23, 2017 at 9:55

0

Reset to default

Browse other questions tagged or ask your own question.