SHOW ANALYZE STATUS

SHOW ANALYZE STATUS 语句提供 TiDB 正在执行的统计信息收集任务以及有限条历史任务记录。

语法图

ShowStmt:

ShowStmt

ShowTargetFilterable:

ShowTargetFilterable

示例

1. create table t(x int, index idx(x)) partition by hash(x) partition 4;
2. analyze table t;
3. show analyze status;

1. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
2. | Table_schema | Table_name | Partition_name | Job_info          | Processed_rows | Start_time          | State    |
3. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
4. | test         | t          | p1             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
5. | test         | t          | p0             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
6. | test         | t          | p0             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
7. | test         | t          | p1             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
8. | test         | t          | p2             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
9. | test         | t          | p3             | analyze index idx |              0 | 2020-05-25 17:23:55 | finished |
10. | test         | t          | p3             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
11. | test         | t          | p2             | analyze columns   |              0 | 2020-05-25 17:23:55 | finished |
12. +--------------+------------+----------------+-------------------+----------------+---------------------+----------+
13. 8 rows in set (0.00 sec)

MySQL 兼容性

该语句是 TiDB 对 MySQL 语法的扩展。

另请参阅