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

2 Answers 2


(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.

  • yes james i agree..but there are few database are not using from last 2 yrs ..so i would like to listout such databases.(forgot to mention in my requirement)
    – Rajesh
    Dec 18, 2015 at 13:46

You can check binary logs for databases and tables...

  • its standalone server..didn't enable binlogs...even if we enable how can it helpful
    – Rajesh
    Dec 17, 2015 at 18:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.