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.
ShowStatusFromReadwriteSplittingRule ::=
'SHOW' 'STATUS' 'FROM' 'READWRITE_SPLITTING' ('RULES' | 'RULE' groupName) ('FROM' databaseName)?
groupName ::=
identifier
databaseName ::=
identifier
databaseName
is not specified, the default is the currently used DATABASE
. If DATABASE
is not used, No database selected
will be prompted.Columns | Description |
---|---|
storage_unit | storage unit name |
status | storage unit status |
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;
+--------------+----------+
| storage_unit | status |
+--------------+----------+
| ds_0 | disabled |
+--------------+----------+
1 rows in set (0.01 sec)
SHOW STATUS FROM READWRITE_SPLITTING RULES FROM sharding_db;
mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES FROM sharding_db;
+--------------+----------+
| storage_unit | status |
+--------------+----------+
| ds_0 | disabled |
+--------------+----------+
1 rows in set (0.01 sec)
SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0;
mysql> SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0;
+--------------+----------+
| storage_unit | status |
+--------------+----------+
| ds_0 | disabled |
+--------------+----------+
1 rows in set (0.01 sec)
mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES;
mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES;
+--------------+----------+
| storage_unit | status |
+--------------+----------+
| ds_0 | disabled |
+--------------+----------+
1 rows in set (0.01 sec)
SHOW
, STATUS
, FROM
, READWRITE_SPLITTING
, RULE
, RULES