471,323 Members | 1,520 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,323 software developers and data experts.

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 3794
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.