PLACEMENT_RULES

PLACEMENT_RULESの表は、明示的に構成されたすべてのSQLの配置ルールに関する情報を提供します。この情報には、配置ポリシーと直接添付されたルールの両方が含まれます。

USE information_schema; DESC placement_rules;
+----------------------+--------------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------+------+------+---------+-------+ | POLICY_ID | bigint(64) | NO | | NULL | | | CATALOG_NAME | varchar(512) | NO | | NULL | | | POLICY_NAME | varchar(5) | YES | | NULL | | | SCHEMA_NAME | varchar(5) | YES | | NULL | | | TABLE_NAME | varchar(5) | YES | | NULL | | | PARTITION_NAME | varchar(5) | YES | | NULL | | | PRIMARY_REGION | varchar(5) | NO | | NULL | | | REGIONS | varchar(5) | NO | | NULL | | | CONSTRAINTS | varchar(5) | NO | | NULL | | | LEADER_CONSTRAINTS | varchar(5) | NO | | NULL | | | FOLLOWER_CONSTRAINTS | varchar(5) | NO | | NULL | | | LEARNER_CONSTRAINTS | varchar(5) | NO | | NULL | | | SCHEDULE | varchar(20) | NO | | NULL | | | FOLLOWERS | bigint(64) | NO | | NULL | | | LEARNERS | bigint(64) | NO | | NULL | | +----------------------+--------------+------+------+---------+-------+ 15 rows in set (0.00 sec)

PLACEMENT_RULESの表は、明示的に構成されたルールのみを示しています。配置ルールの正規バージョン(テーブルに添付された配置ポリシーを含む)を表示するには、代わりにステートメントSHOW PLACEMENTを使用します。

CREATE TABLE t1 (a INT); CREATE TABLE t2 (a INT) primary_region="us-east-1" regions="us-east-1"; CREATE PLACEMENT POLICY p1 primary_region="us-east-1" regions="us-east-1"; CREATE TABLE t3 (a INT) PLACEMENT POLICY=p1; SHOW PLACEMENT; -- Includes t3. SELECT * FROM information_schema.placement_rules; -- Does not include t3.
Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.11 sec) Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.11 sec) +---------------+------------------------------------------------+ | Target | Placement | +---------------+------------------------------------------------+ | POLICY p1 | PRIMARY_REGION="us-east-1" REGIONS="us-east-1" | | TABLE test.t2 | PRIMARY_REGION="us-east-1" REGIONS="us-east-1" | | TABLE test.t3 | PRIMARY_REGION="us-east-1" REGIONS="us-east-1" | +---------------+------------------------------------------------+ 3 rows in set (0.00 sec) +-----------+--------------+-------------+-------------+------------+----------------+----------------+-----------+-------------+--------------------+----------------------+---------------------+----------+-----------+----------+ | POLICY_ID | CATALOG_NAME | POLICY_NAME | SCHEMA_NAME | TABLE_NAME | PARTITION_NAME | PRIMARY_REGION | REGIONS | CONSTRAINTS | LEADER_CONSTRAINTS | FOLLOWER_CONSTRAINTS | LEARNER_CONSTRAINTS | SCHEDULE | FOLLOWERS | LEARNERS | +-----------+--------------+-------------+-------------+------------+----------------+----------------+-----------+-------------+--------------------+----------------------+---------------------+----------+-----------+----------+ | 3 | def | p1 | NULL | NULL | NULL | us-east-1 | us-east-1 | | | | | | 0 | 0 | | NULL | def | NULL | test | t2 | NULL | us-east-1 | us-east-1 | | | | | | 0 | 0 | +-----------+--------------+-------------+-------------+------------+----------------+----------------+-----------+-------------+--------------------+----------------------+---------------------+----------+-----------+----------+ 2 rows in set (0.00 sec)

このページは役に立ちましたか?

Playground
新規
登録なしで TiDB の機能をワンストップでインタラクティブに体験できます。
製品
TiDB Cloud
TiDB
価格
PoC お問い合わせ
エコシステム
TiKV
TiFlash
OSS Insight
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.