ANALYZE TABLE analyzes and stores
the key distribution for a table. During the analysis, the table
is locked with a read lock for MyISAM,
BDB, and InnoDB. This
statement works with MyISAM,
BDB, InnoDB, and
NDB tables. For MyISAM
tables, this statement is equivalent to using myisamchk
--analyze-
MySQL uses the stored key distribution to decide the order in
which tables should be joined when you perform a join on
something other than a constant. In addition, key distributions
can be used when deciding which indexes to use for a specific
table within a query.
This statement requires SELECT
and INSERT privileges for the
table.
ANALYZE TABLE returns a result
set with the following columns.
If the table has not changed since the last
ANALYZE TABLE statement, the
table is not analyzed again.
By default, the server writes ANALYZE
TABLE statements to the binary log so that they
replicate to replication slaves. To suppress logging, specify
the optional NO_WRITE_TO_BINLOG keyword or
its alias LOCAL.
Use mysqlcheck -Aa -uroot -p to run analyze table for all databases and tables (including InnoDB) on a running server. Available in MySQL 3.23.38 and later.
© 2013, Oracle Corporation and/or its affiliates
User Comments
Use mysqlcheck -Aa -uroot -p to run analyze table for all databases and tables (including InnoDB) on a running server. Available in MySQL 3.23.38 and later.
Note that ANALYZE TABLE requires SELECT and INSERT privileges, only (LOCK TABLES is not needed).
Add your own comment.