Hi Vitcoria, Thank you for the response. No more questions about this, all systems clear now ;-).
Thank you so much. Nils Valentin Tokyo/Japan 2003年 6月 25日 水曜日 21:18、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > WOW Victoria, > > > > thats a good explanation. That makes many things clearer now. > > Thank you very much. > > > > However, when not having the set the tmpdir variable were are the > > temporary tables stored ? (I searched the whole harddisc) I assume in > > this case that they must be stored in the memory, is that right ? > > Nope. Temporary tables are stored in memory only if table type is HEAP. All > other temporary tables are stored on disk. By default temporary dir is /tmp > or /usr/tmp. You can check it with SHOW VARIABLES LIKE 'tmpdir'; > > Name of temporary table files looks like #sql2884_b_0.frm. > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]