MySQL Forums
Forum List  »  Memory Storage Engine

Re: MEMORY table size or index size limits
Posted by: Ingo Strüwing
Date: January 03, 2007 10:59AM

Hi.

Yes to both questions. If your total MySQL server memory consumption is above 2 to 4GB (operating system dependend), you need a 64-bit system.

However, you can have multiple MySQL servers on a (powerful) machine. Each can use that much memory. If your application allows to split the tables on multiple servers, or a replication setup is appropriate, you could make use of plenty of memory.

Anyway. Wheneever you plan for a new big database machine, go with 64 bit.

Regards
Ingo

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MEMORY table size or index size limits
9031
January 03, 2007 10:59AM


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.