=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   65
RUN DATE: 2010-05-22T18:36:27.131033
SERVER:   drizzled
VERSION:  build
REVISION: 1562
COMMENT:  1562: Brian Aker 2010-05-22 [merge] Merge for tmp files, plus fixed 
tests fo...

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.718   +0.61%      -0.07   within 
norms   11.682   11.932   11.789    0.115
blackhole  guid_bh              50      23.431   +0.69%      -0.16   within 
norms   23.386   23.902   23.593    0.235
blackhole  write-scale_bh       50       7.267   -0.13%       0.01  outside 
norms    7.243    7.269    7.257    0.010
blackhole  write_bh             50      14.446   -0.08%       0.01   within 
norms   14.325   14.476   14.435    0.056
innodb     guid                 50     414.550   -0.70%       2.89   within 
norms  406.003  416.254  411.658    3.828
innodb     guid-scale           50     177.101   -2.28%       3.95  outside 
norms  169.339  177.101  173.147    2.503
innodb     key                  50      21.014   +0.43%      -0.09  outside 
norms   21.014   21.185   21.106    0.062
innodb     key-scale            50      10.628   +0.56%      -0.06   within 
norms   10.624   10.790   10.688    0.061
innodb     mixed                50     113.395   -0.80%       0.90   within 
norms  111.176  113.558  112.498    0.898
innodb     mixed-commit         50      76.973   -1.28%       0.97  outside 
norms   74.608   76.973   76.000    0.831
innodb     mixed-commit-scale   50      38.610   -3.01%       1.13  outside 
norms   36.710   38.610   37.480    0.670
innodb     mixed-scale          50      56.584   -2.21%       1.22  outside 
norms   54.057   56.584   55.363    0.852
innodb     scan                 50      90.299   +0.26%      -0.23   within 
norms   90.275   91.481   90.533    0.475
innodb     scan-scale           50      45.327   +0.22%      -0.10   within 
norms   45.278   45.931   45.428    0.252
innodb     update               50     337.978   -0.96%       3.22   within 
norms  330.637  339.995  334.753    3.745
innodb     update-commit        50      41.264   +0.45%      -0.19  outside 
norms   41.264   41.554   41.451    0.105
innodb     update-commit-scale  50      20.182   +0.01%       0.00   within 
norms   20.028   20.384   20.183    0.131
innodb     update-scale         50     165.812   +0.47%      -0.79   within 
norms  163.559  171.009  166.600    2.435
innodb     write                50     217.603   +0.36%      -0.78   within 
norms  212.402  222.681  218.381    3.402
innodb     write-commit         50     124.926   -0.71%       0.89   within 
norms  120.587  127.189  124.041    2.135
innodb     write-commit-scale   50      62.549   -0.87%       0.54   within 
norms   61.178   62.811   62.008    0.679
innodb     write-scale          50     110.032   -2.68%       2.88   within 
norms  101.084  110.032  107.156    3.255

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.718   +0.45%      -0.05   within 
norms   11.450   12.007   11.771    0.188
blackhole  guid_bh              50      23.431   +0.33%      -0.08   within 
norms   22.890   24.089   23.508    0.374
blackhole  write-scale_bh       50       7.267  -10.33%       0.68  outside 
norms    6.248    7.269    6.587    0.427
blackhole  write_bh             50      14.446  -10.18%       1.33  outside 
norms   12.372   14.476   13.111    0.857
innodb     guid                 50     414.550  +14.29%     -69.11  outside 
norms  394.289  532.052  483.662   50.028
innodb     guid-scale           50     177.101  +14.72%     -30.57  outside 
norms  160.845  240.936  207.673   25.077
innodb     key                  50      21.014   -3.55%       0.72  outside 
norms   19.842   21.185   20.294    0.536
innodb     key-scale            50      10.628   -2.66%       0.28  outside 
norms   10.143   10.790   10.353    0.219
innodb     mixed                50     113.395  +16.18%     -21.89  outside 
norms  101.229  160.033  135.288   17.699
innodb     mixed-commit         50      76.973   -2.29%       1.72  outside 
norms   71.525   78.200   75.248    1.574
innodb     mixed-commit-scale   50      38.610   -3.44%       1.28  outside 
norms   35.720   38.700   37.327    0.788
innodb     mixed-scale          50      56.584  +16.16%     -10.91  outside 
norms   49.118   80.412   67.494    9.357
innodb     scan                 50      90.299   +0.60%      -0.55  outside 
norms   90.275   91.613   90.847    0.406
innodb     scan-scale           50      45.327   +0.88%      -0.40  outside 
norms   45.249   46.149   45.731    0.286
innodb     update               50     337.978  +16.27%     -65.66  outside 
norms  321.975  447.040  403.640   47.206
innodb     update-commit        50      41.264   +3.81%      -1.64  outside 
norms   41.264   47.302   42.900    1.382
innodb     update-commit-scale  50      20.182   +4.47%      -0.94  outside 
norms   19.564   22.354   21.126    0.830
innodb     update-scale         50     165.812  +17.42%     -34.98  outside 
norms  157.750  227.938  200.788   23.880
innodb     write                50     217.603  +15.32%     -39.36  outside 
norms  194.311  290.884  256.960   29.754
innodb     write-commit         50     124.926   -0.57%       0.71   within 
norms  118.897  129.352  124.221    2.527
innodb     write-commit-scale   50      62.549   -0.74%       0.46   within 
norms   59.281   64.052   62.089    1.209
innodb     write-scale          50     110.032  +13.68%     -17.44  outside 
norms   94.873  148.002  127.472   15.914

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                Conc     Time  % Diff from Avg Diff       Norm?  
     Min      Max      Avg      STD     
