MySQL ANALYZE TABLE

1 개요

MySQL CHECK TABLE

mysql> ANALYZE TABLE employee;
+---------------+---------+----------+-----------------------------+
| Table         | Op      | Msg_type | Msg_text                    |
+---------------+---------+----------+-----------------------------+
| test.employee | analyze | status   | Table is already up to date |
+---------------+---------+----------+-----------------------------+
1 row in set (0.03 sec)

2 같이 보기

• MySQL CHECK TABLE
• MySQL CHECKSUM TABLE
• MySQL OPTIMIZE TABLE
• MySQL REPAIR TABLE
• MySQL 테이블 메인터넌스 문

3 참고 자료

• http://dev.mysql.com/doc/refman/5.7/en/analyze-table.html