No subject

18.2.7 The table is full error

This error occurs when an in-memory temporary table becomes larger than
tmp_table_size bytes. To avoid this problem, you can use the -O
tmp_table_size=# option to mysqld to increase the temporary table size, or
use the SQL option SQL_BIG_TABLES before you issue the
problematic query. See section 7.25 SET syntax. 

You can also start mysqld with the --big-tables option. This is exactly the
same as using SQL_BIG_TABLES for all queries.


I had this problem before, so I knew it was answered just nicely by Reading
The Fine Manual. Setting SQL_BIG_TABLES makes queries use disk based
temporary tables rather than in-memory - a little slower, but no error. The
default value of tmp_table_size is 1M which is a little low on a reasonable
machine. Current versions of MySQL (3.23.xx, xx > 2) trap this error and
redo the query with a disk based temporary table, but you're probably using
3.22.xx, 3.23.xx being the development version.



Regards,


Niall