Date: Mon, 31 Aug 2009 18:28:59 +0200 From: Peter Boosten <peter@boosten.org> To: John Almberg <jalmberg@identry.com> Cc: freebsd-questions@freebsd.org Subject: Re: measuring mysql usage Message-ID: <4A9BFA4B.1090406@boosten.org> In-Reply-To: <05DAF099-1824-494E-BF33-9D14A765773A@identry.com> References: <05DAF099-1824-494E-BF33-9D14A765773A@identry.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4A9BFA4B.1090406>