MySQL Forums
Forum List  »  Memory Storage Engine

Re: Apparently enough max_heap_table_size but "table is full"
Posted by: Rick James
Date: November 08, 2012 11:17PM

> 2x10e9
Bytes?
Rows?

> VARCHAR16
CHARACTER SET latin1?
utf8?
Use the shorter, if possible. Minimize the "16"; VARCHAR converts to CHAR for MEMORY.

Suggest you experiment with 1000 rows, then extrapolate. The formula may not be quite right.

Suggest you include a MAX_ROWS clause on the CREATE TABLE statement.

Why use MEMORY? You have enough RAM to cache the entire table and indexes in RAM for either MyISAM or InnoDB.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Apparently enough max_heap_table_size but "table is full"
3129
November 08, 2012 11:17PM


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.