跳到主要内容
版本: 最新版本-3.5

ADMIN SHOW REPLICA STATUS

ADMIN SHOW REPLICA STATUS 用于显示表或分区的副本状态。

提示

该操作需要 SYSTEM 级别的 OPERATE 权限。您可以参考 GRANT 授予权限。

语法​

ADMIN SHOW REPLICA STATUS FROM [db_name.]tbl_name [PARTITION (p1, ...)]
[where_clause]
where_clause:
WHERE STATUS [!]= "replica_status"
replica_status:
OK:            The replica is healthy
DEAD:          The Backend of replica is not available
VERSION_ERROR: The replica data version is missing
SCHEMA_ERROR:  The schema hash of replica is incorrect
MISSING:       The replica does not exist

示例​

  1. 查看表的所有副本的状态。

    ADMIN SHOW REPLICA STATUS FROM db1.tbl1;

  2. 查看状态为 VERSION_ERROR 的分区的副本。

    ADMIN SHOW REPLICA STATUS FROM tbl1 PARTITION (p1, p2)
    WHERE STATUS = "VERSION_ERROR";

  3. 查看表的所有不健康的副本。

    ADMIN SHOW REPLICA STATUS FROM tbl1
    WHERE STATUS != "OK";