使用命令 SHOW TABLEGROUPS 和 SHOW CREATE TABLE 来查看表组信息。
示例:查看表组信息和定义
obclient> show tablegroups;
+-----------------+------------+---------------+
| Tablegroup_name | Table_name | Database_name |
+-----------------+------------+---------------+
| oceanbase | NULL | NULL |
| tpcc_group | cust | tpccdb |
| tpcc_group | dist | tpccdb |
| tpcc_group | hist | tpccdb |
| tpcc_group | nord | tpccdb |
| tpcc_group | ordl | tpccdb |
| tpcc_group | ordr | tpccdb |
| tpcc_group | stok | tpccdb |
| tpcc_group | ware | tpccdb |
+-----------------+------------+---------------+
9 rows in set (0.01 sec)
obclient> show create tablegroup tpcc_group\G
*************************** 1. row ***************************
Tablegroup: tpcc_group
Create Tablegroup: CREATE TABLEGROUP IF NOT EXISTS `tpcc_group` BINDING = FALSE
partition by hash partitions 6
1 row in set (0.00 sec)