Go get last access time of a table in mysql

Question

Is there any way to know the time when last select statement has been performed on a table? I am using the InnoDB storage engine.

I have tried with the following query:

select update_time,table_name from information_schema.tables where table_schema='databasename';

..but I'm receiving NULL in the update_time column.

select update_time,table_name from information_schema.tables where table_schema='databasename'; but if i try this iam getting null in update_time column — Shabarinath Volam, Oct 08 '12 at 07:38
Edit your question and add the code there, as well as any comment you consider worth adding to clarify your question — Yaroslav, Oct 08 '12 at 07:45

score 0 · Answer 1 · edited May 23 '17 at 12:19

0

Unless you manually update a last_accessed-field on the table, my best bet would be to add query logging and parse the log-files.

I googled and found these relates questions:

edited May 23 '17 at 12:19

Community

answered Oct 08 '12 at 07:22

Morten Jensen

I have a query will innodb storage engine stores timestamps of the access time of table? – Shabarinath Volam Oct 08 '12 at 07:35

score 0 · Answer 2 · answered Apr 30 '14 at 05:25

0

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

answered Apr 30 '14 at 05:25

Himalaya Garg

2 Answers2