Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do when there are a large number of Aborted connection in the Percona MySQL log, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

After a colleague uses Web Logic to connect to a set of MySQL databases, the debug option cannot be enabled

Check the error log of the database, which contains a lot of the following information

Aborted connection (Got an error reading communication packets)

...

The size of a single packet when transmitted over a max_allowed_packet network. The default value is 4MB. The initial value of the package information cache is specified by net_buffer_length, but the package may grow to the value set by the max_allowed_packet parameter. If you want to use BLOB fields or long strings, you need to

Increase the value of this parameter. The value of this parameter needs to be set to the same size as the largest BLOB field. The protocol limit for the max_allowed_packet parameter is 1GB. This parameter should be an integer multiple of 1024.

Check the max_allowed_packet parameter and find that only 4m is set

Mysql > show global variables like 'max_allowed_packet'

+-+ +

| | Variable_name | Value |

+-+ +

| | max_allowed_packet | 4194304 | |

+-+ +

1 row in set (0.00 sec)

Mysql > select 4194304 Compact 1024 Accord 1024

+-+

| | 4194304 / 1024 / 1024 | |

+-+

| | 4.00000000 |

+-+

1 row in set (0.00 sec)

Change this parameter to larger, and then the error disappears. Web Logic can enable the debug option normally.

Mysql > set global max_allowed_packet=50*1024*1024

Query OK, 0 rows affected (0.00 sec)

On the Percona MySQL log there are a large number of Aborted connection how to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.