Re: mysqld wasting 2GB

[Paul DuBois]

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