=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   63
RUN DATE: 2010-05-22T01:44:08.082892
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.689   +0.54%      -0.06   within 
norms   11.557   11.932   11.753    0.143
blackhole  guid_bh              50      23.386   +0.57%      -0.13   within 
norms   23.124   23.858   23.520    0.287
blackhole  write-scale_bh       50       7.269   -3.36%       0.24   within 
norms    6.257    7.269    7.033    0.391
blackhole  write_bh             50      14.476   -3.39%       0.47   within 
norms   12.442   14.476   14.002    0.783
innodb     guid                 50     412.993   +2.51%     -10.64   within 
norms  394.289  488.606  423.629   33.350
innodb     guid-scale           50     169.339   +4.39%      -7.78   within 
norms  160.845  209.343  177.120   16.723
innodb     key                  50      21.164   -1.26%       0.26   within 
norms   19.970   21.185   20.902    0.467
innodb     key-scale            50      10.693   -1.11%       0.12   within 
norms   10.232   10.705   10.576    0.175
innodb     mixed                50     113.558   -1.16%       1.30   within 
norms  101.229  122.152  112.260    6.654
innodb     mixed-commit         50      74.608   +0.59%      -0.45   within 
norms   71.525   76.744   75.054    1.929
innodb     mixed-commit-scale   50      36.908   +1.05%      -0.39   within 
norms   35.720   38.700   37.300    0.980
innodb     mixed-scale          50      55.651   +1.09%      -0.61   within 
norms   49.118   66.827   56.264    5.801
innodb     scan                 50      90.275   +0.45%      -0.41   within 
norms   90.275   91.481   90.687    0.467
innodb     scan-scale           50      45.278   +0.54%      -0.24   within 
norms   45.249   45.931   45.522    0.309
innodb     update               50     334.285   +3.73%     -12.96   within 
norms  321.975  409.317  347.242   31.584
innodb     update-commit        50      41.549   +0.37%      -0.15   within 
norms   41.441   42.478   41.702    0.393
innodb     update-commit-scale  50      20.059   +0.84%      -0.17   within 
norms   19.564   20.879   20.230    0.429
innodb     update-scale         50     166.025   +3.77%      -6.50   within 
norms  157.750  204.264  172.521   16.435
innodb     write                50     222.681   -1.60%       3.51   within 
norms  194.311  246.835  219.176   16.980
innodb     write-commit         50     123.699   -1.49%       1.82   within 
norms  118.897  127.189  121.884    3.165
innodb     write-commit-scale   50      61.228   -0.72%       0.43   within 
norms   59.281   62.272   60.793    1.042
innodb     write-scale          50     107.349   -0.72%       0.77   within 
norms   94.873  119.657  106.581    8.368

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.689   +0.37%      -0.04   within 
norms   11.324   12.007   11.732    0.212
blackhole  guid_bh              50      23.386   +0.13%      -0.03   within 
norms   22.492   24.089   23.416    0.433
blackhole  write-scale_bh       50       7.269  -11.93%       0.78  outside 
norms    6.248    7.269    6.494    0.369
blackhole  write_bh             50      14.476  -12.00%       1.55  outside 
norms   12.372   14.476   12.925    0.738
innodb     guid                 50     412.993  +16.65%     -82.51  outside 
norms  394.289  532.052  495.505   45.337
innodb     guid-scale           50     169.339  +20.63%     -44.00  outside 
norms  160.845  240.936  213.341   23.432
innodb     key                  50      21.164   -4.83%       0.97  outside 
norms   19.842   21.185   20.189    0.476
innodb     key-scale            50      10.693   -3.74%       0.39  outside 
norms   10.143   10.705   10.307    0.184
innodb     mixed                50     113.558  +18.75%     -26.20  outside 
norms  101.229  161.260  139.763   17.008
innodb     mixed-commit         50      74.608   +0.84%      -0.64   within 
norms   71.525   78.200   75.243    1.594
innodb     mixed-commit-scale   50      36.908   +1.28%      -0.48   within 
norms   35.720   38.700   37.386    0.777
innodb     mixed-scale          50      55.651  +20.25%     -14.14  outside 
norms   49.118   80.412   69.786    9.001
innodb     scan                 50      90.275   +0.71%      -0.64  outside 
norms   90.275   91.613   90.919    0.367
innodb     scan-scale           50      45.278   +1.11%      -0.51  outside 
norms   45.249   46.149   45.786    0.254
innodb     update               50     334.285  +19.41%     -80.49  outside 
norms  321.975  447.040  414.776   42.447
innodb     update-commit        50      41.549   +3.61%      -1.55  outside 
norms   41.441   47.302   43.103    1.307
innodb     update-commit-scale  50      20.059   +5.68%      -1.21  outside 
norms   19.564   22.354   21.268    0.772
innodb     update-scale         50     166.025  +19.56%     -40.36  outside 
norms  157.750  227.938  206.389   21.568
innodb     write                50     222.681  +15.63%     -41.26  outside 
norms  194.311  290.884  263.941   28.074
innodb     write-commit         50     123.699   +0.62%      -0.77   within 
norms  118.897  129.352  124.470    2.647
innodb     write-commit-scale   50      61.228   +1.58%      -0.98   within 
norms   59.281   64.130   62.212    1.321
innodb     write-scale          50     107.349  +17.97%     -23.52  outside 
norms   94.873  148.002  130.867   15.146

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.689    0.120     -0.010   within 
norms   11.271   12.063   11.703    0.218
blackhole  guid_bh              50      23.386   -0.180      0.040   within 
norms   22.492   24.089   23.344    0.433
blackhole  write-scale_bh       50       7.269  -13.560      0.870  outside 
norms    6.169    7.269    6.401    0.277
blackhole  write_bh             50      14.476  -13.880      1.760  outside 
norms   12.305   14.476   12.711    0.563
innodb     guid                 50     412.993   20.930   -109.330  outside 
norms  394.289  569.692  522.326   41.472
innodb     guid-scale           50     169.339   25.690    -58.550  outside 
norms  160.845  251.259  227.893   21.834
innodb     key                  50      21.164   -5.450      1.090  outside 
norms   19.827   21.185   20.071    0.357
innodb     key-scale            50      10.693   -4.200      0.430  outside 
norms   10.120   10.705   10.262    0.140
innodb     mixed                50     113.558   25.810    -39.510  outside 
norms  101.229  177.319  153.069   18.082
innodb     mixed-commit         50      74.608    3.220     -2.480  outside 
norms   71.525   82.281   77.090    2.323
innodb     mixed-commit-scale   50      36.908    3.940     -1.510  outside 
norms   35.720   40.995   38.422    1.259
innodb     mixed-scale          50      55.651   26.130    -19.680  outside 
norms   49.118   88.360   75.334    8.696
innodb     scan                 50      90.275    0.730     -0.670  outside 
norms   90.275   91.950   90.942    0.355
innodb     scan-scale           50      45.278    1.200     -0.550  outside 
norms   45.249   46.149   45.829    0.228
innodb     update               50     334.285   23.510   -102.720  outside 
norms  321.975  480.264  437.005   37.047
innodb     update-commit        50      41.549    4.480     -1.950  outside 
norms   41.441   47.302   43.499    1.063
innodb     update-commit-scale  50      20.059    7.470     -1.620  outside 
norms   19.564   22.859   21.678    0.748
innodb     update-scale         50     166.025   23.750    -51.720  outside 
norms  157.750  238.508  217.747   18.861
innodb     write                50     222.681   21.550    -61.190  outside 
norms  194.311  324.769  283.868   28.165
innodb     write-commit         50     123.699    3.460     -4.440  outside 
norms  118.897  135.919  128.136    4.300
innodb     write-commit-scale   50      61.228    4.230     -2.700  outside 
norms   59.281   68.306   63.930    2.130
innodb     write-scale          50     107.349   23.930    -33.770  outside 
norms   94.873  162.418  141.117   14.916
======================================================================================================================

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