MySQL Forums
Forum List  »  Memory Storage Engine

Re: Need an architecture advice.
Posted by: Ingo Strüwing
Date: December 08, 2006 11:38AM

Hi,

50 million rows times 500 bytes are about 25 Gigabytes if I compute correctly. I never saw a MEMORY table of this size. If you want to have indexes on it, add them to this size.

I am not sure if MySQL supports this size at all. Surely not on every platform. I cannot say anything about performance.

For a single 24 GB table without indexes you should have 32 GB of RAM. With indexes even more. Not a common machine.

How do you plan to load the data after every restart of the MySQL server?

Regards
Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5658
December 04, 2006 08:11PM
Re: Need an architecture advice.
3906
December 08, 2006 11:38AM
3813
December 20, 2006 05:26PM
3656
December 21, 2006 12:53PM


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.