MySQL Forums
Forum List  »  Memory Storage Engine

Re: IMDB data processing
Posted by: Rick James
Date: August 24, 2012 08:44AM

You are using ENGINE=MEMORY?

Can you shrink the datatypes? VARCHAR(50), especially if it is utf8, is a rather long GUID; it will take 152 bytes of memory in the MEMORY engine.

Please provide SHOW CREATE TABLE for each table. I need to know whether you are using HASH or BTree indexes, and what field(s) are indexed.

Please provide the actual SELECT statement; handwaving is not sufficient.
Better yet, do EXPLAIN SELECT...

You may even find that InnoDB, with suitable indexes, will run faster than MEMORY!

Options: ReplyQuote


Subject
Views
Written By
Posted
6554
August 21, 2012 07:36AM
Re: IMDB data processing
2214
August 24, 2012 08:44AM


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.