ANALYZE_STATUS

ANALYZE_STATUS 表提供正在执行的收集统计信息的任务以及有限条历史任务记录。

1. USE information_schema;
2. DESC analyze_status;

1. +----------------+---------------------+------+------+---------+-------+
2. | Field          | Type                | Null | Key  | Default | Extra |
3. +----------------+---------------------+------+------+---------+-------+
4. | TABLE_SCHEMA   | varchar(64)         | YES  |      | NULL    |       |
5. | TABLE_NAME     | varchar(64)         | YES  |      | NULL    |       |
6. | PARTITION_NAME | varchar(64)         | YES  |      | NULL    |       |
7. | JOB_INFO       | varchar(64)         | YES  |      | NULL    |       |
8. | PROCESSED_ROWS | bigint(20) unsigned | YES  |      | NULL    |       |
9. | START_TIME     | datetime            | YES  |      | NULL    |       |
10. | STATE          | varchar(64)         | YES  |      | NULL    |       |
11. +----------------+---------------------+------+------+---------+-------+
12. 7 rows in set (0.00 sec)

1. SELECT * FROM `ANALYZE_STATUS`;

1. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
2. | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | JOB_INFO          | PROCESSED_ROWS | START_TIME          | STATE    |
3. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
4. | test         | t          |                | analyze index idx | 2              | 2019-06-21 19:51:14 | finished |
5. | test         | t          |                | analyze columns   | 2              | 2019-06-21 19:51:14 | finished |
6. | test         | t1         | p0             | analyze columns   | 0              | 2019-06-21 19:51:15 | finished |
7. | test         | t1         | p3             | analyze columns   | 0              | 2019-06-21 19:51:15 | finished |
8. | test         | t1         | p1             | analyze columns   | 0              | 2019-06-21 19:51:15 | finished |
9. | test         | t1         | p2             | analyze columns   | 1              | 2019-06-21 19:51:15 | finished |
10. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
11. 6 rows in set

ANALYZE_STATUS 表中列的含义如下：

• TABLE_SCHEMA：表所属的数据库的名称。
• TABLE_NAME：表的名称。
• PARTITION_NAME：分区表的名称。
• JOB_INFO：ANALYZE 任务的信息。
• PROCESSED_ROWS：已经处理的行数。
• START_TIME：ANALYZE 任务的开始时间。
• STATE：ANALYZE 任务的执行状态。其值可以是 pending、running、finished 或者 failed。