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.
Leave a Reply
You must be logged in to post a comment.