mytop query counting not consistant on MySQL-OurDelta-server-5.0.77.d8-54.el4

[Tony]

I have just installed MySQL-OurDelta-server-5.0.77.d8-54.el4 (along with the matching client, devel and shared rpm's) on a CentOS 4.6 server and immediately noticed that the query counter shown when using the "mytop" utility does read the actual query count from the server properly. Each time I start mytop it starts counting from 0.

I have another similar server (CentOS release 4.7) running MySQL-OurDelta-server-5.0.67.d7-44.el4_7 and it does not exhibit this issue at all. Each time I start mytop, it shows the real query count since the MySQL server was last started as it should.

Both servers have the same my.cnf settings and exactly the same installation of mytop so I suspect something in the difference in MySQL-OurDelta-server versions to be responsible for this.

ps. I have verified that the full query count since last startup is shown properly via phpMyAdmin "Runtime Information" such as:
Query statistics: Since its startup, 118,003 queries have been sent to the server.
Total ø per hour ø per minute ø per second
118 k 121.27 k 2.02 k 33.69

[Arjen Lentz (arjen-lentz)]

Chances are you're using an old version mytop there that does not use
"SHOW GLOBAL STATUS" but "SHOW STATUS" which will end up doing the
session-based status.