MySQL Forums :: InnoDB :: Reduce Index space

Advanced Search

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

Subject Views Written By Posted
Reduce Index space 3178 jun kazawa 01/19/2009 11:04PM
Re: Reduce Index space 1683 Rick James 01/19/2009 11:56PM
Re: Reduce Index space 1705 jun kazawa 01/20/2009 12:58AM
Re: Reduce Index space 1592 Rick James 01/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.