Re: what if /tmp is full?

Jorge Bastos wrote:

> I think DBmail doesn't use temporary tables in it's
work, maybe 
> Paul/Aaron can clarify us if it does or not, i'd like
to know also :P
>
> Jorge
>
>
> ----- Original Message ----- From: "Dmitri"
<project1sharedlog.com>
> To: "DBMail mailinglist" <dbmaildbmail.org>
> Sent: Sunday, January 28, 2007 11:52 PM
> Subject: Re: [Dbmail] what if /tmp is full?
>
>
>> Anne wrote:
>>
>>> Hi,
>>>
>>> Does dbmail somehow use /tmp? What happens if
/tmp is full?
>>> Could this mess up insertion of messages in the
database?
>>>
>>> thanks.
>>> Anne
>>>
>>>
_______________________________________________
>>> DBmail mailing list
>>> DBmaildbmail.org
>>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>>>
>>>
>>>
>> mysql uses /tmp sometimes, unless you setup a
different value in 
>> my.cnf for temp directory
>> if /tmp is full and mysql needs it, then it can
cause a problem.
>>
>>
>> _______________________________________________
>> DBmail mailing list
>> DBmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
>
sometimes mysql creates temporary tables if it determines
that result 
will be big, especially if it needs to do 'sort' operation.

For very large tables mysql uses temporary tables very often
even if you 
don't have specific create temporary table instructions in
your code.



_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail