Posted by mosesdinakaran@gmail.com on 02/01/08 11:05

Hi All,

How to find out the last accessed date of a MySql Database.

I have around 200 databases in my server some are used and some are
not in Use, I want to remove the database that are not in Use.

SHOW TABLE STATUAS gives me last updated Date.

In my case there are some database which are not updated at all, but
it is in use (ie only SELECT no UPDATE)

So Is there a way to get the datetime of the last SELECT query that is
being execued in a Database.

Thanks
Moses

[Back to original message]