search

ngonsol / mycheckpoint

Automatically exported from code.google.com/p/mycheckpoint
0 stars 1 forks source link

% reporting is off the charts #2

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
While generating a human report, I get to see values such as: 
DML:
    SELECT:  0.01/sec  4.4%
    INSERT:  3.59/sec  2873.3%
    UPDATE:  0.00/sec  0.0%
    DELETE:  0.01/sec  6.7%
    REPLACE: 0.00/sec  0.0%
    SET:     0.03/sec  20.0%
    COMMIT:  0.03/sec  26.7%
    slow:    0.00/sec  0.0% (slow time: 10sec)

And also: 

Selects:
    Full scan: 0.06/sec  1100.0%
    Full join: 0.00/sec  0.0%
    Range:     0.00/sec  0.0%
    Sort merge passes: 0.00/sec

It seems to me that doing 1100% full scans or 2873.3% of INSERTs would be 
amazing, but not 
really possible :)

Original issue reported on code.google.com by NWesterl...@gmail.com on 12 Nov 2009 at 9:22

GoogleCodeExporter commented 9 years ago 
Thanks.

This is due to:
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Ques
tions

Gotta keep a close eye on those changes.

Fixed in Rev. 43

Original comment by shlomi.n...@gmail.com on 12 Nov 2009 at 9:25

GoogleCodeExporter commented 9 years ago 
More problematic than seems at first:
See my post [http://code.openark.org/blog/mysql/questions-or-queries questions 
or
queries?]
I'll need to support pre-5.0.76 and post 5.0.76 as well (same for 5.1.31). Work 
has
begun.

Original comment by shlomi.n...@gmail.com on 13 Nov 2009 at 11:40

GoogleCodeExporter commented 9 years ago 
Sounds good, thank you.

Original comment by NWesterl...@gmail.com on 13 Nov 2009 at 1:18

GoogleCodeExporter commented 9 years ago 
Fixed in revision 54 and above

Original comment by shlomi.n...@gmail.com on 16 Dec 2009 at 7:20