← Back to team overview

ourdelta-developers team mailing list archive

[Bug 365818] [NEW] mytop query counting not consistant on MySQL-OurDelta-server-5.0.77.d8-54.el4

 

Public bug reported:

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

** Affects: ourdelta
     Importance: Undecided
         Status: New


** Tags: mytop queries

-- 
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



Follow ups

References