Bug #9454 Wrong value for Queries per Second in Command line client
Submitted: 29 Mar 2005 13:51 Modified: 13 Apr 2005 12:58
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.4 OS:Linux (Linux)
Assigned to: Magnus Blåudd CPU Architecture:Any

[29 Mar 2005 13:51] Georg Richter 
Description:
after \s  (status) Queries per second contains strange values:

How to repeat:
5.0.4-beta-debug-log
root@test>\s
...
Uptime:                 5 min 30 sec

Threads: 7  Questions: 579  Slow queries: 0  Opens: 0  Flush tables: 0  Open tables: 1  Queries per second avg: 848393.500  Memory in use: 17345K  Max memory used: 17364K
--------------

root@test>\s
..
Uptime:                 9 min 35 sec

Threads: 7  Questions: 981  Slow queries: 0  Opens: 0  Flush tables: 0  Open tables: 1  Queries per second avg: -102238188182376359916729391473670763386846544324554738804860903278609631700178015775851591995713748734050304.000  Memory in use: 17345K  Max memory used: 17668K
[29 Mar 2005 14:08] MySQL Verification Team 
Threads: 1  Questions: 35  Slow queries: 0  Opens: 0  Flush tables: 17  Open tables: 1  Queries per second avg: -36922997682132116138647576230494208.000  Memory in use: 8576K  Max memory used: 8699K
--------------
[29 Mar 2005 14:11] MySQL Verification Team 
Also I noticed when trying \s several times crash the server.
[13 Apr 2005 10:59] Magnus Blåudd 
Can not reproduce on my machine using FC3.
[13 Apr 2005 12:58] Magnus Blåudd 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html