mytop & mysql: queries per second

GID asked:

On a MySQL 5.5.62 server, with InnoDB tables, I run mytop, and in the "qps now" field it reports something like 40-70. The historical qps is about 60.

I then hit "m" to see the qps value as each second passes, and the only number that pops up is "1". Never less than 1, never more than 1. Steady 1.

What is going on? Is this utilily reliable?

Should I perhaps drop it and rely on the "show status" of the server, getting the "Queries" value twice in a row, subtracting and dividing by the time that elapsed? When I do that, I get about 40-70, as the main dashboard mytop page indicates.

My answer:


Where did you find mytop? That utility is ancient. The original mytop hasn’t had an update since 2007, and while someone else tried to keep developing it for a while, even he appears to have given up, and his web site is dead. Linux distros such as Debian are finally beginning to drop it.

It was superseded by innotop many years ago.


View the full question and any other answers on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.