How do you get the last access (and/or write) time of a MySQL database?

sql mysql database

SELECT UPDATE_TIMEFROM   INFORMATION_SCHEMA.TABLESWHERE  TABLE_SCHEMA = 'dbname'AND    TABLE_NAME = 'tabname'

sql mysql database

If your database has bin logs switched on, you can get the last update time using mysqlbinlog.

If your database has query logging enabled, you can get the last query time (either updates or selects) by tailing the query log.

sql mysql database

check out command SHOW TABLE STATUS;
example: SHOW TABLE STATUS WHERE name="table_name_here", you need value from column Update_time

CodeHunter