=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   62
RUN DATE: 2010-05-21T23:45:37.415598
SERVER:   drizzled
VERSION:  build
REVISION: 1562
COMMENT:  1562: Brian Aker 2010-05-21 [merge] Merge Brian, includes changes to 
add Inn...

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.682   +1.09%      -0.13   within 
norms   11.557   11.980   11.811    0.163
blackhole  guid_bh              50      23.388   +0.97%      -0.23   within 
norms   23.124   23.871   23.617    0.306
blackhole  write-scale_bh       50       7.255   -6.10%       0.42   within 
norms    6.257    7.255    6.838    0.461
blackhole  write_bh             50      14.457   -6.13%       0.84   within 
norms   12.442   14.457   13.622    0.911
innodb     guid                 50     416.254   +5.89%     -26.06   within 
norms  394.289  506.426  442.316   45.951
innodb     guid-scale           50     173.800   +6.73%     -12.54   within 
norms  160.845  215.428  186.338   21.819
innodb     key                  50      21.069   -2.03%       0.42   within 
norms   19.903   21.185   20.649    0.584
innodb     key-scale            50      10.624   -1.41%       0.15   within 
norms   10.195   10.705   10.476    0.217
innodb     mixed                50     112.456   +4.20%      -4.93   within 
norms  101.229  139.208  117.390   12.762
innodb     mixed-commit         50      75.704   -1.13%       0.84   within 
norms   71.525   76.744   74.862    2.011
innodb     mixed-commit-scale   50      37.479   -0.82%       0.30   within 
norms   35.720   38.700   37.174    1.059
innodb     mixed-scale          50      55.666   +6.47%      -3.85   within 
norms   49.118   71.911   59.516    8.483
innodb     scan                 50      90.280   +0.50%      -0.45  outside 
norms   90.280   91.481   90.729    0.436
innodb     scan-scale           50      45.286   +0.78%      -0.35  outside 
norms   45.249   45.931   45.641    0.306
innodb     update               50     339.995   +7.69%     -28.31   within 
norms  321.975  439.613  368.307   47.188
innodb     update-commit        50      41.445   +1.84%      -0.78   within 
norms   41.441   44.150   42.222    1.038
innodb     update-commit-scale  50      20.384   +1.42%      -0.29   within 
norms   19.564   22.299   20.678    0.913
innodb     update-scale         50     171.009   +5.71%     -10.35   within 
norms  157.750  210.197  181.356   21.622
innodb     write                50     219.651   +3.58%      -8.16   within 
norms  194.311  265.856  227.811   25.439
innodb     write-commit         50     127.189   -4.59%       5.59  outside 
norms  118.897  127.189  121.603    3.052
innodb     write-commit-scale   50      62.272   -2.34%       1.42  outside 
norms   59.281   62.272   60.850    1.072
innodb     write-scale          50     109.941   +1.44%      -1.60   within 
norms   94.873  132.171  111.545   13.276

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.682   +0.53%      -0.06   within 
norms   11.324   12.007   11.744    0.216
blackhole  guid_bh              50      23.388   +0.20%      -0.05   within 
norms   22.492   24.089   23.434    0.439
blackhole  write-scale_bh       50       7.255  -12.45%       0.80  outside 
norms    6.248    7.255    6.452    0.324
blackhole  write_bh             50      14.457  -12.63%       1.62  outside 
norms   12.372   14.457   12.835    0.647
innodb     guid                 50     416.254  +17.05%     -85.53  outside 
norms  394.289  538.580  501.784   42.052
innodb     guid-scale           50     173.800  +19.81%     -42.93  outside 
norms  160.845  240.936  216.726   21.653
innodb     key                  50      21.069   -4.64%       0.93  outside 
norms   19.842   21.185   20.135    0.421
innodb     key-scale            50      10.624   -3.30%       0.34  outside 
norms   10.143   10.705   10.285    0.162
innodb     mixed                50     112.456  +20.73%     -29.41  outside 
norms  101.229  161.260  141.866   16.220
innodb     mixed-commit         50      75.704   -0.41%       0.31   within 
norms   71.525   78.200   75.395    1.669
innodb     mixed-commit-scale   50      37.479   +0.03%      -0.01   within 
norms   35.720   39.001   37.491    0.844
innodb     mixed-scale          50      55.666  +21.36%     -15.12  outside 
norms   49.118   80.412   70.785    8.470
innodb     scan                 50      90.280   +0.73%      -0.66  outside 
norms   90.280   91.613   90.944    0.338
innodb     scan-scale           50      45.286   +1.16%      -0.53  outside 
norms   45.249   46.149   45.818    0.227
innodb     update               50     339.995  +19.18%     -80.70  outside 
norms  321.975  452.749  420.700   38.921
innodb     update-commit        50      41.445   +4.01%      -1.73  outside 
norms   41.441   47.302   43.178    1.258
innodb     update-commit-scale  50      20.384   +4.56%      -0.97  outside 
norms   19.564   22.354   21.358    0.730
innodb     update-scale         50     171.009  +18.32%     -38.35  outside 
norms  157.750  227.938  209.356   19.822
innodb     write                50     219.651  +17.89%     -47.87  outside 
norms  194.311  294.272  267.520   27.133
innodb     write-commit         50     127.189   -2.01%       2.51   within 
norms  118.897  129.352  124.680    2.743
innodb     write-commit-scale   50      62.272   +0.15%      -0.09   within 
norms   59.281   64.257   62.363    1.372
innodb     write-scale          50     109.941  +17.21%     -22.85  outside 
norms   94.873  148.002  132.789   14.462

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.682    0.190     -0.020   within 
norms   11.271   12.063   11.704    0.221
blackhole  guid_bh              50      23.388   -0.190      0.040   within 
norms   22.492   24.089   23.343    0.439
blackhole  write-scale_bh       50       7.255  -13.720      0.880  outside 
norms    6.169    7.255    6.380    0.244
blackhole  write_bh             50      14.457  -14.130      1.790  outside 
norms   12.305   14.457   12.667    0.495
innodb     guid                 50     416.254   20.720   -108.800  outside 
norms  394.289  569.692  525.059   38.165
innodb     guid-scale           50     173.800   24.220    -55.560  outside 
norms  160.845  251.259  229.357   20.020
innodb     key                  50      21.069   -5.120      1.030  outside 
norms   19.827   21.185   20.043    0.316
innodb     key-scale            50      10.624   -3.630      0.370  outside 
norms   10.120   10.705   10.252    0.124
innodb     mixed                50     112.456   27.000    -41.600  outside 
norms  101.229  177.319  154.057   17.179
innodb     mixed-commit         50      75.704    1.880     -1.450   within 
norms   71.525   82.281   77.152    2.318
innodb     mixed-commit-scale   50      37.479    2.550     -0.980   within 
norms   35.720   40.995   38.460    1.251
innodb     mixed-scale          50      55.666   26.590    -20.160  outside 
norms   49.118   88.360   75.826    8.221
innodb     scan                 50      90.280    0.750     -0.680  outside 
norms   90.280   91.950   90.959    0.343
innodb     scan-scale           50      45.286    1.210     -0.560  outside 
norms   45.249   46.149   45.843    0.213
innodb     update               50     339.995   22.650    -99.580  outside 
norms  321.975  480.264  439.573   33.711
innodb     update-commit        50      41.445    4.830     -2.100  outside 
norms   41.441   47.302   43.548    1.030
innodb     update-commit-scale  50      20.384    6.140     -1.330  outside 
norms   19.564   22.859   21.718    0.712
innodb     update-scale         50     171.009   21.930    -48.030  outside 
norms  157.750  238.508  219.040   17.208
innodb     write                50     219.651   23.040    -65.750  outside 
norms  194.311  324.769  285.398   26.780
innodb     write-commit         50     127.189    0.830     -1.060   within 
norms  118.897  135.919  128.247    4.295
innodb     write-commit-scale   50      62.272    2.700     -1.730   within 
norms   59.281   68.306   63.998    2.113
innodb     write-scale          50     109.941   22.560    -32.020  outside 
norms   94.873  162.418  141.962   14.101
======================================================================================================================

FULL REVISION COMMENTARY:

  1556.1.3: Brian Aker 2010-05-21 First pass on a table function to see the ...
  1556.1.2: Brian Aker 2010-05-21 Creates a "cleanup" of Innodb's temp files...

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : drizzle-benchmark@lists.launchpad.net
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp

Reply via email to