SHOW SHARDING TABLE tableRule | RULES [FROM databaseName]
SHOW SHARDING ALGORITHMS [FROM databaseName]
SHOW UNUSED SHARDING ALGORITHMS [FROM databaseName]
SHOW SHARDING AUDITORS [FROM databaseName]
SHOW SHARDING TABLE RULES USED ALGORITHM shardingAlgorithmName [FROM databaseName]
SHOW SHARDING KEY GENERATORS [FROM databaseName]
SHOW UNUSED SHARDING KEY GENERATORS [FROM databaseName]
SHOW UNUSED SHARDING AUDITORS [FROM databaseName]
SHOW SHARDING TABLE RULES USED KEY GENERATOR keyGeneratorName [FROM databaseName]
SHOW SHARDING TABLE RULES USED AUDITOR auditorName [FROM databaseName]
SHOW DEFAULT SHARDING STRATEGY
SHOW SHARDING TABLE NODES
tableRule:
RULE tableName
SHOW SHARDING TABLE REFERENCE RULES [FROM databaseName]
SHOW BROADCAST TABLE RULES [FROM databaseName]
列 | 说明 |
---|---|
table | 逻辑表名 |
actual_data_nodes | 实际的数据节点 |
actual_data_sources | 实际的数据源(通过 RDL 创建的规则时显示) |
database_strategy_type | 数据库分片策略类型 |
database_sharding_column | 数据库分片键 |
database_sharding_algorithm_type | 数据库分片算法类型 |
database_sharding_algorithm_props | 数据库分片算法参数 |
table_strategy_type | 表分片策略类型 |
table_sharding_column | 表分片键 |
table_sharding_algorithm_type | 表分片算法类型 |
table_sharding_algorithm_props | 表分片算法参数 |
key_generate_column | 分布式主键生成列 |
key_generator_type | 分布式主键生成器类型 |
key_generator_props | 分布式主键生成器参数 |
auditor_types | 分片审计生成器参数 |
allow_hint_disable | 是否禁用分片审计hint |
列 | 说明 |
---|---|
name | 分片算法名称 |
type | 分片算法类型 |
props | 分片算法参数 |
列 | 说明 |
---|---|
name | 分片算法名称 |
type | 分片算法类型 |
props | 分片算法参数 |
列 | 说明 |
---|---|
name | 分片审计算法名称 |
type | 分片审计算法类型 |
props | 分片审计算法参数 |
列 | 说明 |
---|---|
name | 分片审计算法名称 |
type | 分片审计算法类型 |
props | 分片审计算法参数 |
列 | 说明 |
---|---|
name | 主键生成器名称 |
type | 主键生成器类型 |
props | 主键生成器参数 |
列 | 说明 |
---|---|
name | 主键生成器名称 |
type | 主键生成器类型 |
props | 主键生成器参数 |
列 | 说明 |
---|---|
name | 策略名称 |
type | 分片策略类型 |
sharding_column | 分片键 |
sharding_algorithm_name | 分片算法名称 |
sharding_algorithm_type | 分片算法类型 |
sharding_algorithm_props | 分片算法参数 |
列 | 说明 |
---|---|
name | 分片规则名称 |
nodes | 分片节点 |
列 | 说明 |
---|---|
name | 分片表关联规则名称 |
sharding_table_reference | 分片表关联关系 |
列 | 说明 |
---|---|
broadcast_table | 广播表名称 |
SHOW SHARDING TABLE RULES
mysql> SHOW SHARDING TABLE RULES;
+--------------+---------------------------------+-------------------+----------------------+------------------------+-------------------------------+----------------------------------------+-------------------+---------------------+----------------------------+---------------------------------------------------+-------------------+------------------+-------------------+
| table | actual_data_nodes | actual_data_sources | database_strategy_type | database_sharding_column | database_sharding_algorithm_type | database_sharding_algorithm_props | table_strategy_type | table_sharding_column | table_sharding_algorithm_type | table_sharding_algorithm_props | key_generate_column | key_generator_type | key_generator_props | auditor_types | allow_hint_disable |
+--------------+---------------------------------+-------------------+----------------------+------------------------+-------------------------------+----------------------------------------+-------------------+---------------------+----------------------------+---------------------------------------------------+-------------------+------------------+-------------------+
| t_order | ds_${0..1}.t_order_${0..1} | | INLINE | user_id | INLINE | algorithm-expression:ds_${user_id % 2} | INLINE | order_id | INLINE | algorithm-expression:t_order_${order_id % 2} | order_id | SNOWFLAKE | | DML_SHARDING_CONDITIONS |true |
| t_order_item | ds_${0..1}.t_order_item_${0..1} | | INLINE | user_id | INLINE | algorithm-expression:ds_${user_id % 2} | INLINE | order_id | INLINE | algorithm-expression:t_order_item_${order_id % 2} | order_item_id | SNOWFLAKE | | | |
| t2 | | ds_0,ds_1 | | | | | mod | id | mod | sharding-count:10 | | | | | |
+--------------+---------------------------------+-------------------+----------------------+------------------------+-------------------------------+----------------------------------------+-------------------+---------------------+----------------------------+---------------------------------------------------+-------------------+------------------+-------------------+
3 rows in set (0.02 sec)
SHOW SHARDING TABLE RULE tableName
mysql> SHOW SHARDING TABLE RULE t_order;
+---------+----------------------------+-------------------+----------------------+------------------------+-------------------------------+----------------------------------------+-------------------+---------------------+----------------------------+----------------------------------------------+-------------------+------------------+-------------------+
| table | actual_data_nodes | actual_data_sources | database_strategy_type | database_sharding_column | database_sharding_algorithm_type | database_sharding_algorithm_props | table_strategy_type | table_sharding_column | table_sharding_algorithm_type | table_sharding_algorithm_props | key_generate_column | key_generator_type | key_generator_props | auditor_types | allow_hint_disable |
+---------+----------------------------+-------------------+----------------------+------------------------+-------------------------------+----------------------------------------+-------------------+---------------------+----------------------------+----------------------------------------------+-------------------+------------------+-------------------+
| t_order | ds_${0..1}.t_order_${0..1} | | INLINE | user_id | INLINE | algorithm-expression:ds_${user_id % 2} | INLINE | order_id | INLINE | algorithm-expression:t_order_${order_id % 2} | order_id | SNOWFLAKE | | DML_SHARDING_CONDITIONS |true |
+---------+----------------------------+-------------------+----------------------+------------------------+-------------------------------+----------------------------------------+-------------------+---------------------+----------------------------+----------------------------------------------+-------------------+------------------+-------------------+
1 row in set (0.01 sec)
SHOW SHARDING ALGORITHMS
mysql> SHOW SHARDING ALGORITHMS;
+-------------------------+--------+-----------------------------------------------------+
| name | type | props |
+-------------------------+--------+-----------------------------------------------------+
| t_order_inline | INLINE | algorithm-expression=t_order_${order_id % 2} |
| t_order_item_inline | INLINE | algorithm-expression=t_order_item_${order_id % 2} |
+-------------------------+--------+-----------------------------------------------------+
2 row in set (0.01 sec)
SHOW UNUSED SHARDING ALGORITHMS
mysql> SHOW UNUSED SHARDING ALGORITHMS;
+---------------+--------+-----------------------------------------------------+
| name | type | props |
+---------------+--------+-----------------------------------------------------+
| t1_inline | INLINE | algorithm-expression=t_order_${order_id % 2} |
+---------------+--------+-----------------------------------------------------+
1 row in set (0.01 sec)
SHOW SHARDING AUDITORS
mysql> SHOW SHARDING AUDITORS;
+------------+-------------------------+-------+
| name | type | props |
+------------+-------------------------+-------+
| dml_audit | DML_SHARDING_CONDITIONS | |
+------------+-------------------------+-------+
2 row in set (0.01 sec)
SHOW SHARDING TABLE RULES USED ALGORITHM shardingAlgorithmName
mysql> SHOW SHARDING TABLE RULES USED ALGORITHM t_order_inline;
+-------+---------+
| type | name |
+-------+---------+
| table | t_order |
+-------+---------+
1 row in set (0.01 sec)
SHOW SHARDING KEY GENERATORS
mysql> SHOW SHARDING KEY GENERATORS;
+------------------------+-----------+-----------------+
| name | type | props |
+------------------------+-----------+-----------------+
| t_order_snowflake | snowflake | |
| t_order_item_snowflake | snowflake | |
| uuid_key_generator | uuid | |
+------------------------+-----------+-----------------+
3 row in set (0.01 sec)
SHOW UNUSED SHARDING KEY GENERATORS
mysql> SHOW UNUSED SHARDING KEY GENERATORS;
+------------------------+-----------+-----------------+
| name | type | props |
+------------------------+-----------+-----------------+
| dml_audit | uuid | |
+------------------------+-----------+-----------------+
1 row in set (0.01 sec)
SHOW UNUSED SHARDING KEY AUDITORS
mysql> SHOW UNUSED SHARDING KEY AUDITORS;
+------------+-------------------------+-------+
| name | type | props |
+------------+-------------------------+-------+
| dml_audit | DML_SHARDING_CONDITIONS | |
+------------+-------------------------+-------+
1 row in set (0.01 sec)
SHOW SHARDING TABLE RULES USED KEY GENERATOR keyGeneratorName
mysql> SHOW SHARDING TABLE RULES USED KEY GENERATOR t_order_snowflake;
+-------+---------+
| type | name |
+-------+---------+
| table | t_order |
+-------+---------+
1 row in set (0.01 sec)
SHOW SHARDING TABLE RULES USED AUDITOR auditorName
mysql> SHOW SHARDING TABLE RULES USED AUDITOR sharding_key_required;
+-------+---------+
| type | name |
+-------+---------+
| table | t_order |
+-------+---------+
1 row in set (0.01 sec)
SHOW DEFAULT SHARDING STRATEGY
mysql> SHOW DEFAULT SHARDING STRATEGY ;
+----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
| name | type | sharding_column | sharding_algorithm_name | sharding_algorithm_type | sharding_algorithm_props |
+----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
| TABLE | NONE | | | | |
| DATABASE | STANDARD| order_id | database_inline | INLINE | {algorithm-expression=ds_${user_id % 2}} |
+----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
2 rows in set (0.07 sec)
SHOW SHARDING TABLE NODES
mysql> SHOW SHARDING TABLE NODES;
+---------+----------------------------------------------------------------+
| name | nodes |
+---------+----------------------------------------------------------------+
| t_order | ds_0.t_order_0, ds_1.t_order_1, ds_0.t_order_2, ds_1.t_order_3 |
+---------+----------------------------------------------------------------+
1 row in set (0.02 sec)
mysql> SHOW SHARDING TABLE REFERENCE RULES;
+-------+--------------------------+
| name | sharding_table_reference |
+-------+--------------------------+
| ref_0 | t_a,t_b |
| ref_1 | t_c,t_d |
+-------+--------------------------+
2 rows in set (0.00 sec)
mysql> SHOW BROADCAST TABLE RULES;
+------------------------+
| broadcast_table |
+------------------------+
| t_1 |
| t_2 |
+------------------------+
2 rows in set (0.00 sec)