SUSE 11 Enterprise
I have MASTER-SLAVE replication set up.
pt-table-checksum consistently returns different checksums for 2 tables. When I do a mysqldump on the tables and the do a DIFF on the dump files, there are no differences.
I’ve also refreshed the slave 2 times and restarted replication, but the tables still show different checksums for those tables.
Below are the fields from one of the tables.
search_index | CREATE TABLE
word varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘The search_total.word that is associated with the search item.’,
sid int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘The search_dataset.sid of the searchable item to which the word belongs.’,
type varchar(16) NOT NULL COMMENT ‘The search_dataset.type of the searchable item to which the word belongs.’,
score float DEFAULT NULL COMMENT ‘The numeric score of the word, higher being more important.’,
PRIMARY KEY (
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Any ideas what might be going on?