[ILUG] measuring mysql user usage

[John P. Looney]

On Fri, Nov 12, 2004 at 11:02:47AM +0000, Robert Sweetnam mentioned:
> I'm using MySQL Administrator
> http://www.mysql.com/products/administrator/ which is a nice little
> app. Once you have it up and running and a connection made to the
> server you get some nich realtime graphs and monitoring stats.
> In the 'Server Connections' menu you see what users are accessing what
> database, their PID, status and time.

 Very pretty. I accidentally clicked on "user adminstrator" though. You'd
be surprised how long it takes to get back to you with 2100 databases and
4500 users - 15 minutes, and counting :(

John