Max allowed packet size of mysql

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 is: 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 the mysql client, the default value of the max_allowed_packet variable is 16 MB. To set a large value, start mysql www.2cto.com mysql> mysql -- max-allowed-packet = 32 M in my. ini can also be changed. You need to restart mysql in my. ini joins [mysql] max_allowed_packet = 16 M to query the variables show variables in mysql; show variables like 'max _ allowed % '; (mohu query) by DouglasLau