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 <webcom.dk@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
