sorri it's tmp_table_size. mysql> show variables like '%table%'; +------------------------+----------+ | Variable_name | Value | +------------------------+----------+ | innodb_file_per_table | OFF | | innodb_table_locks | ON | | lower_case_table_names | 1 | | max_heap_table_size | 16777216 | | max_tmp_tables | 32 | | table_cache | 256 | | table_type | InnoDB | | tmp_table_size | 9437184 | +------------------------+----------+ 8 rows in set (0.00 sec)
What are : show create table toto; the count(*) ? the query ? Mathias Selon Emmett Bishop <[EMAIL PROTECTED]>: > Mathias, > > Thanks for the reply. I couldn't find a server > variable named "max_temp_table_size" but I did find > one named "max_heap_table_size". Is that what you > meant? BTW, I forgot to mention that I'm using MySQL > 4.0.20. Could it be that this variable that you > mention is only in later versions? > > Basically, what I'm trying to do is a multi-table > update statement. If I select too many rows I get the > "Table #sql-123 is full" error. If I bite off a small > enough chunk, the query works. > > Thanks again, > > Tripp > > --- [EMAIL PROTECTED] wrote: > > > hi, > > seems to be a temp table (sybase notation). > > see max_temp_table_size > > > > Mathias > > Selon Emmett Bishop <[EMAIL PROTECTED]>: > > > > > Howdy all, I have a question about a SQL statement > > > that I'm trying to execute. When I execute the > > > statement I get the following error: The table > > > '#sql_bd6_3' is full. > > > > > > What does this mean exactly? > > > > > > Thanks, > > > > > > Tripp > > > > > > > > > > > > __________________________________ > > > Yahoo! Mail Mobile > > > Take Yahoo! Mail with you! Check email on your > > mobile phone. > > > http://mobile.yahoo.com/learn/mail > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
