Anyone happen to know, offhand, how I can check to see if any table in MySQL has been altered? This is MySQL 4.1.15. Obviously "SELECT count(*) ..." could fail as could checking which keys are present in a given table. Something as simple as an UPDATE statement can easily foil both of those checks. I've tried 'SHOW STATUS ...', but that also fails. The only thing I can think of is to use a DBI trace to capture SQL and look for INSERT, UPDATE, or DELETE statements and try and parse them for the appropriate tables.
Google's given me no love on this problem.
In which case I think you're stuffed since AFAIK this bug is still open.
Add some triggers and doing it yourself would seem to be the obvious solution
Re:Are you using InnoDB?
Ovid on 2007-02-09T11:16:18
Can't use triggers with this version of MySQL (as I'm sure you're aware). However, even though the tables are MyISAM, the Update_time is not being set for me which is why 'SHOW STATUS' seems virtually useless.
(God I hate MySQL)
mysqld with --log-update to capture any SQL statements that update data as described in the fine manual.