Click to See Complete Forum and Search --> : how many logical databases in last hour


jasongr
05-21-2007, 03:29 PM
Hi

I have a database server with many logical databases.
The set of logical databases changes dynamically.
Is it possible to found out how many logical databases were added on the server in the last hour using a query?

regards

jasongr
05-21-2007, 03:55 PM
Just for clarification:

The physical database is the actual server that has a set IP address.
A physical database can have many logical databases, like database 'mysql' that is installed automatically.
A logical database gets added when using the command:
CREATE DATABASE IF NOT EXISTS `dummy`;

I hope this helps