MySQL Forums
Forum List  »  General

Re: how index grows in size
Posted by: Adam Donnison
Date: September 06, 2011 11:32PM

If the index were just a straight list of the indexed data, then yes your calculation of data size * row count would be correct. However that would be pretty useless as an index. Instead the index needs at least the data that is indexed, and a pointer back to the row that the data relates to. There are also structures required to manage the index. Indexes are usually created in chunks which hold a number of index nodes and are arranged in a structure that allows for quick searching. What that structure is depends on the type of index (which could be HASH or BTREE).

You may want to do a google search for Calculate MySQL Index Size for details on how to calculate for your particular setup.

Webmaster - http://www.SkySQL.com/

Options: ReplyQuote


Subject
Written By
Posted
September 06, 2011 05:16PM
Re: how index grows in size
September 06, 2011 11:32PM
September 12, 2011 10:57AM


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.