pt_table_checksum对检查表的chunk大小的限制

时间:2023-03-09 13:33:18
pt_table_checksum对检查表的chunk大小的限制

02-16T10:22:38 Skipping table xoxdb.tb_valuelog because on the master it would be checksummed in one chunk but on these replicas it has too many rows:
149071 rows on boshiwan-hhjj-db-slave1.xox.com
148468 rows on login-server
The current chunk size limit is 132858 rows (chunk size=66429 * chunk size limit=2.0).

故障描述:用pt_table_checksum对xoxdb.tb_valuelog做同步检查, master it would be checksummed in one chunk ,也就是只能checksum1个chunk