Determine last time a mysql table was accessed (i.e. SELECT'ed) In my mysql DB schema there are old tables that are no longer used.
I want to come up with a systematic way to show my developer a list of tables and last time they were read (SELECT'ed, not UPDATE'ed: that would be easy).

There's a way of getting the general_log and parsing the gigantic file, but it's not elegant. I'm wondering if there's a tool or technique to learn and record time as each table gets accessed/read. Thanks.

My environment is 5.5 and 5.6
It is not possible to view accessed information unless and untill General Query Log is enabled in Mysql
you can enable general query log in mysql 5.5 as follows, which would help you in future
Here's how in Dhanesh Mane's words:

OS : Ubuntu 12.04.1 LTS
MySQL version : 5.5.28
Locate and edit my.cnf file. We need to change two variables in this file to enable general query log.

sudo gedit /etc/mysql/my.cnf
Locate this variable in the file : general_log_file
It must have some default value, this variable is nothing but the path of log file.
The default value is &quot;/var/log/mysql/mysql.log&quot;, you can change it as per your wish.
Now locate variable &quot;general_log&quot;, and set it to 1. The means turning on the log system.
Now restart the MySQL server by running : sudo service mysql restart
now if you open the mysql.log file, you can see all SQL queries in it


Hope this helps!