In article <1702.83.255.186.101.1178288461.squirrel@webmail.netbsd.se>,
Viktor Holmlund <viktor@netbsd.se> wrote:
>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,

Have you tried to up the memory resource limit?

christos