=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   656
RUN DATE: 2010-10-23T23:10:09.431296
SERVER:   drizzled
VERSION:  staging
REVISION: 1875
COMMENT:  1875: Brian Aker 2010-10-23 [merge] Table encapsulate merge.

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     353.922   -3.97%      13.51  
330.673  353.922  340.411    8.964
innodb     guid-scale                 50     161.907   -3.51%       5.50  
152.020  161.907  156.410    3.336
innodb     key                        50      22.243   -0.34%       0.08   
22.133   22.243   22.167    0.040
innodb     key-scale                  50      11.183   +0.12%      -0.01   
11.163   11.225   11.196    0.023
innodb     mixed                      50     130.259   -5.85%       7.20  
118.010  130.259  123.062    4.563
innodb     mixed-commit               50      78.159   -4.63%       3.46   
72.982   78.159   74.702    1.786
innodb     mixed-commit-scale         50      37.994   -0.85%       0.32   
35.569   41.719   37.674    2.184
innodb     mixed-scale                50      63.863   -5.36%       3.25   
58.135   63.863   60.613    2.071
innodb     scan                       50      95.940   +0.01%      -0.01   
95.907   95.987   95.946    0.027
innodb     scan-scale                 50      48.128   +0.12%      -0.06   
48.128   48.229   48.188    0.045
innodb     update                     50     307.537   -3.11%       9.26  
291.497  307.537  298.274    5.474
innodb     update-commit              50      40.344   +0.28%      -0.11   
40.333   40.725   40.457    0.157
innodb     update-commit-scale        50      20.014   +0.05%      -0.01   
19.772   20.282   20.024    0.184
innodb     update-scale               50     153.131   -2.43%       3.64  
140.338  167.564  149.492   10.025
innodb     write                      50     263.699   -7.28%      17.88  
238.330  263.699  245.815    9.095
innodb     write-commit               50     115.668   -3.81%       4.25  
109.891  115.668  111.421    2.139
innodb     write-commit-scale         50      56.552   -1.85%       1.03   
54.508   56.552   55.526    0.712
innodb     write-scale                50     133.009   -5.21%       6.58  
118.613  134.869  126.425    6.456

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     353.922   -5.46%      18.32  
278.329  414.946  335.605   26.932
innodb     guid-scale                 50     161.907   -4.99%       7.70  
119.520  190.089  154.211   13.768
innodb     key                        50      22.243   -0.84%       0.19   
21.710   22.263   22.058    0.169
innodb     key-scale                  50      11.183   -0.47%       0.05   
10.910   11.259   11.130    0.100
innodb     mixed                      50     130.259   -6.47%       7.92   
96.431  154.212  122.342   11.130
innodb     mixed-commit               50      78.159   -5.12%       3.81   
66.124   84.328   74.350    4.020
innodb     mixed-commit-scale         50      37.994   -3.49%       1.28   
32.986   41.719   36.714    2.011
innodb     mixed-scale                50      63.863   -5.99%       3.61   
49.724   74.377   60.252    5.069
innodb     scan                       50      95.940   -0.05%       0.05   
95.062   96.478   95.893    0.312
innodb     scan-scale                 50      48.128   +0.08%      -0.04   
47.725   48.394   48.168    0.149
innodb     update                     50     307.537   -5.82%      16.92  
253.803  312.674  290.620   14.949
innodb     update-commit              50      40.344   -0.09%       0.04   
39.420   41.630   40.307    0.573
innodb     update-commit-scale        50      20.014   -0.26%       0.05   
18.846   21.063   19.963    0.531
innodb     update-scale               50     153.131   -8.35%      11.80  
118.549  167.564  141.329   10.111
innodb     write                      50     263.699   -9.69%      23.30  
201.575  263.699  240.403   16.116
innodb     write-commit               50     115.668   -5.03%       5.54  
101.138  116.966  110.127    4.255
innodb     write-commit-scale         50      56.552   -3.37%       1.84   
50.603   58.046   54.708    2.134
innodb     write-scale                50     133.009  -11.46%      13.67  
101.837  134.869  119.337    9.088

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     353.922   -4.33%      14.70  
249.012  463.571  339.219   24.813
innodb     guid-scale                 50     161.907   +1.05%      -1.71  
104.424  371.518  163.621   29.013
innodb     key                        50      22.243   -4.02%       0.86   
19.827   22.709   21.383    0.583
innodb     key-scale                  50      11.183   -3.36%       0.36   
10.120   11.470   10.819    0.260
innodb     mixed                      50     130.259   -3.95%       4.95   
93.099  235.464  125.312   15.312
innodb     mixed-commit               50      78.159   -6.44%       4.73   
62.096  110.784   73.432    3.832
innodb     mixed-commit-scale         50      37.994   -4.07%       1.48   
31.659   56.701   36.510    2.011
innodb     mixed-scale                50      63.863   -3.94%       2.42   
48.583  118.559   61.442    7.586
innodb     scan                       50      95.940   -2.71%       2.53   
90.275   98.490   93.408    1.581
innodb     scan-scale                 50      48.128   -2.51%       1.18   
45.180   51.250   46.948    0.825
innodb     update                     50     307.537  -21.89%      55.24  
197.009  448.990  252.298   48.249
innodb     update-commit              50      40.344   +4.79%      -2.03   
38.508  116.667   42.373    5.305
innodb     update-commit-scale        50      20.014   +5.00%      -1.05   
18.059   57.552   21.068    2.627
innodb     update-scale               50     153.131  -21.43%      27.02   
92.257  238.508  126.108   34.213
innodb     write                      50     263.699   -7.56%      18.53  
180.889  329.376  245.169   22.943
innodb     write-commit               50     115.668   -2.95%       3.31   
95.021  181.491  112.354    8.047
innodb     write-commit-scale         50      56.552   -1.05%       0.59   
47.313   92.328   55.963    4.128
innodb     write-scale                50     133.009   -9.37%      11.39   
93.760  170.551  121.617   11.680
======================================================================================================================

FULL REVISION COMMENTARY:

  1874.1.2: Brian Aker 2010-10-23 Encapsulate table_name from table_list.
  1874.1.1: Brian Aker 2010-10-23 Encapsulate schema_name it table_list.

_______________________________________________
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