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
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 [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We have a production
-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