【产品名称】
【产品版本】
【问题描述】
我有一个表,他有好几个索引。我想知道每个索引占用的大小,请问这个从哪个视图查哪?
【产品名称】
【产品版本】
【问题描述】
我有一个表,他有好几个索引。我想知道每个索引占用的大小,请问这个从哪个视图查哪?
查这张表,关注标红的2个字段;
MySQL [oceanbase]> desc __all_virtual_meta_table;
+--------------------+---------------+------+-----+-----------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------+------+-----+-----------------------+-------+
| tenant_id | bigint(20) | NO | PRI | NULL | |
| table_id | bigint(20) | NO | PRI | NULL | |
| partition_id | bigint(20) | NO | PRI | NULL | |
| svr_ip | varchar(46) | NO | PRI | NULL | |
| svr_port | bigint(20) | NO | PRI | NULL | |
| gmt_create | timestamp(6) | NO | | NULL | |
| gmt_modified | timestamp(6) | NO | | NULL | |
| sql_port | bigint(20) | NO | | NULL | |
| unit_id | bigint(20) | NO | | NULL | |
| partition_cnt | bigint(20) | NO | | NULL | |
| zone | varchar(128) | NO | | NULL | |
| role | bigint(20) | NO | | NULL | |
| member_list | varchar(4480) | NO | | NULL | |
| row_count | bigint(20) | NO | | NULL | |
| data_size | bigint(20) | NO | | NULL | |
| data_version | bigint(20) | NO | | NULL | |
| data_checksum | bigint(20) | NO | | NULL | |
| row_checksum | bigint(20) | NO | | NULL | |
| column_checksum | varchar(8192) | NO | | NULL | |
| is_original_leader | bigint(20) | NO | | 0 | |
| is_previous_leader | bigint(20) | NO | | 0 | |
| create_time | bigint(20) | NO | | NULL | |
| rebuild | bigint(20) | NO | | 0 | |
| replica_type | bigint(20) | NO | | 0 | |
| required_size | bigint(20) | NO | | 0 | |
| status | varchar(64) | NO | | REPLICA_STATUS_NORMAL | |
| is_restore | bigint(20) | NO | | 0 | |
| partition_checksum | bigint(20) | NO | | 0 | |
| quorum | bigint(20) | NO | | -1 | |
| fail_list | varchar(1024) | NO | | | |
| recovery_timestamp | bigint(20) | NO | | 0 | |
| memstore_percent | bigint(20) | NO | | 100 | |
| data_file_id | bigint(20) | NO | | 0 | |
+--------------------+---------------+------+-----+-----------------------+-------+
33 rows in set (0.021 sec)
谢谢