Hello.
In my opinion (it is based on looking through the source code, but I can be wrong) - the max_allowed_packet should be at least more than any event in the master's binary log. The tool for researching binary logs is mysqlbinlog utility. See: http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html http://dev.mysql.com/doc/mysql/en/Binary_log.html Your versions of MySQL are very old, I recommend you to upgrade, lots of bugs have been fixed since these releases. Jacob Friis <[EMAIL PROTECTED]> wrote: > Is there any way I can find out how big I should set max_allowed_packet? > > I have changed it from the default 1M to 32M, but I still get that error. > Or is it a bug? We use MySQL 4.0.12 on the slave and 4.0.15-max on the mast= > er. > How big should I set max_allowed_packet? The servers are dual Pentium > with 2G ram. > > Thanks for any help. > Jacob > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