======================================================================================================================
blackhole  guid-scale_bh        50      11.718   -0.080      0.010   within 
norms   11.271   12.063   11.709    0.215
blackhole  guid_bh              50      23.431   -0.310      0.070   within 
norms   22.492   24.089   23.359    0.431
blackhole  write-scale_bh       50       7.267  -12.820      0.830  outside 
norms    6.169    7.269    6.441    0.325
blackhole  write_bh             50      14.446  -12.930      1.650  outside 
norms   12.305   14.476   12.793    0.661
innodb     guid                 50     414.550   19.840   -102.620  outside 
norms  394.289  569.692  517.172   46.742
innodb     guid-scale           50     177.101   21.440    -48.340  outside 
norms  160.845  251.259  225.440   24.043
innodb     key                  50      21.014   -4.460      0.900  outside 
norms   19.827   21.185   20.116    0.406
innodb     key-scale            50      10.628   -3.350      0.340  outside 
norms   10.120   10.790   10.283    0.167
innodb     mixed                50     113.395   24.990    -37.780  outside 
norms  101.229  177.319  151.173   19.636
innodb     mixed-commit         50      76.973    0.120     -0.090   within 
norms   71.525   82.281   77.063    2.274
innodb     mixed-commit-scale   50      38.610   -0.580      0.220   within 
norms   35.720   40.995   38.386    1.256
innodb     mixed-scale          50      56.584   23.970    -17.840  outside 
norms   49.118   88.360   74.422    9.444
innodb     scan                 50      90.299    0.680     -0.610  outside 
norms   90.275   91.950   90.913    0.371
innodb     scan-scale           50      45.327    1.040     -0.480  outside 
norms   45.249   46.149   45.806    0.247
innodb     update               50     337.978   21.810    -94.260  outside 
norms  321.975  480.264  432.234   42.142
innodb     update-commit        50      41.264    4.930     -2.140  outside 
norms   41.264   47.302   43.402    1.128
innodb     update-commit-scale  50      20.182    6.580     -1.420  outside 
norms   19.564   22.859   21.604    0.802
innodb     update-scale         50     165.812   23.000    -49.540  outside 
norms  157.750  238.508  215.349   21.378
innodb     write                50     217.603   22.510    -63.230  outside 
norms  194.311  324.769  280.832   30.747
innodb     write-commit         50     124.926    2.370     -3.040   within 
norms  118.897  135.919  127.961    4.275
innodb     write-commit-scale   50      62.549    2.070     -1.320   within 
norms   59.281   68.306   63.872    2.097
innodb     write-scale          50     110.032   21.190    -29.580  outside 
norms   94.873  162.418  139.610   16.088
======================================================================================================================

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