SHOW STREAMING RULE 语法用于查询 CDC Streaming 规则。
ShowStreamingRule ::=
'SHOW' 'STREAMING' 'RULE'
| 列 | 说明 |
|---|---|
| read | 数据读取配置 |
| write | 数据写入配置 |
| stream_channel | 数据通道 |
SHOW STREAMING RULE;
mysql> SHOW STREAMING 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、STREAMING、RULE