MySQL Forums
Forum List  »  Optimizer & Parser

Re: identifying unused databases
Posted by: kannan Mohan
Date: January 12, 2011 10:31PM

Thanks James,

I have found one more way of solving this.

if you issue the below query it will display you the statistics information about the databases and tables in your cluster

select * from information_schema.tables;

And this will have all statistical data including the date of last access.

Options: ReplyQuote

Written By
December 27, 2010 10:31PM
December 31, 2010 08:26PM
Re: identifying unused databases
January 12, 2011 10:31PM
January 15, 2011 12:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.