Subject: Re: mysqldump fails under NetBSD
To: None <firstname.lastname@example.org>
From: Christos Zoulas <email@example.com>
Date: 05/04/2007 15:35:41
In article <firstname.lastname@example.org>,
Viktor Holmlund <email@example.com> wrote:
>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
>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.
Have you tried to up the memory resource limit?