analyze table
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.
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.