MySQL Forums
Forum List  »  NDB clusters

estimating size of Primary Keys using hash
Posted by: richard horan
Date: May 23, 2006 04:45AM

I need to do some sizing models, the documenation states:

The memory space defined by DataMemory is also used to store ordered indexes, which use about 10 bytes per record. Each table row is represented in the ordered index. A common error among users is to assume that all indexes are stored in the memory allocated by IndexMemory, but this is not the case: Only primary key and unique hash indexes use this memory; ordered indexes use the memory allocated by DataMemory. However, creating a primary key or unique hash index also creates an ordered index on the same keys, unless you specify USING HASH in the index creation statement. This can be verified by running ndb_desc -d db_name table_name in the management client.

----------------
what is the overhead per record USING HASH? is it like ordered indexes 10 bytes? or some other value?

Options: ReplyQuote


Subject
Views
Written By
Posted
estimating size of Primary Keys using hash
1816
May 23, 2006 04:45AM


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.