Re: mysqld wasting 2GB

[Sasha Pachev]

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)