SHOW MIGRATION RULE

Description

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

Syntax

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

Return Value Description

ColumeDescription
readData reading configuration
writeData writting 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":40,"batchSize":1000,"shardingSize":10000000} | {"workerThread":40,"batchSize":1000} | {"type":"MEMORY","props":{"block-queue-size":10000}} |
  6. +--------------------------------------------------------------+--------------------------------------+------------------------------------------------------+
  7. 1 row in set (0.01 sec)

Reserved word

SHOW, MIGRATION, RULE