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

How to mysql database 1024 problem, many novices are not very clear, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

The max_allowed_packet will be reset to 1024, which will cause the project to be unable to access the database during the query or insert operation. The following error is reported:

Com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4357 > 1024). You can change this value on theserver by setting the max_allowed_packet' variable.

I have also seen a lot of solutions to this problem on the Internet, most of which are set global max_allowed_packet = 2 "1024" 1024 "10 (need to restart the database) in / etc/my.cnf; but this setting will also lead to the same problems as before.

I detected that the database was not restarted after the max_allowed_packet was reset to 1024. Does anyone encounter this problem?

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, 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.