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
