Max-allowed-packet

When max_allowed_packetMysql5.1 encounters an excessively large information package and imports data from the client, the error code: 1153Gotapacketbiggerthanmax_allowed_packetbytes terminates data import. When the MySQL client or mysqld server receives an information packet greater than the value of max_allowed_packet,

Max_allowed_packet Mysql 5.1 encounters an excessively large information package problem when importing data using the client, the error code: 1153 Got a packet bigger than max_allowed_packet bytes terminates data import. When the MySQL client or mysqld server receives an information packet greater than the value of max_allowed_packet,

Max_allowed_packet

When importing data using the client due to an excessively large information package in Mysql 5.1, the error code 1153-Got a packet bigger than 'max _ allowed_packet 'bytes terminates data import.

When the MySQL client or mysqld server receives an information packet greater than the value of max_allowed_packet, the "information packet is too large" error is sent and the connection is closed. For some clients, if the communication information package is too large, a "lost connection to MySQL Server" error may occur during query.

Both the client and server have their own max_allowed_packet variable. Therefore, if you want to process a large information package, you must add the variable on the client and server. Generally, the default value of max-allowed-packet on the server is 1 MB.

If you are using a mysql client, the default value of the max_allowed_packet variable is 16 MB. To set a large value, you can start mysql using the following methods:

Mysql> mysql-max-allowed-packet = 32 M

You can change it in my. ini, and you need to restart mysql.

Add [mysqld] max_allowed_packet = 300 M to my. ini

This article from: http://blog.webwlan.cn/wordpress, original address: http://blog.webwlan.cn/wordpress? P = 8549, thanks to the original author.