MySQL Forums
Forum List  »  InnoDB

Reduce Index space
Posted by: jun kazawa
Date: January 19, 2009 11:04PM

A huge table with many indexes takes a lot of resources.

What about splitting the innodb table I into Ia Ib Ic for instance.
Access to Ia and Ib would be prevented by coding and - thus - no access to the 2 tables would be performed for a while.

Only Ic would be accessed, while Ia and Ib are still "alive" server side (just no query involving Ia and Ib is performed).

Would the Mysql server load the Ia and Ib indexes anyway, taking the resources... or - since they're not used - their indexes/resources would be released after a while?


Options: ReplyQuote

Written By
Reduce Index space
January 19, 2009 11:04PM
January 19, 2009 11:56PM
January 20, 2009 12:58AM
January 20, 2009 02:12AM

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.