=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   54
RUN DATE: 2010-05-20T02:09:47.452086
SERVER:   drizzled
VERSION:  build
REVISION: 1552
COMMENT:  1552: Brian Aker 2010-05-19 It is somewhat amazing that EXPLAIN works 
at all...

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.991   -2.82%       0.33  outside 
norms   11.450   11.991   11.662    0.206
blackhole  guid_bh              50      24.089   -3.36%       0.78  outside 
norms   22.890   24.089   23.305    0.445
blackhole  write-scale_bh       50       6.276   +0.24%      -0.02   within 
norms    6.248    6.341    6.291    0.030
blackhole  write_bh             50      12.372   +1.19%      -0.15  outside 
norms   12.372   12.592   12.521    0.083
innodb     guid                 50     515.626   +0.22%      -1.16   within 
norms  512.151  524.449  516.784    4.143
innodb     guid-scale           50     222.822   -0.42%       0.94   within 
norms  219.165  224.438  221.885    1.738
innodb     key                  50      19.952   -0.18%       0.04   within 
norms   19.842   20.043   19.917    0.075
innodb     key-scale            50      10.209   -0.03%       0.00   within 
norms   10.143   10.279   10.206    0.048
innodb     mixed                50     148.643   -0.20%       0.30   within 
norms  144.008  150.080  148.347    2.219
innodb     mixed-commit         50      75.118   -0.06%       0.04   within 
norms   74.112   75.524   75.074    0.500
innodb     mixed-commit-scale   50      38.246   -1.48%       0.56  outside 
norms   37.091   38.246   37.689    0.447
innodb     mixed-scale          50      67.128   +8.54%      -6.27  outside 
norms   67.128   79.827   73.393    4.068
innodb     scan                 50      91.087   -0.19%       0.17   within 
norms   90.510   91.374   90.914    0.295
innodb     scan-scale           50      45.634   +0.36%      -0.17  outside 
norms   45.634   45.943   45.799    0.115
innodb     update               50     431.162   +0.25%      -1.09   within 
norms  429.981  435.244  432.249    1.753
innodb     update-commit        50      43.249   +0.40%      -0.17   within 
norms   42.241   44.098   43.422    0.658
innodb     update-commit-scale  50      21.788   -0.06%       0.01   within 
norms   20.941   22.354   21.775    0.503
innodb     update-scale         50     215.255   +0.32%      -0.69   within 
norms  214.395  218.691  215.947    1.556
innodb     write                50     271.101   +2.19%      -6.06  outside 
norms  271.101  282.967  277.165    4.337
innodb     write-commit         50     123.841   +0.82%      -1.02   within 
norms  123.554  126.167  124.859    1.090
innodb     write-commit-scale   50      61.246   +1.95%      -1.22  outside 
norms   61.246   63.821   62.462    0.902
innodb     write-scale          50     135.939   +1.36%      -1.87   within 
norms  132.963  141.823  137.807    3.272

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.991   -2.60%       0.30  outside 
norms   11.271   12.063   11.687    0.245
blackhole  guid_bh              50      24.089   -3.35%       0.78  outside 
norms   22.492   24.089   23.308    0.491
blackhole  write-scale_bh       50       6.276   +0.47%      -0.03   within 
norms    6.169    6.422    6.305    0.066
blackhole  write_bh             50      12.372   +1.23%      -0.15  outside 
norms   12.305   12.723   12.527    0.126
innodb     guid                 50     515.626   +3.57%     -19.10  outside 
norms  512.151  559.162  534.721   14.956
innodb     guid-scale           50     222.822   +4.99%     -11.70  outside 
norms  219.165  245.749  234.523    8.905
innodb     key                  50      19.952   +0.00%       0.00   within 
norms   19.842   20.079   19.953    0.072
innodb     key-scale            50      10.209   +0.00%       0.00   within 
norms   10.120   10.310   10.209    0.049
innodb     mixed                50     148.643   +5.78%      -9.12  outside 
norms  144.008  177.319  157.767    9.062
innodb     mixed-commit         50      75.118   +2.87%      -2.22  outside 
norms   74.112   80.324   77.341    1.899
innodb     mixed-commit-scale   50      38.246   +0.63%      -0.24   within 
norms   36.824   40.170   38.490    1.029
innodb     mixed-scale          50      67.128  +13.54%     -10.52  outside 
norms   67.128   85.583   77.644    4.841
innodb     scan                 50      91.087   -0.13%       0.12   within 
norms   90.510   91.613   90.967    0.235
innodb     scan-scale           50      45.634   +0.47%      -0.22  outside 
norms   45.464   46.149   45.852    0.174
innodb     update               50     431.162   +3.74%     -16.73  outside 
norms  429.981  469.003  447.892   11.713
innodb     update-commit        50      43.249   +1.52%      -0.67   within 
norms   42.241   47.302   43.917    1.041
innodb     update-commit-scale  50      21.788   +0.13%      -0.03   within 
norms   20.876   22.749   21.816    0.587
innodb     update-scale         50     215.255   +3.86%      -8.65  outside 
norms  214.395  232.762  223.903    6.167
innodb     write                50     271.101   +7.07%     -20.62  outside 
norms  271.101  315.883  291.720   12.226
innodb     write-commit         50     123.841   +3.58%      -4.60  outside 
norms  123.554  135.091  128.437    3.482
innodb     write-commit-scale   50      61.246   +4.66%      -3.00  outside 
norms   61.246   67.873   64.241    1.722
innodb     write-scale          50     135.939   +6.71%      -9.78  outside 
norms  132.963  160.193  145.715    6.782

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.991   -2.550      0.300  outside 
norms   11.271   12.063   11.692    0.228
blackhole  guid_bh              50      24.089   -3.340      0.780  outside 
norms   22.492   24.089   23.311    0.450
blackhole  write-scale_bh       50       6.276    0.610     -0.040   within 
norms    6.169    6.422    6.315    0.059
blackhole  write_bh             50      12.372    1.270     -0.160  outside 
norms   12.305   12.723   12.531    0.118
innodb     guid                 50     515.626    4.380    -23.610  outside 
norms  512.151  569.692  539.236   14.198
innodb     guid-scale           50     222.822    6.000    -14.230  outside 
norms  219.165  251.259  237.057    8.202
innodb     key                  50      19.952    0.010      0.000   within 
norms   19.827   20.159   19.954    0.076
innodb     key-scale            50      10.209    0.070     -0.010   within 
norms   10.120   10.310   10.216    0.049
innodb     mixed                50     148.643    7.530    -12.100  outside 
norms  144.008  177.319  160.740    8.869
innodb     mixed-commit         50      75.118    3.510     -2.730  outside 
norms   74.112   82.281   77.851    1.879
innodb     mixed-commit-scale   50      38.246    1.480     -0.570   within 
norms   36.824   40.995   38.820    1.052
innodb     mixed-scale          50      67.128   14.740    -11.610  outside 
norms   67.128   88.360   78.737    4.653
innodb     scan                 50      91.087   -0.120      0.110   within 
norms   90.470   91.950   90.978    0.324
innodb     scan-scale           50      45.634    0.530     -0.240  outside 
norms   45.464   46.149   45.877    0.176
innodb     update               50     431.162    4.510    -20.370  outside 
norms  429.981  480.264  451.535   11.342
innodb     update-commit        50      43.249    1.300     -0.570   within 
norms   42.241   47.302   43.820    0.874
innodb     update-commit-scale  50      21.788    0.460     -0.100   within 
norms   20.876   22.859   21.889    0.543
innodb     update-scale         50     215.255    4.500    -10.150  outside 
norms  214.395  238.508  225.402    5.675
innodb     write                50     271.101    8.370    -24.750  outside 
norms  271.101  324.769  295.849   12.057
innodb     write-commit         50     123.841    4.490     -5.820  outside 
norms  123.554  135.919  129.659    3.335
innodb     write-commit-scale   50      61.246    5.350     -3.460  outside 
norms   61.246   68.306   64.705    1.681
innodb     write-scale          50     135.939    7.780    -11.470  outside 
norms  132.963  162.418  147.409    6.449
======================================================================================================================

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp

Reply via email to