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


Subject
Views
Written By
Posted
5995
December 27, 2010 10:31PM
2582
December 31, 2010 08:26PM
Re: identifying unused databases
2291
January 12, 2011 10:31PM
1822
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.