We've found recently that have a max packet size of 8 MB on our master and
on our slaves causes problems. For some reason, slaves will error out
during replication on packets that come from the master if they are very
close to max_packet_size.
The solution is to set the max_packet_size higher on the slaves than on
the master, but we shouldn't have to do this (I don't think). Does
replication add some sort of extra header information, etc. that would
increase the packet sizes? If so, is there a formula for calculating what
the max_packet_size should be in a master/slave/setup?
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]