Subject: Re: mysqldump fails under NetBSD
To: Matthias Scheler <tron@zhadum.org.uk>
From: Fredrik Carlsson <fredrik@netbsd.se>
List: netbsd-users
Date: 05/06/2007 00:11:03
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

// Fredrik