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.
    1. SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0 FROM test1;
    1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULE ms_group_0 FROM test1;
    2. +----------+---------+----------------+
    3. | resource | status  | delay_time(ms) |
    4. +----------+---------+----------------+
    5. | su_1     | enabled | 0              |
    6. | ds_2     | enabled | 0              |
    7. | ds_1     | enabled | 0              |
    9. 4 rows in set (0.01 sec)
    • Query all readwrite splitting storage unit from specified database
    1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES FROM test1;
    2. +----------+---------+----------------+
    3. | resource | status  | delay_time(ms) |
    4. +----------+---------+----------------+
    5. | su_0     | enabled | 0              |
    6. | su_1     | enabled | 0              |
    7. | ds_2     | enabled | 0              |
    8. | ds_1     | enabled | 0              |
    9. 4 rows in set (0.00 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;
    • Query all readwrite splitting storage unit from current database
    1. mysql> SHOW STATUS FROM READWRITE_SPLITTING RULES;
    2. +----------+---------+----------------+
    3. | resource | status  | delay_time(ms) |
    4. +----------+---------+----------------+
    5. | su_0     | enabled | 0              |
    6. | su_1     | enabled | 0              |
    7. | ds_2     | enabled | 0              |
    8. | ds_1     | enabled | 0              |
    9. +----------+---------+----------------+

    Reserved word

    SHOW, STATUS, FROM, READWRITE_SPLITTING, , RULES