From the
bean counting dept.:
Many MySQL DBAs are frustrated by their inability to account for high server usage. The engineers at Software Workshop had similar feelings when trying to find 'usage hogs' among web hosting clients. Current tools provide good reports on overall activity -- but none report usage by individual users, a specific database, or connecting client.
Relying on years of expertise, Software Workshop developed their own
modifications to Open Source MySQL and called it ExtSQL(TM). It gives DBAs
a simple way to monitor activity by individual users, database, or even
connection. ExtSQL has new commands built into the server as an extension
to the SQL language, e.g.
SHOW STATISTICS select, insert FROM user HISTORY -- allows the DBA to
see the number of select and insert statements issued by all users by hour.
prnewswire
Download