List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 16 1999 11:04pm
Subject:Re: mysqld wasting 2GB
View as plain text  
Norbert Kolb wrote:
> 
> > What query were you running?
> 
> select distinc( field ) from table;
> 
> > 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.
> 
> This means, that mysql is NOT useful for bigger db's ??
> 
> Norbert
> 

No, this means you need a bigger disk for what you are doing, or write a
more efficient query. If you post the query, we could probably find out
why you ran out of disk space.

-- 
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