SHOW STATUS FROM READWRITE_SPLITTING RULE
Description
The SHOW STATUS FROM READWRITE_SPLITTING RULE syntax is used to query readwrite-splitting storage unit status for specified readwrite-splitting rule in specified database.
Syntax
ShowStatusFromReadwriteSplittingRules ::=
'SHOW' 'STATUS' 'FROM' 'READWRITE_SPLITTING' ('RULES' | 'RULE' groupName) ('FROM' databaseName)?
groupName ::=
identifier
databaseName ::=
identifierSupplement
- When
databaseNameis not specified, the default is the currently usedDATABASE. IfDATABASEis not used,No database selectedwill be prompted.
Return Value Description
| Columns | Description |
|---|---|
| name | readwrite-splitting rule name |
| storage_unit | storage unit name |
| status | storage unit status |
Example
- 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;
+-------------+--------------+----------+
| name | storage_unit | status |
+-------------+--------------+----------+
| ms_group_0 | ds_0 | disabled |
+-------------+--------------+----------+
1 row in set (0.01 sec)- Query all readwrite-splitting storage unit status from specified database.
SHOW STATUS FROM READWRITE_SPLITTING RULES FROM sharding_db;mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES FROM sharding_db;
+-------------+--------------+----------+
| name | storage_unit | status |
+-------------+--------------+----------+
| ms_group_0 | ds_0 | disabled |
+-------------+--------------+----------+
1 row in set (0.01 sec)- Query readwrite-splitting storage unit status for specified readwrite-splitting rule in current database
SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0;mysql> SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0;
+-------------+--------------+----------+
| name | storage_unit | status |
+-------------+--------------+----------+
| ms_group_0 | ds_0 | disabled |
+-------------+--------------+----------+
1 row in set (0.01 sec)- Query all readwrite-splitting storage unit status from current database.
SHOW STATUS FROM READWRITE_SPLITTING RULES;mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES;
+-------------+--------------+----------+
| name | storage_unit | status |
+-------------+--------------+----------+
| ms_group_0 | ds_0 | disabled |
+-------------+--------------+----------+
1 row in set (0.01 sec)Reserved word
SHOW, STATUS, FROM, READWRITE_SPLITTING, RULE, RULES