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