>>>>> "g" == glen <glen@stripped> writes:
g> Fraser MacKenzie wrote:
>> Use --big-tables whhen you startup mysqld
>>
>> Fraser
>>
>> On Wed, 5 May 1999, glen wrote:
>>
>> > i have database table which filesize is 550mb and around 5000000 records
>> >
>> > and free system memory about 400mb, including swap space.
>> > when trying to mysqldump that table then mysqldump fails with error
I've said it before and I'll say it again: just because your system
has these resources does not mean your process can use all of them.
Unix is a multi-user system, and must share the resources. Be sure
your process is allowed to use the resources you're expected it to get.
>> >
>> > mysqldump: Out of memory (Needed 8164 bytes)
>> > mysqldump: Got error: 2008: MySQL client run out of memory
g> no the problem is that CLIENT runs out of memory, that is mysqldump in this
g> case
g> i don't get it why mysqldump needs so much memory, there's no sorting or
g> whatsover
You may wish to investigate the "--quick" option to mysqldump.
v.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@stripped Rockville, MD +1-301-545-6996
PGP & MIME spoken here http://www.kciLink.com/home/khera/
