Re: Re: unkown table is full
Richard, Friday, April 05, 2002, 12:29:44 AM, you wrote: RC Hi, RC --- RC In MySQL Version 3.23, in-memory temporary tables will automatically be RC converted to a disk-based MyISAM table after the table size gets bigger than RC tmp_table_size. RC --- RC It also says this though. I'm using mysql 4. Is the above not true for mysql RC 4? Please check available disk space where the TMPDIR resides - is there enough there? 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
Re: Re: unkown table is full
There is plenty of space. In excess of 5 gigs. Ric - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 12, 2002 2:02 PM Subject: Re: Re: unkown table is full Richard, Friday, April 05, 2002, 12:29:44 AM, you wrote: RC Hi, RC --- RC In MySQL Version 3.23, in-memory temporary tables will automatically be RC converted to a disk-based MyISAM table after the table size gets bigger than RC tmp_table_size. RC --- RC It also says this though. I'm using mysql 4. Is the above not true for mysql RC 4? Please check available disk space where the TMPDIR resides - is there enough there? 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
Re: Re: unkown table is full
Richard Clarke writes: There is plenty of space. In excess of 5 gigs. Ric Hi! The error message that you get is quite unlikely for temporary tables. Which release of MySQL 3.23 have you used ?? If not recent, then try the latest and see if problem reccurs. If this happens with last version, please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
Re: Re: unkown table is full
This is mysql 4.0.1-alpha. Ric - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, April 12, 2002 5:08 PM Subject: Re: Re: unkown table is full Richard Clarke writes: There is plenty of space. In excess of 5 gigs. Ric Hi! The error message that you get is quite unlikely for temporary tables. Which release of MySQL 3.23 have you used ?? If not recent, then try the latest and see if problem reccurs. If this happens with last version, please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
Re: Re: unkown table is full
Richard Clarke writes: This is mysql 4.0.1-alpha. Ric Please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
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