List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 17 1999 2:48am
Subject:Re: mysqld wasting 2GB
View as plain text  
At 12:39 AM +0200 7/17/99, 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 ??

As he said, this can happen with any database.  It could be a MySQL
problem, of course, but from the information provided, doesn't the problem
seem to be that you don't have enough disk space?

--
Paul DuBois, paul@stripped
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