SHOW UNUSED SHARDING AUDITORS

Description

SHOW SHARDING AUDITORS syntax is used to query sharding auditors that are not used in specified database.

Syntax

  1. ShowUnusedShardingAuditors::=
  2.   'SHOW' 'SHARDING' 'AUDITOR'('FROM' databaseName)?
  4. databaseName ::=
  5.   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

columnDescription
nameSharding auditor name
typeSharding auditor algorithm type
propsSharding auditor algorithm properties

Example

  • Query sharding auditors that are not used in the specified logical database
  1. SHOW SHARDING AUDITORS FROM test1;
  1. mysql> SHOW SHARDING AUDITORS FROM test1;
  2. +-------------------------------+-------------------------+-------+
  3. | name                          | type                    | props |
  4. +-------------------------------+-------------------------+-------+
  5. | sharding_key_required_auditor | dml_sharding_conditions | {}    |
  6. +-------------------------------+-------------------------+-------+
  7. 1 row in set (0.01 sec)
  • Query sharding auditors are not used in the current logical database
  1. SHOW UNUSED SHARDING AUDITORS FROM test1;
  1. mysql> SHOW UNUSED SHARDING AUDITORS FROM test1;
  2. +-------------------------------+-------------------------+-------+
  3. | name                          | type                    | props |
  4. +-------------------------------+-------------------------+-------+
  5. | sharding_key_required_auditor | dml_sharding_conditions | {}    |
  6. +-------------------------------+-------------------------+-------+
  7. 1 row in set (0.00 sec)

Reserved word

SHOW, UNUSED, SHARDING, AUDITORS, FROM