| Ananda Kumar 2005-09-16, 7:23 am |
| ------ =_Part_2042_19284044
.1126869637444
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hi James,
You can do this=20
show engine innodb status\G ---this will show how many=20
insert/deletes/updates/reads happening per second and also how much of=20
Buffer is being used and how many queries are currently running and how man=
y=20
are in queue.
show processlist---This will give the list of SQL 's currently running on=
=20
the server
Also if you using Unix/Linux box, use the top command, this will give u an=
=20
general idea where exactly the resource are being heavly used.
regards
anandkl
On 9/16/05, James Black <jblack@ieee.org> wrote:=20
>=20
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>=20
> We have a production server that may be getting overworked, but I don't
> know.
>=20
> 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.
>=20
> 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?
>=20
> Thanx.
>=20
> - --
> "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
>=20
> iD8DBQFDKdNoikQgpVn8
xrARAnLrAJ9ZxPNHUskS
QVTxn/JRgm6RCkjHlgCdFGj6
> d9PUim7Yo713+GbcbZZ3
0Z0=3D
> =3DAQZl
> -----END PGP SIGNATURE-----
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql? unsub...mai
l.com
>=20
>
------ =_Part_2042_19284044
.1126869637444--
|