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?

Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Reduce Index space
3209
January 19, 2009 11:04PM
1690
January 19, 2009 11:56PM
1711
January 20, 2009 12:58AM
1598
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.