Subject: Re: mysqldump fails under NetBSD
To: Fredrik Carlsson <email@example.com>
From: matthew sporleder <firstname.lastname@example.org>
Date: 05/05/2007 19:17:40
On 5/5/07, Fredrik Carlsson <email@example.com> wrote:
> Matthias Scheler wrote:
> > On Sat, May 05, 2007 at 07:35:31PM +0000, Fredrik Carlsson wrote:
> >> The ulimit values are high already and "ulimit -d `ulimit -d -H`" did
> >> unfortunately not make any difference.
> > Looking at it again the program tries to allocate 2.2GB of memory.
> > I guess this is a program bug in MySQL. If it isn't than you'll need
> > a NetBSD-amd64 system with about 4GB of memory to do the dump.
> > Kind regards
> The system is a NetBSD-amd64 with 4GB of memory, if I look at 'top' when
> the dump is running it never shows memory usage beyond 15-20MB for the
> dump process.
> PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
> 17436 root 57 0 18M 21M CPU/1 0:27 46.89% 45.41% mysqldump
> 162 mysql 18 0 1950M 1672M sigwai/0 305:53 22.12% 22.12% <mysqld>
> NetBSD 4.0_BETA2 amd64 x86_64
I would be interested in a ktruss of this mysqldump to see what it's
doing. Have you tried dumping to stdout and just redirecting?