Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1427552
  2. Comment #5

Comment 5 for bug 1427552

Revision history for this message
Lucian Atodiresei (lucian-m) wrote :

I tried pt-table-checksum with option '--binary-index' but the error is still show. Here's the table structure when running with '--binary-index':
===
CREATE TABLE `_checksums` (
  `db` char(64) NOT NULL,
  `tbl` char(64) NOT NULL,
  `chunk` int(11) NOT NULL,
  `chunk_time` float DEFAULT NULL,
  `chunk_index` varchar(200) DEFAULT NULL,
  `lower_boundary` blob,
  `upper_boundary` blob,
  `this_crc` char(40) NOT NULL,
  `this_cnt` int(11) NOT NULL,
  `master_crc` char(40) DEFAULT NULL,
  `master_cnt` int(11) DEFAULT NULL,
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`db`,`tbl`,`chunk`),
  KEY `ts_db_tbl` (`ts`,`db`,`tbl`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
===