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)
