MySQL Forums
Forum List  »  Memory Storage Engine

Re: Debugging Memory Engine Problem
Posted by: Rick James
Date: May 29, 2013 10:42PM

Several thoughts, none of them certain...

You have 240GB or RAM, correct?

Do this before the CREATE TABLE, just to verify that the settings took hold:
SHOW VARIABLES LIKE '%table_size';

Consider doing the CREATE this way:
CREATE TABLE points_mem (val int, x int, y int,
INDEX(x,y) USING BTREE
) ENGINE = MEMORY MAX_ROWS=5000000000;

What are the values here?
SHOW VARIABLES LIKE '%buffer%';

By having tmp_table_size = 150GB, it may be allocating that much to do the CREATE INDEX. Decreasing that may actually help.

Options: ReplyQuote


Subject
Views
Written By
Posted
6202
May 28, 2013 12:44PM
Re: Debugging Memory Engine Problem
2450
May 29, 2013 10:42PM


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.