We have 300 databases in our environment mixed of MyISAM and Innodb(innodb_file_per_table has been enabled) tables.Using MySQL 5.5.19 version. I
we are planning archive inactive database.Is there any way we can check what databasese are inactive?
I have checked at the OS level file modification timestamp,but as we have so many database its taking time.Please let me know is there anyway we can check.
Note: Timestamp column is not present in any of tables