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

Question

How do you find out the last time a MySQL database was read or written to?

Can you even do that check per table?

Almost duplicate of https://stackoverflow.com/questions/307438/how-can-i-tell-when-a-mysql-table-was-last-updated — Sybille Peters, Jan 02 '18 at 17:02

score 14 · Accepted Answer · edited May 23 '17 at 12:07

14

SELECT UPDATE_TIME
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_SCHEMA = 'dbname'
AND    TABLE_NAME = 'tabname'

edited May 23 '17 at 12:07

Community

answered Feb 26 '10 at 20:13

lecodesportif

3

It's table_schema, not table_scheme. – Neil Feb 26 '10 at 21:34
1

How about the answer for the entire database? – Aditya M P Apr 09 '13 at 08:54
2

My DB returns a NULL. Wander why ? – Ruwantha Aug 20 '13 at 03:02
@adityamenon Leave out the last line and it will give you results for all tables in the database. I did something like this: `SELECT TABLE_NAME, UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbname' ORDER BY UPDATE_TIME;` – bmaupin Mar 16 '15 at 15:42

score 4 · Answer 2 · answered Feb 27 '10 at 05:53

4

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.

answered Feb 27 '10 at 05:53

Martin

score -1 · Answer 3 · answered Feb 26 '10 at 20:13

-1

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

answered Feb 26 '10 at 20:13

antony

3 Answers3