为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】: 5.7.25-TiDB-v3.0.1
- 【问题描述】:普通表有数据容量/索引容量/数据条目数,但分区表没有
select * from tables where table_name = 'xxxxx' \G
*************************** 1. row ***************************
TABLE_CATALOG: def
TABLE_SCHEMA: xxx
TABLE_NAME: xxxxxxxxxxxxx
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Compact
TABLE_ROWS: 431520818
AVG_ROW_LENGTH: 911
DATA_LENGTH: 393358100745
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 30018464866
DATA_FREE: 0
AUTO_INCREMENT: 0
CREATE_TIME: 2019-09-30 14:28:09
UPDATE_TIME: NULL
CHECK_TIME: NULL
TABLE_COLLATION: utf8mb4_bin
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT:
TIDB_TABLE_ID: 146
1 row in set (0.14 sec)
以下分区表没有,所以有容量问题的时候除了加机器不知道怎么处理数据
TIDB_TABLE_ID: 228
*************************** 4. row ***************************
TABLE_CATALOG: def
TABLE_SCHEMA: xxxx
TABLE_NAME: xxxxx_count
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Compact
TABLE_ROWS: 0
AVG_ROW_LENGTH: 0
DATA_LENGTH: 0
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 0
DATA_FREE: 0
AUTO_INCREMENT: 0
CREATE_TIME: 2020-03-29 10:08:00
UPDATE_TIME: NULL
CHECK_TIME: NULL
TABLE_COLLATION: utf8_bin
CHECKSUM: NULL
CREATE_OPTIONS: partitioned
TABLE_COMMENT:
TIDB_TABLE_ID: 256
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。