MySQL Database Archive

Posted on

Question :

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

Answer :

(A non-answer)

There is essentially no way.

atime should be turned off, else performance will be quite bad.

Just because you have not used a database in the last week does not mean that you won’t use it next week.

You can check binary logs for databases and tables…

Leave a Reply

Your email address will not be published. Required fields are marked *