web development helpdesk

When processing a large file (for example using ‘LOAD DATA LOCAL INFILE’) the connection to mysql can get lost. Reason for this is the mysql server has a limit on the size of a ‘packet’ it receives and when this limit is exceeded it drops the connection.

This limit can be changed using the system variable max_allowed_packet. This specifies the maximum size of a packet in bytes.

A packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a master replication server to a slave.

written by objects \\ tags: max_allowed_packet, mysql