Re: Need an architecture advice.
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
Subject
Views
Written By
Posted
5748
December 04, 2006 08:11PM
Re: Need an architecture advice.
3956
December 08, 2006 11:38AM
3849
December 20, 2006 05:26PM
3692
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.