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