更新时间：2020-09-01 11:20
本文汇总了PolarDB-X支持的查看规则和节点拓扑类的语句。
1. SHOW RULE [FROM tablename]
使用说明：
show rule：查看数据库下每一个逻辑表的拆分情况；show rule from tablename：查看数据库下指定逻辑表的拆分情况。 重要列详解：
mysql> show rule;+------+--------------+-----------+------------------+---------------------+--------------------+------------------+---------------------+--------------------+| ID | TABLE_NAME | BROADCAST | DB_PARTITION_KEY | DB_PARTITION_POLICY | DB_PARTITION_COUNT | TB_PARTITION_KEY | TB_PARTITION_POLICY | TB_PARTITION_COUNT |+------+--------------+-----------+------------------+---------------------+--------------------+------------------+---------------------+--------------------+| 0 | dept_manager | 0 | | NULL | 1 | | NULL | 1 || 1 | emp | 0 | emp_no | hash | 8 | id | hash | 2 || 2 | example | 0 | shard_key | hash | 8 | | NULL | 1 |+------+--------------+-----------+------------------+---------------------+--------------------+------------------+---------------------+--------------------+3 rows in set (0.01 sec)
2. SHOW FULL RULE [FROM tablename]
查看数据库下逻辑表的拆分规则，比 SHOW RULE 指令展示的信息更加详细。
重要列详解：
mysql> show full rule;+------+--------------+-----------+------------+-----------------------+----------------------------------------------------+-----------------------------------------------------+-----------------+------------------------------------+----------------+--------------------------------------------------+| ID | TABLE_NAME | BROADCAST | JOIN_GROUP | ALLOW_FULL_TABLE_SCAN | DB_NAME_PATTERN | DB_RULES_STR | TB_NAME_PATTERN | TB_RULES_STR | PARTITION_KEYS | DEFAULT_DB_INDEX |+------+--------------+-----------+------------+-----------------------+----------------------------------------------------+-----------------------------------------------------+-----------------+------------------------------------+----------------+--------------------------------------------------+| 0 | dept_manager | 0 | NULL | 0 | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS | NULL | dept_manager | NULL | NULL | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS || 1 | emp | 0 | NULL | 1 | SEQ_TEST_148*************SEQ_TEST_****_{0000}_RDS | ((#emp_no,1,8#).longValue().abs() % 8) | emp_{0} | ((#id,1,2#).longValue().abs() % 2) | emp_no id | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS || 2 | example | 0 | NULL | 1 | SEQ_TEST_*************RGKKSEQ_TEST_****_{0000}_RDS | ((#shard_key,1,8#).longValue().abs() % 8).intdiv(1) | example | NULL | shard_key | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS |+------+--------------+-----------+------------+-----------------------+----------------------------------------------------+-----------------------------------------------------+-----------------+------------------------------------+----------------+--------------------------------------------------+3 rows in set (0.01 sec)
3. SHOW TOPOLOGY FROM tablename
查看指定逻辑表的拓扑分布，展示该逻辑表保存在哪些分库中，每个分库下包含哪些分表。
mysql> show topology from emp;+------+--------------------------------------------------+------------+| ID | GROUP_NAME | TABLE_NAME |+------+--------------------------------------------------+------------+| 0 | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS | emp_0 || 1 | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS | emp_1 || 2 | SEQ_TEST_*************RGKKSEQ_TEST_****_0001_RDS | emp_0 || 3 | SEQ_TEST_*************RGKKSEQ_TEST_****_0001_RDS | emp_1 || 4 | SEQ_TEST_*************RGKKSEQ_TEST_****_0002_RDS | emp_0 || 5 | SEQ_TEST_*************RGKKSEQ_TEST_****_0002_RDS | emp_1 || 6 | SEQ_TEST_*************RGKKSEQ_TEST_****_0003_RDS | emp_0 || 7 | SEQ_TEST_*************RGKKSEQ_TEST_****_0003_RDS | emp_1 || 8 | SEQ_TEST_*************RGKKSEQ_TEST_****_0004_RDS | emp_0 || 9 | SEQ_TEST_*************RGKKSEQ_TEST_****_0004_RDS | emp_1 || 10 | SEQ_TEST_*************RGKKSEQ_TEST_****_0005_RDS | emp_0 || 11 | SEQ_TEST_*************RGKKSEQ_TEST_****_0005_RDS | emp_1 || 12 | SEQ_TEST_*************RGKKSEQ_TEST_****_0006_RDS | emp_0 || 13 | SEQ_TEST_*************RGKKSEQ_TEST_****_0006_RDS | emp_1 || 14 | SEQ_TEST_*************RGKKSEQ_TEST_****_0007_RDS | emp_0 || 15 | SEQ_TEST_*************RGKKSEQ_TEST_****_0007_RDS | emp_1 |+------+--------------------------------------------------+------------+16 rows in set (0.01 sec)
4. SHOW PARTITIONS FROM tablename
查看分库分表键集合，分库键和分表键之间用逗号分割。如果最终结果有两个值，说明是既分库又分表的情形，第一个是分库键，第二个是分表键。如果结果只有一个值，说明是分库不分表的情形，该值是分库键。
mysql> show partitions from emp;+-----------+| KEYS |+-----------+| emp_no,id |+-----------+1 row in set (0.00 sec)
5. SHOW BROADCASTS
查看广播表列表。
mysql> show broadcasts;+------+------------+| ID | TABLE_NAME |+------+------------+| 0 | ***2 || 1 | ***_tbl |+------+------------+2 rows in set (0.01 sec)
6. SHOW DATASOURCES
查看底层存储信息，包含数据库名、数据库分组名、连接信息、用户名、底层存储类型、读写权重、连接池信息等。
重要列详解：
mysql> show datasources;+------+----------------------------+------------------------------------------------+--------------------------------------------------+----------------------------------------------------------------------------------+-----------+-------+------+------+------+--------------+----------+--------------+---------------+----------------------------------------------+-------------+--------------+| ID | SCHEMA | NAME | GROUP | URL | USER | TYPE | INIT | MIN | MAX | IDLE_TIMEOUT | MAX_WAIT | ACTIVE_COUNT | POOLING_COUNT | ATOM | READ_WEIGHT | WRITE_WEIGHT |+------+----------------------------+------------------------------------------------+--------------------------------------------------+----------------------------------------------------------------------------------+-----------+-------+------+------+------+--------------+----------+--------------+---------------+----------------------------------------------+-------------+--------------+| 0 | seq_test_148************* | rds*****************_seq_test_****_0000_****_1 | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0000 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0000_**** | 10 | 10 || 1 | seq_test_148************* | rds*****************_seq_test_****_****_****_2| SEQ_TEST_*************RGKKSEQ_TEST_****_0001_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0001 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0001_**** | 10 | 10 || 2 | seq_test_148************* | rds*****************_seq_test_****_0002_****_3 | SEQ_TEST_*************RGKKSEQ_TEST_****_0002_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0002 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0002_**** | 10 | 10 || 3 | seq_test_148************* | rds*****************_seq_test_****_0003_****_4 | SEQ_TEST_*************RGKKSEQ_TEST_****_0003_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0003 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0003_**** | 10 | 10 || 4 | seq_test_148************* | rds*****************_seq_test_****_0004_****_5 | SEQ_TEST_*************RGKKSEQ_TEST_****_0004_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0004 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0004_**** | 10 | 10 || 5 | seq_test_148************* | rds*****************_seq_test_****_0005_****_6 | SEQ_TEST_*************RGKKSEQ_TEST_****_0005_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0005 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0005_**** | 10 | 10 || 6 | seq_test_148************* | rds*****************_seq_test_****_0006_****_7 | SEQ_TEST_*************RGKKSEQ_TEST_****_0006_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0006 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0006_**** | 10 | 10 || 7 | seq_test_148************* | rds*****************_seq_test_****_0007_****_8 | SEQ_TEST_*************RGKKSEQ_TEST_****_0007_RDS | jdbc:mysql://rds*****************.mysql.rds.aliyuncs.com:3306/seq_test_****_0007 | ********0 | mysql | 0 | 24 | 72 | 15 | 5000 | 0 | 1 | rds*****************_seq_test_****_0007_**** | 10 | 10 |+------+----------------------------+------------------------------------------------+--------------------------------------------------+----------------------------------------------------------------------------------+-----------+-------+------+------+------+--------------+----------+--------------+---------------+----------------------------------------------+-------------+--------------+8 rows in set (0.01 sec)
7. SHOW NODE
查看物理库的读写次数（历史累计数据）、读写权重（历史累计数据）。
重要列详解：
注意：
MASTER_READ_PERCENT，SLAVE_READ_PERCENT这两列代表的是历史累计数据，更改读写权重的配比后，这几个数值并不能立即反应最新的读写权重配比，需累计一段比较长的时间才行。
mysql> show node;+------+--------------------------------------------------+-------------------+------------------+---------------------+--------------------+| ID | NAME | MASTER_READ_COUNT | SLAVE_READ_COUNT | MASTER_READ_PERCENT | SLAVE_READ_PERCENT |+------+--------------------------------------------------+-------------------+------------------+---------------------+--------------------+| 0 | SEQ_TEST_*************RGKKSEQ_TEST_****_0000_RDS | 12 | 0 | 100% | 0% || 1 | SEQ_TEST_*************RGKKSEQ_TEST_****_0001_RDS | 0 | 0 | 0% | 0% || 2 | SEQ_TEST_*************RGKKSEQ_TEST_****_0002_RDS | 0 | 0 | 0% | 0% || 3 | SEQ_TEST_*************RGKKSEQ_TEST_****_0003_RDS | 0 | 0 | 0% | 0% || 4 | SEQ_TEST_*************RGKKSEQ_TEST_****_0004_RDS | 0 | 0 | 0% | 0% || 5 | SEQ_TEST_*************RGKKSEQ_TEST_****_0005_RDS | 0 | 0 | 0% | 0% || 6 | SEQ_TEST_*************RGKKSEQ_TEST_****_0006_RDS | 0 | 0 | 0% | 0% || 7 | SEQ_TEST_*************RGKKSEQ_TEST_****_0007_RDS | 0 | 0 | 0% | 0% |+------+--------------------------------------------------+-------------------+------------------+---------------------+--------------------+8 rows in set (0.01 sec)
在文档使用中是否遇到以下问题
更多建议
匿名提交