Retro Eye care Haitian Deep Dark Default

SHOW UNUSED SHARDING AUDITORS

Description

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

Syntax

ShowUnusedShardingAuditors::=
  'SHOW' 'SHARDING' 'AUDITOR'('FROM' databaseName)?

databaseName ::=
  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

column Description
name Sharding auditor name
type Sharding auditor algorithm type
props Sharding auditor algorithm properties

Example

  • Query sharding auditors that are not used in the specified logical database
SHOW SHARDING AUDITORS FROM test1;

mysql> SHOW SHARDING AUDITORS FROM test1;
+-------------------------------+-------------------------+-------+
| name                          | type                    | props |
+-------------------------------+-------------------------+-------+
| sharding_key_required_auditor | dml_sharding_conditions | {}    |
+-------------------------------+-------------------------+-------+
1 row in set (0.01 sec)
  • Query sharding auditors are not used in the current logical database
SHOW UNUSED SHARDING AUDITORS FROM test1;

mysql> SHOW UNUSED SHARDING AUDITORS FROM test1;
+-------------------------------+-------------------------+-------+
| name                          | type                    | props |
+-------------------------------+-------------------------+-------+
| sharding_key_required_auditor | dml_sharding_conditions | {}    |
+-------------------------------+-------------------------+-------+
1 row in set (0.00 sec)

Reserved word

SHOW, UNUSED, SHARDING, AUDITORS, FROM