Greg, Thursday, June 06, 2002, 6:42:09 PM, you wrote: GT> help please. I am seeing very disturbing, very large, and very sporadic GT> temporary files appear in the MySQL $tmpdir location. Here's a brief listing: GT> > -rw-rw---- 1 mysql mysql 6488514560 Jun 6 14:14 #sql4f3_1f8aa_2.MYD GT> > -rw-rw---- 1 mysql mysql 1024 Jun 6 11:12 #sql4f3_1f8aa_2.MYI
GT> Note that first file is 6.5 GB!!! MySQL is not crashing but in writing this GT> huge file, it is filling the entire remaining contents of the hard drive. GT> I used to have tmpdir unset (default is /tmp) but that filled the root GT> partition of my drive. I switched the tmpdir to a second disk that had more GT> space but it ended up filling every available byte. The entire contents of GT> my DB is only 1.4 GB so how in the world is a 6 GB temporary table being GT> created? MySQL creates temporary tables for some kind of queries. As to size of the file, it's not so strange. Most likely you query is producing a cartesian product of something, i.e. if you have 1000 rows in one table and 1000 in another the result of full Cartesian product of these tables will be a billion of rows ... GT> The problem has been recurring about once per week for months and I have no GT> idea at this point how to debug. Any direction would be greatly appreciated. GT> System info: Red Hat 7.1; Mysql v3.23.36 -- 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