After using MySQL memory engine table as middle cache table, we got this error when application inserting the data to the table. Seems there is some limits on the table. After searching on Google, we know that we need to change some default settings.
The global system variable "max_heap_table_size" define the maximum size memeory table can reach. The default values is 16384 (Maybe it's OS dependant). So you can change it with the following steps.
Run the following command to change it at system level.
set global max_heap_table_size=1048576000
Then modify the MySQL configuration file, adding a new line at the end. So when next time database get restarted, the change can be permanent.
max_heap_table_size=1048576000
Finally, you need to reconnect to MySQL, and rebuild all the tables.
ALTER TABLE ... ENGINE MEMORY;
The last step is to let application reconnect to MySQL database, to take the change effective.