oh i see, didn't knew mysql uses the tmpdir conf when there's a big
select/join or whatever, but that's logic now that i think about it.
----- Original Message -----
From: "Dmitri" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Monday, January 29, 2007 3:02 PM
Subject: Re: [Dbmail] 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" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
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
[email protected]
https://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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
