Hi, --- In MySQL Version 3.23, in-memory temporary tables will automatically be converted to a disk-based MyISAM table after the table size gets bigger than tmp_table_size. ---
It also says this though. I'm using mysql 4. Is the above not true for mysql 4? Ric ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 2:26 PM Subject: Re: unkown table is full > Richard, > Thursday, April 04, 2002, 2:42:52 AM, you wrote: > > RC> create table test select * from summary_rts union select * from > RC> summary_rts_old; > RC> ERROR 1114: The table '#sqld70c_b4_0' is full > > RC> Can someone please help me figure out what is wrong with this. It was > RC> working fine up until a few hours ago. The only reason I really choose to > RC> use Mysql 4.0 was for the union operator and now that isn't working for me > RC> on these tables. Nothing has changed other than the tables have more data in > RC> them. The two tables have a total of about 230K rows. Not very much in my > RC> opinion. > > MySQL uses temporary tables for temporary data. If the result of query > is higher than limit on the size of these tables you get such error. > Look at: > http://www.mysql.com/doc/M/e/Memory_use.html > http://www.mysql.com/doc/F/u/Full_table.html > http://www.mysql.com/doc/S/E/SET_OPTION.html > > RC> Any suggestions would be greatly appreciated. > RC> Ric. > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [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 > --------------------------------------------------------------------- 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