Retro Eye care Haitian Deep Dark Default

SHOW STREAMING RULE

Description

The SHOW STREAMING RULE syntax is used to query the CDC streaming rule.

Syntax

ShowStreamingRule ::=
  'SHOW' 'STREAMING' 'RULE'

Return Value Description

Column Description
read Data reading configuration
write Data writing configuration
stream_channel Data channel

Example

  • Query CDC streaming rule
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)

Reserved word

SHOW, STREAMING, RULE