Re: measuring mysql usage
>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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
Re: measuring mysql usage
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 they just > need their own machines. I'm not sure, which is why I'm looking for ways > to start monitoring these sites and their resource usage - particularly > db usage - more closely. > > Any thoughts or tips, much appreciated. > First thing I can think of is 'mysqladmin processlist', or you could log queries for a while. Peter -- http://www.boosten.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
Re: measuring mysql usage
On Mon, Aug 31, 2009 at 12:20 PM, 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 they just need > their own machines. I'm not sure, which is why I'm looking for ways to start > monitoring these sites and their resource usage - particularly db usage - > more closely. > > Any thoughts or tips, much appreciated. > > Thanks: John > Check out mTop. http://mtop.sourceforge.net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
measuring mysql usage
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 own machines. I'm not sure, which is why I'm looking for ways to start monitoring these sites and their resource usage - particularly db usage - more closely. Any thoughts or tips, much appreciated. Thanks: John ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"