468,727 Members | 1,619 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,727 developers. It's quick & easy.

How to Find the Last Accessed Date of a MySql Database


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
Feb 1 '08 #1
1 3531
mo************@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.
js*******@attglobal.net
==================

Feb 1 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Hieronimus | last post: by
6 posts views Thread by Geoff Cox | last post: by
1 post views Thread by CARIGAR | last post: by
9 posts views Thread by bryonone | last post: by
xarzu
1 post views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.