MySQL max_allowed_packet Query and modification

It is often necessary to import or export large SQL files in your work. It is generally OK to export, but in the import to other MySQL libraries, "Packet forquery is too large (1706 > 1024) may appear. You can change this value on the server by setting the Max_allowed_packet ' variable. "or the program (such as Python inside Executemany) appears"MySQL server has gone away"when inserting large amounts of data. These errors are probably MySQL MySQL max_allowed_packet default values are too small. Modify this value to generally swim in two different ways.

Method one: SQL statement modification

1. First log in to MySQL to see the current size of the value.

Show variables like '%max_allowed_packate% '

2, modify its size to 1G

Set Global Max_allowed_packet = 1024*1024*1024

This modification will require you to re-login to MySQL to see the modified values. And, this way modifies the MySQL max_allowed_packet, which may fail after MySQL restarts.

Mode two: My.ini modification

1. Add the following statement in the My.ini file. For example: Change to 1G. as shown. After the modification is complete, you will need to restart MySQL.

　　

Note: In mode 2 max_allowed_packed must be added in "mysqld" to take effect.

MySQL Max_allowed_packet queries and modifications