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
Subject
Views
Written By
Posted
Reduce Index space
3843
January 19, 2009 11:04PM
1855
January 19, 2009 11:56PM
1866
January 20, 2009 12:58AM
1744
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.