SHOW MIGRATION RULE

描述

SHOW MIGRATION RULE 语法用于查询数据迁移规则。

语法

语法 铁路图

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

返回值说明

列说明
read数据读取配置
write数据写入配置
stream_channel数据通道

示例

  • 查询数据迁移规则
  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)

保留字

SHOW、MIGRATION、RULE

相关链接