MySQL Forums
Forum List  »  Memory Storage Engine

Re: the table is full error using Memory Engine
Posted by: Rick James
Date: September 11, 2012 08:37AM

max_table_heap_size should apply independently for each table.

But -- note that MEMORY tables are pessimistic about size. For example,
VARCHAR(100) CHARSET utf8
takes 302 bytes -- regardless of the amount of text in the column.

Would you like to share your SHOW CREATE TABLE.

If you are running separate connections, each of which creates such a table, then you may threaten to clutter memory with concurrent instances.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: the table is full error using Memory Engine
3841
September 11, 2012 08: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.