All geek questions in one place

MySQL database error: packages exceeding max_allowed_packet are not allowed - during insertion

I have never had this error before, but I'm doing a pretty big insert. How to increase this parameter? Also, how can I say how right I am, what is allowed? I tried to find the error, but I am not using Fogbugz. Any help would be awesome.

This is a windows mysql installation.

+6
source share
2 answers

How to fix this problem: change the value of the max_allowed_packet variable in the configuration of your MySQL server.

How to find out how much you allowed: not sure, but I would say that checking the size (in bytes) or your insert request should give you an idea.


See the following section of the MySQL manual for more information: C.5.2.10. Too big package .

+8
source

To set max to 16 MB, for example, without having to restart, run:

 SET GLOBAL max_allowed_packet = 16777216
+8
source

Source: https://habr.com/ru/post/894490/

More articles:


All Articles