=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   1420
RUN DATE: 2011-02-22T23:26:19.326414
SERVER:   drizzled
VERSION:  staging
REVISION: 2194
COMMENT:  2194: Lee Bieber 2011-02-23 [merge] Merge Andrew - 723389: ORDER BY 
on sys_r...

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     244.731   +0.77%      -1.89  
242.785  255.707  246.621    4.650
innodb     guid-scale                 50     113.559   -1.08%       1.21  
109.904  116.081  112.351    2.338
innodb     key                        50      22.218   -0.63%       0.14   
21.944   22.218   22.078    0.087
innodb     key-scale                  50      11.172   -0.27%       0.03   
11.093   11.176   11.142    0.031
innodb     mixed                      50     100.702   -0.67%       0.67   
96.570  102.524  100.031    2.018
innodb     mixed-commit               50      62.179   +0.47%      -0.30   
61.787   63.871   62.474    0.753
innodb     mixed-commit-scale         50      29.092   +2.18%      -0.65   
29.092   30.529   29.740    0.536
innodb     mixed-scale                50      47.715   -0.25%       0.12   
45.977   49.142   47.595    1.005
innodb     scan                       50      96.028   +0.29%      -0.28   
96.028   96.644   96.303    0.264
innodb     scan-scale                 50      48.405   -0.02%       0.01   
48.226   48.491   48.396    0.092
innodb     update                     50     242.747   +1.65%      -4.08  
241.617  255.843  246.824    5.223
innodb     update-scale               50     122.406   -0.32%       0.39  
119.204  125.957  122.016    2.245
innodb     write                      50     201.878   +1.08%      -2.21  
201.878  208.009  204.086    2.106
innodb     write-commit               50      96.790   +0.75%      -0.73   
96.704   99.780   97.524    1.144
innodb     write-commit-scale         50      47.774   +0.71%      -0.34   
47.478   48.962   48.115    0.568
innodb     write-scale                50     100.942   -0.89%       0.89   
97.264  104.282  100.056    2.449

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     244.731   -1.51%       3.64  
212.458  265.219  241.087   14.447
innodb     guid-scale                 50     113.559   -4.18%       4.56   
96.389  123.934  108.998    7.102
innodb     key                        50      22.218   -0.42%       0.09   
21.944   22.431   22.126    0.114
innodb     key-scale                  50      11.172   -0.21%       0.02   
11.071   11.251   11.149    0.050
innodb     mixed                      50     100.702   -4.28%       4.13   
80.513  108.651   96.570    7.444
innodb     mixed-commit               50      62.179   -1.30%       0.80   
56.727   66.205   61.383    2.697
innodb     mixed-commit-scale         50      29.092   +0.01%       0.00   
26.111   32.035   29.094    1.625
innodb     mixed-scale                50      47.715   -3.21%       1.48   
38.433   52.841   46.232    3.550
innodb     scan                       50      96.028   +0.13%      -0.12   
95.519   98.822   96.151    0.712
innodb     scan-scale                 50      48.405   -0.21%       0.10   
48.030   48.770   48.304    0.197
innodb     update                     50     242.747   -0.99%       2.38  
201.997  269.758  240.362   16.589
innodb     update-scale               50     122.406   -2.99%       3.56  
104.447  130.188  118.850    7.965
innodb     write                      50     201.878   -0.60%       1.21  
180.223  226.989  200.669   12.384
innodb     write-commit               50      96.790   -1.05%       1.00   
87.681  102.762   95.786    4.063
innodb     write-commit-scale         50      47.774   -0.62%       0.29   
43.064   50.889   47.481    2.110
innodb     write-scale                50     100.942   -4.80%       4.62   
77.112  112.430   96.323    8.371

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     244.731   +1.50%      -3.72  
202.817  298.262  248.452   16.816
innodb     guid-scale                 50     113.559  +17.77%     -24.54   
87.949  190.089  138.096   23.199
innodb     key                        50      22.218   -1.64%       0.36   
19.827   40.122   21.859    1.055
innodb     key-scale                  50      11.172   -1.19%       0.13   
10.120   19.828   11.041    0.498
innodb     mixed                      50     100.702  +12.81%     -14.80   
79.344  209.204  115.500   18.358
innodb     mixed-commit               50      62.179  +10.95%      -7.65   
55.750   99.041   69.826    6.353
innodb     mixed-commit-scale         50      29.092  +15.20%      -5.21   
26.111   50.431   34.305    3.693
innodb     mixed-scale                50      47.715  +14.06%      -7.81   
37.251  107.498   55.523    8.450
innodb     scan                       50      96.028   -1.51%       1.43   
90.275  116.260   94.602    2.017
innodb     scan-scale                 50      48.405   -1.83%       0.87   
45.180   58.600   47.534    1.018
innodb     update                     50     242.747   +0.28%      -0.68  
197.009  331.117  243.427   19.547
innodb     update-scale               50     122.406   -2.32%       2.78   
92.257  171.155  119.626   14.311
innodb     write                      50     201.878  +11.01%     -24.97  
157.590  277.250  226.852   24.576
innodb     write-commit               50      96.790   +9.86%     -10.58   
87.681  181.491  107.372   11.006
innodb     write-commit-scale         50      47.774  +10.49%      -5.60   
43.064   92.328   53.373    5.662
innodb     write-scale                50     100.942  +10.92%     -12.37   
77.112  170.551  113.313   15.134
======================================================================================================================

FULL REVISION COMMENTARY:

  2193.1.2: Lee Bieber 2011-02-22 [merge] Merge Andrew - 723389: ORDER BY on...
    2192.2.1: Andrew Hutchings 2011-02-22 The widths for the indexes in the ...
  2193.1.1: Lee Bieber 2011-02-22 [merge] Merge Marisa - documentation updates
    1994.4.96: Marisa Plumb 2011-02-22 position updates
    1994.4.95: Marisa Plumb 2011-02-22 more comparison operators
    1994.4.94: Marisa Plumb 2011-02-22 [merge] updating
    1994.4.93: Marisa Plumb 2011-02-22 additions, edits
    1994.4.92: Marisa Plumb 2011-02-22 current time functions, new content
    1994.4.91: Marisa Plumb 2011-02-22 adding aggregate function content
    1994.4.90: Marisa Plumb 2011-02-22 [merge] updating to trunk
    1994.4.89: Marisa Plumb 2011-02-22 removing file
    1994.4.88: Marisa Plumb 2011-02-21 moving functions
    1994.4.87: Marisa Plumb 2011-02-21 adding to date functions
    1994.4.86: Marisa Plumb 2011-02-21 insert -- added multirow insert expla...
    1994.4.85: Marisa Plumb 2011-02-21 create index (no fast index creation)
    1994.4.84: Marisa Plumb 2011-02-21 logical operators
    1994.4.83: Marisa Plumb 2011-02-20 table update functions edits, startin...
    1994.4.82: Marisa Plumb 2011-02-20 additions and updates to transaction ...
    1994.4.81: Marisa Plumb 2011-02-20 edits
    1994.4.80: Marisa Plumb 2011-02-20 [merge] updating
    1994.4.79: Marisa Plumb 2011-02-20 [merge] updating 

_______________________________________________
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