By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 IT Pros & Developers. It's quick & easy.

How to Find the Last Accessed Date of a MySql Database

P: n/a

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
Share this Question
Share on Google+
1 Reply


P: n/a
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.