That's what I thought at first as well. But my tmp_table_size is set to 64MB
and I used the --big-tables option just to be sure.
Also, show table status says the size is well below 64MB:
Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length
tmp | HEAP | Dynamic | 160805 | 187 | 30245676 |
29737301
if data_length means the same for heap tables as it does for myisam tables.
Another thing is the Max_data_length is much smaller than max_heap_table_size
which is also set at 64M. Shouldn't Max_data_length reflect the same value as
max_heap_table_size? Still stumped.
If this helps: this only started happening after I upgraded from 3.22.x to
3.23
Any other suggestions?
On Wed, Sep 05, at 01:54pm, Adams, Bill TQO ([EMAIL PROTECTED]) wrote:
> [EMAIL PROTECTED] wrote:
>
> > Hello,
> >
> > I keep getting this:
> >
> > insert into tmp select * from ascend_log_2001_08_25;
> > ERROR 1114: The table 'tmp' is full
> >
> > tmp is a heap table
>
> There is a size limit to temp tables. See:
> http://www.mysql.com/doc/F/u/Full_table.html about increasing the allowed size
> for temp tables.
>
> You can write the temp tables to disk with the SQL 'SET SQL_BIG_TABLES = 1;'
> http://www.mysql.com/doc/S/E/SET_OPTION.html
>
> --Bill
>
>
---------------------------------------------------------------------
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