Log all table updates for all tables in MySQL
I got some interesting news for you. You cannot use information_schema.tables because it does not track changes to InnoDB tables.

The best way to find out when a table changed is to go to the OS and get the most recent timestamp of each table. Rather than plagiarize my own posts, here are my posts where I show you how to do this


Sep 25, 2014 : want to find out which databases are used in last 30 days or not
Jun 03, 2013 : Is there a way to find the least recently used tables in a schema?
Apr 04, 2013 : How to check which tables in DB (MYSQL) updated in last 1 hour / last 1 minute?
Dec 21, 2011 : Fastest way to check if InnoDB table has changed


Give Them a Try !!!