Single Table

Syntax

  1. SHOW DEFAULT SINGLE TABLE STORAGE UNIT [FROM databaseName]
  3. SHOW SINGLE (TABLES | table) [FROM databaseName]
  5. COUNT SINGLE_TABLE RULE [FROM databaseName]
  7. table:
  8.     TABLE tableName

Return Value Description

Single Table Storage Unit

ColumnDescription
storage_unit_nameStorage unit name

Single Table

ColumnDescription
table_nameSingle table name
storage_unit_nameThe storage unit where the single table is located

Single Table Rule Count

ColumnDescription
rule_nameSingle table rule name
databaseThe database name where the single table is located
countThe count of single table rules

Example

SHOW DEFAULT SINGLE TABLE STORAGE UNIT

  1. sql> SHOW DEFAULT SINGLE TABLE STORAGE UNIT;
  2. +-------------------+
  3. | storage_unit_name |
  4. +-------------------+
  5. |  ds_0             |
  6. +-------------------+
  7. 1 row in set (0.01 sec)

SHOW SINGLE TABLE tableName

  1. sql> SHOW SINGLE TABLE t_single_0;
  2. +----------------+-------------------+
  3. | table_name     | storage_unit_name |
  4. +----------------+-------------------+
  5. | t_single_0     | ds_0              |
  6. +----------------+-------------------+
  7. 1 row in set (0.01 sec)

SHOW SINGLE TABLES

  1. mysql> SHOW SINGLE TABLES;
  2. +--------------+-------------------+
  3. | table_name   | storage_unit_name |
  4. +--------------+-------------------+
  5. | t_single_0   | ds_0              |
  6. | t_single_1   | ds_1              |
  7. +--------------+-------------------+
  8. 2 rows in set (0.02 sec)

COUNT SINGLE_TABLE RULE

  1. mysql> COUNT SINGLE_TABLE RULE;
  2. +--------------+----------+-------+
  3. | rule_name    | database | count |
  4. +--------------+----------+-------+
  5. | t_single_0   | ds       | 2     |
  6. +--------------+----------+-------+
  7. 1 row in set (0.02 sec)