This error occurs when an in-memory temporary table gets bigger than
tmp_table_size. To avoid this problem one can increase the
-O tmp_table_size=# option to mysqld or use the SQL option
SQL_BIG_TABLES before you do the problem query. See section SET OPTION syntax..
One can also start mysqld with the option: --big-tables.
This is exactly the same as using SQL_BIG_TABLES for all queries.
Go to the first, previous, next, last section, table of contents.