Re: identifying unused databases

[kannan Mohan]

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.