Usage: pmp-check-pt-table-checksum [OPTIONS]
Options:
  -c CRIT         Raise a critical error instead of a warning.
  --defaults-file FILE Only read mysql options from the given file.
                  Defaults to /etc/nagios/mysql.cnf if it exists.
  -H HOST         MySQL hostname.
  -l USER         MySQL username.
  -L LOGIN-PATH   Use login-path to access MySQL (with MySQL client 5.6).
  -p PASS         MySQL password.
  -P PORT         MySQL port.
  -S SOCKET       MySQL socket file.
  -i INTERVAL     Interval over which to ensure pt-table-checksum was run,
                  in days; default - not to check.
  -T TABLE        The checksum table; default percona.checksums
  -w WARN         Warning threshold; ignored.
  --help          Print help and exit.
  --version       Print version and exit.
Options must be given as --option value, not --option=value or -Ovalue.
Use perldoc to read embedded documentation with more details.

SELECT /\* MAGIC_checksum_diff_query \*/
CONCAT(
   COUNT(\*),
   ' chunks differ in ',
   COUNT(DISTINCT CONCAT(db, tbl)),
   ' tables, including ',
   MIN(CONCAT(db, '.', tbl)))
FROM CHECKSUM_TABLE
WHERE master_cnt <> this_cnt OR master_crc <> this_crc
   OR ISNULL(master_crc) <> ISNULL(this_crc)
HAVING COUNT(\*) > 0