measuring mysql usage
Peter Boosten
peter at boosten.org
Mon Aug 31 16:29:17 UTC 2009
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
More information about the freebsd-questions
mailing list