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.
-- mytop query counting not consistant on MySQL-OurDelta-server-5.0.77.d8-54.el4 https://bugs.launchpad.net/bugs/365818 You received this bug notification because you are a member of OurDelta- developers, which is the registrant for OurDelta. Status in OurDelta - Builds for MySQL: New Bug description: 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 _______________________________________________ Mailing list: https://launchpad.net/~ourdelta-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~ourdelta-developers More help : https://help.launchpad.net/ListHelp
