pt-table-checksum Summary information

[Steve Simpson]

This is a suggestion for adding summary information to the top of checksum report. I get this emailed daily & just want to glance and see if there are problems.

From my systems:

PT Table Checksum Report
host.domain
Tue Nov 4 10:19:43 CST 2014

Errors = 0
Diffs = 0
Skips = 0

           TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
11-04T10:19:33 0 0 14 1 0 53.098 adb.aaa
...

Here is the post processing bash script that I use to create it:
#!/bin/bash
DATAFILE=`mktemp`
TEMPDATA=`mktemp`
ERRDATA=`mktemp`
chmod 600 $DATAFILE $TEMPDATA $ERRDATA
/usr/bin/pt-table-checksum -F /etc/my.cnf.percona h=host.domain --recursion-method=dsn="D=percona,t=dsns" --replicate-check --no-check-binlog-format --chunk-size-limit=0 --nocheck-plan > $DATAFILE 2> $ERRDATA
echo PT Table Checksum Report > $TEMPDATA
hostname >> $TEMPDATA
date >> $TEMPDATA
echo >> $TEMPDATA
awk '!/^#/ {errors += $2; diffs += $3; skips += $6} END {print "Errors = " errors "\nDiffs = " diffs "\nSkips = " skips}' $DATAFILE >> $TEMPDATA
echo >> $TEMPDATA
cat $DATAFILE >> $TEMPDATA
echo >> $TEMPDATA
cat $ERRDATA >> $TEMPDATA
mailx -s "Percona Toolkit pt-table-checksum" <email address hidden> < $TEMPDATA > /dev/null 2>&1
rm -f $TEMPDATA $DATAFILE $ERRDATA

[Nilnandan Joshi (nilnandan-joshi)]

Hi,

Thank you for reporting this. Definitely, it will be helpful if pt-table-checksum provides summary information . For the several tables, we don't need to check whole report to find there is difference/error or not.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1250