=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   678
RUN DATE: 2010-10-27T19:44:28.703483
SERVER:   drizzled
VERSION:  staging
REVISION: 1885
COMMENT:  1885: Brian Aker 2010-10-27 [merge] Merge in additions to IS for FK

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     361.328  -10.53%      34.43  
283.299  371.317  326.894   33.709
innodb     guid-scale                 50     163.184  -10.87%      16.00  
128.534  163.184  147.183   13.612
innodb     key                        50      22.055   -0.19%       0.04   
21.925   22.061   22.013    0.049
innodb     key-scale                  50      11.199   -0.56%       0.06   
11.048   11.199   11.136    0.054
innodb     mixed                      50     132.698  -12.07%      14.29  
102.092  132.698  118.411   11.837
innodb     mixed-commit               50      77.920   -8.65%       6.20   
65.985   77.920   71.720    5.117
innodb     mixed-commit-scale         50      39.478  -10.23%       3.66   
33.291   39.478   35.814    2.936
innodb     mixed-scale                50      61.138   -6.25%       3.60   
50.706   66.472   57.542    5.618
innodb     scan                       50      96.199   +0.24%      -0.23   
96.199   96.749   96.430    0.182
innodb     scan-scale                 50      48.303   +0.16%      -0.08   
48.303   48.441   48.379    0.051
innodb     update                     50     314.528  -10.11%      28.88  
258.890  321.294  285.647   26.638
innodb     update-commit              50      40.414   -0.91%       0.36   
38.030   42.095   40.051    1.314
innodb     update-commit-scale        50      20.342   -3.37%       0.66   
19.057   20.342   19.678    0.553
innodb     update-scale               50     151.356  -10.14%      13.94  
125.870  154.985  137.419   12.925
innodb     write                      50     265.999  -14.78%      34.26  
200.595  274.679  231.742   31.977
innodb     write-commit               50     114.695   -6.62%       7.12  
100.717  116.473  107.574    6.617
innodb     write-commit-scale         50      58.135   -7.54%       4.07   
50.478   58.646   54.061    3.585
innodb     write-scale                50     131.059  -15.51%      17.60  
100.867  131.059  113.461   14.330

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     361.328   -6.14%      20.90  
283.299  371.317  340.425   20.208
innodb     guid-scale                 50     163.184   -4.38%       6.84  
128.534  169.708  156.343    9.601
innodb     key                        50      22.055   +0.18%      -0.04   
21.889   22.259   22.094    0.095
innodb     key-scale                  50      11.199   -0.31%       0.03   
11.033   11.259   11.165    0.060
innodb     mixed                      50     132.698   -6.50%       8.10  
102.092  135.207  124.595    7.868
innodb     mixed-commit               50      77.920   -4.51%       3.36   
65.985   78.159   74.557    3.379
innodb     mixed-commit-scale         50      39.478   -5.88%       2.19   
33.291   41.719   37.286    2.163
innodb     mixed-scale                50      61.138   -1.02%       0.62   
50.706   66.821   60.522    4.119
innodb     scan                       50      96.199   -0.12%       0.12   
95.590   96.749   96.079    0.282
innodb     scan-scale                 50      48.303   -0.12%       0.06   
48.021   48.441   48.246    0.116
innodb     update                     50     314.528   -5.43%      16.20  
258.890  321.294  298.332   17.015
innodb     update-commit              50      40.414   -0.07%       0.03   
38.030   42.095   40.384    0.745
innodb     update-commit-scale        50      20.342   -1.90%       0.38   
19.057   20.930   19.962    0.491
innodb     update-scale               50     151.356   -4.11%       5.98  
125.870  167.564  145.378    9.874
innodb     write                      50     265.999   -7.81%      19.27  
200.595  274.679  246.733   19.580
innodb     write-commit               50     114.695   -2.75%       3.07  
100.717  117.127  111.628    4.744
innodb     write-commit-scale         50      58.135   -4.34%       2.42   
50.478   58.646   55.714    2.291
innodb     write-scale                50     131.059   -6.58%       8.09  
100.867  134.869  122.969    9.984

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     361.328   -6.52%      22.10  
249.012  463.571  339.226   24.852
innodb     guid-scale                 50     163.184   +0.13%      -0.21  
104.424  371.518  163.390   28.732
innodb     key                        50      22.055   -3.06%       0.65   
19.827   22.709   21.401    0.586
innodb     key-scale                  50      11.199   -3.43%       0.37   
10.120   11.470   10.828    0.262
innodb     mixed                      50     132.698   -5.92%       7.41   
93.099  235.464  125.284   15.195
innodb     mixed-commit               50      77.920   -6.09%       4.48   
62.096  110.784   73.445    3.841
innodb     mixed-commit-scale         50      39.478   -8.11%       2.96   
31.659   56.701   36.518    2.020
innodb     mixed-scale                50      61.138   +0.43%      -0.27   
48.583  118.559   61.404    7.534
innodb     scan                       50      96.199   -2.91%       2.72   
90.275   98.490   93.480    1.620
innodb     scan-scale                 50      48.303   -2.81%       1.32   
45.180   51.250   46.983    0.841
innodb     update                     50     314.528  -24.04%      60.96  
197.009  448.990  253.570   48.297
innodb     update-commit              50      40.414   +4.50%      -1.90   
38.030  116.667   42.317    5.248
innodb     update-commit-scale        50      20.342   +3.30%      -0.69   
18.059   57.552   21.036    2.601
innodb     update-scale               50     151.356  -19.59%      24.79   
92.257  238.508  126.561   33.912
innodb     write                      50     265.999   -8.49%      20.82  
180.889  329.376  245.176   23.004
innodb     write-commit               50     114.695   -2.11%       2.37   
95.021  181.491  112.327    8.001
innodb     write-commit-scale         50      58.135   -3.90%       2.18   
47.313   92.328   55.953    4.101
innodb     write-scale                50     131.059   -7.77%       9.45   
93.760  170.551  121.608   11.696
======================================================================================================================

FULL REVISION COMMENTARY:

  1861.4.9: Brian Aker 2010-10-27 [merge] Merge with trunk.
  1861.4.8: Brian Aker 2010-10-22 Adds in a portion of the ref constraints t...
  1861.4.7: Brian Aker 2010-10-21 Cleanup schema from DD to have similar sty...
  1861.4.6: Brian Aker 2010-10-21 Switched columns to use AllFields.
  1861.4.5: Brian Aker 2010-10-21 Fix IS to use straight generator.
  1861.4.4: Brian Aker 2010-10-20 Cleanup display code around DD/IS

_______________________________________________
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