Posted by Jerry Stuckle on 02/01/08 12:37

mosesdinakaran@gmail.com wrote:
> 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
>

What does this have to do with PHP? Maybe you should be asking in a
MySQL newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]