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

Bug #365818 reported by Tony
2
Affects Status Importance Assigned to Milestone
OurDelta
New
Undecided
Unassigned

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

Tags: mytop queries
Revision history for this message
Arjen Lentz (arjen-lentz) wrote : Re: [Ourdelta-developers] [Bug 365818] [NEW] mytop query counting not consistant on MySQL-OurDelta-server-5.0.77.d8-54.el4

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.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.