SHOW DEFAULT SINGLE TABLE STORAGE UNIT [FROM databaseName]
SHOW SINGLE (TABLES | table) [FROM databaseName]
COUNT SINGLE_TABLE RULE [FROM databaseName]
table:
TABLE tableName
| 列 | 说明 |
|---|---|
| storage_unit_name | 存储单元名称 |
| 列 | 说明 |
|---|---|
| table_name | 单表名称 |
| storage_unit_name | 单表所在的存储节点名称 |
| 列 | 说明 |
|---|---|
| rule_name | 规则名称 |
| database | 单表所在的数据库名称 |
| count | 规则个数 |
SHOW DEFAULT SINGLE TABLE STORAGE UNIT
sql> SHOW DEFAULT SINGLE TABLE STORAGE UNIT;
+-------------------+
| storage_unit_name |
+-------------------+
| ds_0 |
+-------------------+
1 row in set (0.01 sec)
SHOW SINGLE TABLE tableName
sql> SHOW SINGLE TABLE t_single_0;
+----------------+-------------------+
| table_name | storage_unit_name |
+----------------+-------------------+
| t_single_0 | ds_0 |
+----------------+-------------------+
1 row in set (0.01 sec)
SHOW SINGLE TABLES
mysql> SHOW SINGLE TABLES;
+--------------+-------------------+
| table_name | storage_unit_name |
+--------------+-------------------+
| t_single_0 | ds_0 |
| t_single_1 | ds_1 |
+--------------+-------------------+
2 rows in set (0.02 sec)
COUNT SINGLE_TABLE RULE
mysql> COUNT SINGLE_TABLE RULE;
+--------------+----------+-------+
| rule_name | database | count |
+--------------+----------+-------+
| t_single_0 | ds | 2 |
+--------------+----------+-------+
1 row in set (0.02 sec)