MySQL Forums
Forum List  »  InnoDB

analyze table
Posted by: Yoshiaki Tajika
Date: August 01, 2005 08:15PM

Hello. I have questions about analyzing innodb table.
Needless to say, I mean refreshing distribution info of key values.

The article below says that "With InnoDB, table statistics are updated automatically, so you do not need to run analyze table."
http://www.mysql.com/news-and-events/newsletter/2003-04/a0000000155.html

Then, my questions are;
#1. Though the article above is a little old(published in Apr 2003), is it still saying truth?
#2. If true, please tell me how automatically it works. Is it done as one internal step of every INSERT, DELETE, UPDATE procedure? Or, Innodb's dedicated and isolated thread does it continuously?

Regards.

Options: ReplyQuote


Subject
Views
Written By
Posted
analyze table
3154
August 01, 2005 08:15PM


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.