The SHOW MIGRATION RULE syntax is used to query migration rule.
ShowMigrationRule ::=
'SHOW' 'MIGRATION' 'RULE'
| Colume | Description |
|---|---|
| read | Data reading configuration |
| write | Data writting configuration |
| stream_channel | Data 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