SHOW STATUS FROM READWRITE_SPLITTING RULE

Syntax

• When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Return Value Description

• Query readwrite splitting storage unit status for specified readwrite splitting rule in specified database.

SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0 FROM sharding_db;

mysql> SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0 FROM sharding_db;
+----------+---------+----------------+
| resource | status  | delay_time(ms) |
+----------+---------+----------------+
| ds_1     | enabled | 0              |
| ds_2     | enabled | 0              |
| ds_3     | enabled | 0              |
4 rows in set (0.01 sec)

• Query all readwrite splitting storage unit from specified database

mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES FROM sharding_db;
+----------+---------+----------------+
| resource | status  | delay_time(ms) |
+----------+---------+----------------+
| ds_0     | enabled | 0              |
| ds_1     | enabled | 0              |
| ds_2     | enabled | 0              |
| ds_3     | enabled | 0              |
4 rows in set (0.00 sec)

• Query readwrite splitting storage unit status for specified readwrite splitting rule in current database

SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0;

• Query all readwrite splitting storage unit from current database

mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES;

+----------+---------+----------------+
| resource | status  | delay_time(ms) |
+----------+---------+----------------+
| ds_0     | enabled | 0              |
| ds_1     | enabled | 0              |
| ds_2     | enabled | 0              |
| ds_3     | enabled | 0              |
+----------+---------+----------------+

Reserved word