title: SHOW ANALYZE STATUS summary: TiDB 数据库中 SHOW ANALYZE STATUS 的使用概况。

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 语法的扩展。

另请参阅