mytop query counting not consistant on MySQL-OurDelta-server-5.0.77.d8-54.el4
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OurDelta |
New
|
Undecided
|
Unassigned |
Bug Description
I have just installed MySQL-OurDelta-
I have another similar server (CentOS release 4.7) running MySQL-OurDelta-
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-
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
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.