measuring mysql usage

2009-08-31 Thread John Almberg
Anyone know of a tool that can measure mysql usage per mysql user? My database is getting hammered by something, but I'm having a hard time figuring out what. It seems to come and go. Perhaps I have one or two websites that are just getting a lot of traffic, and maybe they just need their

Re: measuring mysql usage

2009-08-31 Thread APseudoUtopia
On Mon, Aug 31, 2009 at 12:20 PM, John Almbergjalmb...@identry.com wrote: Anyone know of a tool that can measure mysql usage per mysql user? My database is getting hammered by something, but I'm having a hard time figuring out what. It seems to come and go. Perhaps I have one or two websites

Re: measuring mysql usage

2009-08-31 Thread Peter Boosten
John Almberg wrote: Anyone know of a tool that can measure mysql usage per mysql user? My database is getting hammered by something, but I'm having a hard time figuring out what. It seems to come and go. Perhaps I have one or two websites that are just getting a lot of traffic, and maybe

Re: measuring mysql usage

2009-08-31 Thread John Almberg
Check out mTop. http://mtop.sourceforge.net/ Okay, got this running from ports. Cool tool, but after reading the man page and fooling around with it for a bit, I don't see how you can monitor usage by user with it. Am I missing something? -- John ___