SHOW MIGRATION RULE 语法用于查询数据迁移规则
ShowMigrationRule ::=
'SHOW' 'MIGRATION' 'RULE'
| 列 | 说明 |
|---|---|
| read | 数据读取配置 |
| write | 数据写入配置 |
| stream_channel | 数据通道 |
SHOW MIGRATION RULE;
mysql> SHOW MIGRATION RULE;
+--------------------------------------------------------------+--------------------------------------+------------------------------------------------------+
| read | write | stream_channel |
+--------------------------------------------------------------+--------------------------------------+------------------------------------------------------+
| {"workerThread":40,"batchSize":1000,"shardingSize":10000000} | {"workerThread":40,"batchSize":1000} | {"type":"MEMORY","props":{"block-queue-size":10000}} |
+--------------------------------------------------------------+--------------------------------------+------------------------------------------------------+
1 row in set (0.01 sec)
SHOW、MIGRATION、RULE