On Feb 12, 2009, at 7:13 AM, Pete Kruckenberg wrote:
Is it possible to track usage/performance on a per-database basis?
The app I work on is vertically partitioned per-customer-account,
each one with its own database. Since the app handles security (and
customers can't connect directly to MySQL), there's no need for
MySQL authentication.
But the usage stats would still be extremely useful, if I could
analyze them per-database and per-table.
The current Drizzle logging plugin implementations both have a
datafield that specifies what database the query event was for. So
you can get those stats by postprocessing the log.
This isnt perfect, in that I think it just lists what the current
"USE" value is when the query is run, and if the query fully specifies
the tables its run against, in the form of "database_name.table_name",
then someone could slip past the accounting.
The fundamental problem is that, in both MySQL and Drizzle, a
"database" doesn't actually exist. Only tables exist. A database is
just a namespace to group tables in.
--
Mark Atwood <http://mark.atwood.name>
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
