Home > Archive > MySQL ODBC Connector > September 2005 > re: determing how loaded my mysql server is









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author re: determing how loaded my mysql server is
James Black

2005-09-15, 8:24 pm

-----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-----

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com