
mysql 5.7.17
os: red hat 7
两个节点主主异步复制,表中数据行数一致。1节点产生的ibd文件比2节点小。
1节点:
9474932736 May 17 07:12 hist1_136.ibd
2节点:
11945377792 May 17 05:38 hist1_136.ibd
查询information_schema.table 如下
TABLE_CATALOG: def
TABLE_SCHEMA: xx
TABLE_NAME: hist1_136
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Dynamic
TABLE_ROWS: 25920107
AVG_ROW_LENGTH: 193
DATA_LENGTH: 5009047552
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 3809411072
DATA_FREE: 5242880
AUTO_INCREMENT: 26432402
CREATE_TIME: 2020-10-12 11:15:48
UPDATE_TIME: 2022-05-17 04:45:04
CHECK_TIME: NULL
TABLE_COLLATION: gbk_bin
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT:
os 磁盘为ext4,os无报错,2节点经常会使用alter table xxxx engine=innodb
参数文件未发现明显不一致,其他系统同样架构ibd文件大小一致,目前无思路求助大佬指点。