| Gleb Paharenko 2005-09-16, 8:23 pm |
| 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@ieee.org> 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@usf.edu
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
> iD8DBQFDKdNoikQgpVn8
xrARAnLrAJ9ZxPNHUskS
QVTxn/JRgm6RCkjHlgCdFGj6
> d9PUim7Yo713+GbcbZZ3
0Z0=
> =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@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|