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

Grammar Railroad diagram

  1. ShowStatusFromReadwriteSplittingRule ::=
  2.   'SHOW' 'STATUS' 'FROM' 'READWRITE_SPLITTING' ('RULES' | 'RULE' groupName) ('FROM' databaseName)?
  4. groupName ::=
  5.   identifier
  7. databaseName ::=
  8.   identifier

Supplement

  • 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

ColumnsDescription
storage_unitstorage unit name
statusstorage unit status

Example

  • Query readwrite-splitting storage unit status for specified readwrite-splitting rule in specified database.
  1. SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0 FROM sharding_db;
  1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0 FROM sharding_db;
  2. +--------------+----------+
  3. | storage_unit | status   |
  4. +--------------+----------+
  5. | ds_0         | disabled |
  6. +--------------+----------+
  7. 1 rows in set (0.01 sec)
  • Query all readwrite-splitting storage unit from specified database
  1. SHOW STATUS FROM READWRITE_SPLITTING RULES FROM sharding_db;
  1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES FROM sharding_db;
  2. +--------------+----------+
  3. | storage_unit | status   |
  4. +--------------+----------+
  5. | ds_0         | disabled |
  6. +--------------+----------+
  7. 1 rows in set (0.01 sec)
  • Query readwrite-splitting storage unit status for specified readwrite-splitting rule in current database
  1. SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0;
  1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0;
  2. +--------------+----------+
  3. | storage_unit | status   |
  4. +--------------+----------+
  5. | ds_0         | disabled |
  6. +--------------+----------+
  7. 1 rows in set (0.01 sec)
  • Query all readwrite-splitting storage unit from current database
  1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES;
  1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES;
  2. +--------------+----------+
  3. | storage_unit | status   |
  4. +--------------+----------+
  5. | ds_0         | disabled |
  6. +--------------+----------+
  7. 1 rows in set (0.01 sec)

Reserved word

SHOW, STATUS, FROM, READWRITE_SPLITTING, RULE, RULES