MySQL Forums
Forum List  »  Newbie

see which databases are being used or have been used recently
Posted by: Glen Stromquist
Date: January 10, 2017 11:51AM

I have been tasked with a mysql cleanup on a server, that is, find out which databases are in use and which ones aren't.

My background is Oracle and MS-SQLserver (on mostly windows servers) and the only exposure I've had to mysql is playing with CM websites with XAMPP on my workstation.

I've managed to find out how many databases are on the server, as well as their sizes & free space.

Is there a query I can use to see the last time a database has been accessed or touched? Or can this be setup on the OS (solaris) side?

Since mysql databases seem to be similar to the mssql concept of databases (schemas in oracle) is there a way to shutdown individual databases on a server? (That way I could shut down innocuous looking ones and see if anyone complains)

thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
see which databases are being used or have been used recently
January 10, 2017 11:51AM


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.