List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:September 16 2005 10:26am
Subject:Re: re: determing how loaded my mysql server is
View as plain text  
Hello.

Tools like mytop or mysqladmin (with -r option) don't produce
a high load on the server. You might be interested in --sleep option
for mysqladmin and --delay for mytop.


James Black <jblack@stripped> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> We have a production server that may be getting overworked, but I don't
> know.
> 
> When I look at 'mysqladmin status' it consistently shows 107.#
> queries/sec on average. That seems a bit high, it should be less, I
> imagine, since the Id number in the processlist seems to increment by
> perhaps 5-10/second.
> 
> Is there a way to monitor the server, without putting too much of a load
> on the mysql server, to see what is going on?
> 
> Thanx.
> 
> - --
> "Love is mutual self-giving that ends in self-recovery." Fulton Sheen
> James Black    james@stripped
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
> 
> iD8DBQFDKdNoikQgpVn8xrARAnLrAJ9ZxPNHUskSQVTxn/JRgm6RCkjHlgCdFGj6
> d9PUim7Yo713+GbcbZZ30Z0=
> =AQZl
> -----END PGP SIGNATURE-----
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
re: determing how loaded my mysql server isJames Black15 Sep
  • Re: determing how loaded my mysql server isAnanda Kumar16 Sep
  • Re: re: determing how loaded my mysql server isGleb Paharenko16 Sep