Make mk-table-checksum support schema objects

[GoogleCodeExporter]

The --schema option is very useful.  For MySQL 5 and newer, we can also
checksum triggers, view definitions, and so on.  We can do queries like the
following:

select EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_TIMING,
EVENT_MANIPULATION, crc32(concat_ws('#',ACTION_STATEMENT,SQL_MODE)) AS CRC
from INFORMATION_SCHEMA.TRIGGERS;

The information_schema is very slow and only certain tables should be
checksummed from it, and it needs to be order-independent I think.  This
will be special-case code.

ROUTINES
TRIGGERS
VIEWS

And maybe EVENTS in 5.1?

Original issue reported on code.google.com by baron.schwartz on 9 Oct 2008 at 8:13

[GoogleCodeExporter]

Issue 566 has been merged into this issue.

Original comment by baron.schwartz on 6 Oct 2009 at 2:31

[GoogleCodeExporter]

Original comment by baron.schwartz on 1 Feb 2010 at 1:29

• Added labels: Tag-I_S, Tag-schema

[GoogleCodeExporter]

Original comment by dan...@percona.com on 23 Mar 2010 at 7:01

• Added labels: Benefit-Helpful, Effort-Moderate
• Removed labels: Priority-Medium