Hi James, You can do this show engine innodb status\G ---this will show how many insert/deletes/updates/reads happening per second and also how much of Buffer is being used and how many queries are currently running and how many are in queue. show processlist---This will give the list of SQL 's currently running on the server Also if you using Unix/Linux box, use the top command, this will give u an general idea where exactly the resource are being heavly used. regards anandkl
On 9/16/05, James Black <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > -----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----- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
