SHOW MIGRATION RULE

Description

The SHOW MIGRATION RULE syntax is used to query migration rule.

Syntax

Grammar Railroad diagram

  1. ShowMigrationRule ::=
  2.   'SHOW' 'MIGRATION' 'RULE'

Return Value Description

ColumnDescription
readData reading configuration
writeData writing configuration
stream_channelData channel

Example

  • Query migration rule
  1. SHOW MIGRATION RULE;
  1. mysql> SHOW MIGRATION RULE;
  2. +--------------------------------------------------------------+--------------------------------------+-------------------------------------------------------+
  3. | read                                                         | write                                | stream_channel                                        |
  4. +--------------------------------------------------------------+--------------------------------------+-------------------------------------------------------+
  5. | {"workerThread":20,"batchSize":1000,"shardingSize":10000000} | {"workerThread":20,"batchSize":1000} | {"type":"MEMORY","props":{"block-queue-size":"2000"}} |
  6. +--------------------------------------------------------------+--------------------------------------+-------------------------------------------------------+
  7. 1 row in set (0.01 sec)

Reserved word

SHOW, MIGRATION, RULE