Re: max_allowed_packet and its impact on backup (and replication)

[Rick James]

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html defines it as
"The maximum size of the buffer for client/server communication."
So, it might not be relevant for replication. I don't know.

Recommend you file a bug with http://bugs.mysql.com and entitl

According to an old bug: ( http://bugs.mysql.com/bug.php?id=7927 )

Quote

[16 Jan 2005 22:02] Sergei Golubchik

Sorry, not changed :)
As mysqldump does not use max_allowed_packet to limit a statement length in a dump, the problem does not exist.
...
[17 Jan 2005 17:39] Sinisa Milivojevic

max_allowed_packet is used to limit maximum record size that can be read from the server.

net_buffer_length is used to limit number of rows in multi-row inserts, as generated by mysqldump.