MySQL Forums
Forum List  »  Memory Storage Engine

Table is full error problem
Posted by: Adnan Raza
Date: September 10, 2012 04:37AM


I have created and inserted records in a temporary table which has its engine=MEMORY, now the problem is that whenever records go up to 37000, it gives out an error, table is full.

the temp table has only three fields and not much data and the max_heap_table_size = 16777216 which is 16 MB.

I really can't understand why is 16 MB becoming insufficient...

Options: ReplyQuote

Written By
Table is full error problem
September 10, 2012 04:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.