samia,
Thursday, August 15, 2002, 3:45:27 PM, you wrote:
s> It's my first time for using MySQL.
s> I would know, why does it generate such giant temporary files. And what should i do
to save my disk from getting
s> filled by these files.
MySQL uses temporary tables in some queries. So, if you involved into
such a query some large tables, temporary files might be big.
MySQL store temporary files in the dir that are defined by TMPDIR
variable. You can just limit size of this dir, but it's not a good
idea.
You can also find some info here:
http://www.mysql.com/doc/en/Temporary_files.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
