MySQL Forums
Forum List  »  Optimizer & Parser

Re: identifying unused databases
Posted by: Rick James
Date: December 31, 2010 08:26PM

There is not really any way to do that. Here are some clumsy suggestions:

* Drop the database (after backing it up). If no one complains, that it was dead.

* Turn on the "general log". Let the system run a week. (But watch out for the disk filling up.) Grep through the general log to find all the databases mentioned. Then assume the other databases are dead.

* Change the permissions of all the logins so that they do not have access to the suspected databases. Wait for someone to complain.

Options: ReplyQuote


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