List:General Discussion« Previous MessageNext Message »
From:James Black Date:September 15 2005 8:02pm
Subject:re: determing how loaded my mysql server is
View as plain text  
-----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-----
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