Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about what mysql max_allowed_packet query and modification is like. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Brief introduction

Mysql limits the packet size accepted by server based on the configuration file. Sometimes large inserts and updates are limited by the max_allowed_packet parameter, resulting in failure.

Query show variables like 'max_allowed_packet'

The result displayed is:

+-+ | Variable_name | Value | +-+-+ | max_allowed_packet | 4194304 | +-+-+

The current configuration is as follows: 4m

Modify # vim / etc/my.cnfmax_allowed_packet = 20M# service mysqld restart after reading the above, do you have any further understanding of the mysql max_allowed_packet query and modification? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.