复古 护眼 海天 深邃 暗黑 默认

SHOW MIGRATION RULE

描述

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

语法

ShowMigrationRule ::=
  'SHOW' 'MIGRATION' 'RULE'

返回值说明

说明
read 数据读取配置
write 数据写入配置
stream_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)

保留字

SHOWMIGRATIONRULE

相关链接