MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables
Posted by: Jan Theodore Galkowski
Date: June 27, 2007 08:52AM

is there some guidance online at mysql.com which gives rules for how long it takes to rebuild indexes for MyISAM or Innodb tables in the case of Really Big Tables? surely, it depends upon the type of index. is there anything like a partial index refresh available? even third party?

and i've seen these adaptive hash indexes for Innodb? anything quantitative on how they help? performance penalties on regular transactions?

thanks much.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables
5323
Jan Theodore Galkowski
June 27, 2007 08:52AM
Re: time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables
3171
Adrian Chapela Cordeiro
August 30, 2007 02:13AM


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.