List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 16 1999 10:36pm
Subject:Re: mysqld wasting 2GB
View as plain text  
Norbert Kolb wrote:
> 
> Hi list,
> 
> i rigth now, my mysqld was wasting 2 (!) GB of hard disk by doing a simple
> query. Luckily there was no space left on device, because mysqld wanted to
> continue.
> 
> Did i push mysql beyond its limits ?
> Is this a normal behaviour when using bigger db's ( >500MB ) ?
> Where is the data ( what ever mysqld wants to store) saved ?
> 
> Norbert
> 
> +--------------------------------+
> | sent directly from www.htl.de  |
> |                                |
> | by Kolb Norbert (nkolb@stripped) |
> +--------------------------------+
>

What query were you running?

It is quite possible to write query that will require temporary space 3
times the size of the table - I believe this is inevitable with any
database.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
mysqld wasting 2GBNorbert Kolb17 Jul
  • Re: mysqld wasting 2GBSasha Pachev17 Jul
    • Re: mysqld wasting 2GBNorbert Kolb17 Jul
      • Re: mysqld wasting 2GBSasha Pachev17 Jul
        • Re: mysqld wasting 2GBNorbert Kolb17 Jul
          • Re: mysqld wasting 2GBTõnu Samuel17 Jul
            • Re: mysqld wasting 2GBNorbert Kolb17 Jul
              • Re: mysqld wasting 2GBTõnu Samuel17 Jul
                • Re: mysqld wasting 2GBAlistair MacDonald17 Jul
              • Re: mysqld wasting 2GBsinisa17 Jul
          • Re: mysqld wasting 2GBMichael Widenius29 Jul
      • Re: mysqld wasting 2GBPaul DuBois17 Jul
        • Re: mysqld wasting 2GBNorbert Kolb17 Jul