gertvdijk / nagios-plugins Goto Github PK

After removing tables and/or databases, pt-table-checksum will not remove checksum entries of the now non-existing tables. As a result, the plugin will trigger falsely.

A workaround is to periodically truncate the checksums table.

Possible solution:

• Add a HAVING clause to the query on the INFORMATION_SCHEMA to have it not respond to non-existing tables. Drawback: listing tables in INFORMATION_SCHEMA can be quite resource hungry in case lots of tables exist.
• The above, but configurable using an option.
• ...

In the event that pt-table-checksum chose to check a table in N amount of chunks and decided to do this in M < N amount of chunks later, this results in a false warning.

Simplified, the cheksums table it will look like this:

db            table            chunk      ts
==            =====            =====      ==
db_name       table_name       1          2012-12-13 08:00:05
db_name       table_name       2          2012-12-10 08:00:05

and this raises a WARNing or CRITical for the second row.