View information about a table group

2023-08-18 09:26:34  Updated

You can use the SHOW TABLEGROUPS and SHOW CREATE TABLE commands to view information about a table group.

Example: Viewing information and definition of a table group

obclient> show tablegroups;
+-----------------+------------+---------------+
| TABLEGROUP_NAME | TABLE_NAME | DATABASE_NAME |
+-----------------+------------+---------------+
| TPCC_GROUP      | CUST       | TPCC          |
| TPCC_GROUP      | DIST       | TPCC          |
| TPCC_GROUP      | HIST       | TPCC          |
| TPCC_GROUP      | NORD       | TPCC          |
| TPCC_GROUP      | ORDL       | TPCC          |
| TPCC_GROUP      | ORDR       | TPCC          |
| TPCC_GROUP      | STOK       | TPCC          |
| TPCC_GROUP      | WARE       | TPCC          |
| oceanbase       | NULL       | NULL          |
+-----------------+------------+---------------+
9 rows in set (0.02 sec)

obclient> show create tablegroup tpcc_group\G
*************************** 1. row ***************************
       TABLEGROUP: TPCC_GROUP
CREATE TABLEGROUP: CREATE TABLEGROUP "TPCC_GROUP"  BINDING = FALSE
  partition by hash partitions 6

1 row in set (0.00 sec)

Contact Us