Hi hello,

I have a big problem with mysqldump, it's always exiting with this message:

>
mysqldump: Error 5: Out of memory (Needed 22042208 bytes) when dumping
table `theTable` at row: 2990911
>

I'm dumping using the following command:

>
/usr/pkg/bin/mysqldump -h localhost -B theDatabase --skip-opt
--max_allowed_packet=1024M -q
>

This is a replicated environment and the master is running FreeBSD and
the slave NetBSD and on the master which only has InnoDB tables there is
no problems at all to run a dump, but the machine is to loaded so we can't
afford to run the dump there.

The tables on the slave is mostly Myisam, maybe there is some kind of
memory buffer that I'm missing to tune on NetBSD but I can't figure out
what it can be. I've already increased the ulimit values for the session
running the dump and searched the archives and tried what people suggested
but nothing seems to work.

We're running NetBSD 4.0_BETA2 on amd64 with MySQL 5

Any tips on how to get the dump running? the dump should be about
15-20GB in size the fully dumped, but I never seems to get there.

Best regards,

--
Viktor Holmlund, NetBSD.se