List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:May 5 1999 7:58pm
Subject:Re: mysqldump problem
View as plain text  
glen wrote:
> 
> 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
> > >
> > > mysqldump: Out of memory (Needed 8164 bytes)
> > > mysqldump: Got error: 2008: MySQL client run out of memory
> 
> no the problem is that CLIENT runs out of memory, that is mysqldump in this
> case
> i don't get it why mysqldump needs so much memory, there's no sorting or
> whatsover
> 
> --
> glen

Hi Glen

Your problem is, that mysqldump normally caches the results it produces.
You have to use the --quick option, to prevent this.

Tschau
Christian

Thread
mysqldump problemglen5 May
  • Re: mysqldump problemFraser MacKenzie5 May
    • Re: mysqldump problemglen5 May
      • Re: mysqldump problemVivek Khera5 May
        • Re: mysqldump problemPaul DuBois5 May
    • Problem with mysqlimport under dec-osfFabrice Marchal5 May
      • Problem with mysqlimport under dec-osfJani Tolonen11 May
    • Re: mysqldump problemChristian Mack5 May