MySQL Forums
Forum List  »  Newbie

Tracking Index Size
Posted by: Ifechukwukwu Okobi
Date: January 16, 2013 12:09AM

Hi All,

We seem to be adding a lot indexes these days in the name of query optimization and tuning.

We have both MyISAM and INNODB databases.

I need to understand what MySQL config parameter(s) controls the size of the index.

I also need to understand or estimate the size of our index to ensure that the configuration is well tuned to avoid swapping our index.

I also need to monitor it going forward so that if the index size grows close to what is in the configuration we can adjust the configuration.

Thanks for your advise in advance.

Options: ReplyQuote

Written By
Tracking Index Size
January 16, 2013 12:09AM
January 17, 2013 07:54PM
January 20, 2013 12:31PM

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.