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.
Subject
Views
Written By
Posted
9264
September 10, 2012 05:13AM
Re: the table is full error using Memory Engine
4516
September 11, 2012 08:37AM
3966
September 11, 2012 09:12AM
3377
September 12, 2012 08:25PM
3313
September 11, 2012 08:39AM
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.