I checked that table is having storage engine as Memory, how to solve it and why? I need run the truncate command on the table?
Asked
Active
Viewed 372 times
0
-
How many records are in the table? – Tim Biegeleisen Dec 27 '16 at 09:31
-
Possible duplicate of [The table is full (with MEMORY engine)](http://stackoverflow.com/questions/28219777/the-table-is-full-with-memory-engine) – e4c5 Dec 27 '16 at 09:52
1 Answers
1
Solved.
MEMORY tables are never converted to disk tables. To ensure that you don’t accidentally do anything foolish, you can set the max_heap_table_size system variable to impose a maximum size on MEMORY tables. For individual tables, you can also specify a MAX_ROWS table option in the CREATE TABLE statement