When was the last time a mysql table was accessed?

Question

Is there a way to tell the last access time of a mysql table? By access I mean any type of operation in that table including update, alter or even select or any other operation.

Thanks.

Answer 1

You can get the last update time of a table.

SELECT update_time FROM information_schema.tables WHERE table_name='tablename'