=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   588
RUN DATE: 2010-10-14T22:18:24.965049
SERVER:   drizzled
VERSION:  staging
REVISION: 1851
COMMENT:  1851: Brian Aker 2010-10-14 [merge] Merge in mutable/execute

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     307.087   +7.51%     -24.94  
307.087  354.667  332.028   18.252
innodb     guid-scale                 50     141.237   +7.36%     -11.23  
141.237  160.622  152.466    8.524
innodb     key                        50      21.478   +0.40%      -0.09   
21.478   21.642   21.565    0.054
innodb     key-scale                  50      10.886   +0.39%      -0.04   
10.886   10.958   10.929    0.027
innodb     mixed                      50     111.507   +7.55%      -9.10  
109.695  132.460  120.612    8.889
innodb     mixed-commit               50      68.960   +6.04%      -4.44   
68.960   76.935   73.395    3.231
innodb     mixed-commit-scale         50      34.023   +6.68%      -2.44   
34.023   38.008   36.458    1.617
innodb     mixed-scale                50      52.261  +11.86%      -7.04   
52.261   63.062   59.296    3.897
innodb     scan                       50      95.578   +0.23%      -0.22   
95.578   96.027   95.802    0.154
innodb     scan-scale                 50      48.058   +1.10%      -0.53   
47.975   50.725   48.591    1.070
innodb     update                     50     266.245   +7.21%     -20.68  
266.245  301.174  286.921   14.408
innodb     update-commit              50      40.809   +1.13%      -0.47   
40.809   41.779   41.274    0.404
innodb     update-commit-scale        50      19.161   +4.45%      -0.89   
19.161   20.876   20.052    0.643
innodb     update-scale               50     127.507   +8.02%     -11.11  
127.507  145.665  138.618    7.156
innodb     write                      50     213.064  +11.59%     -27.92  
213.064  262.752  240.988   18.655
innodb     write-commit               50     102.825   +6.02%      -6.59  
102.825  113.820  109.413    4.558
innodb     write-commit-scale         50      52.298   +3.89%      -2.12   
52.298   55.818   54.415    1.682
innodb     write-scale                50     107.867   +9.94%     -11.91  
107.867  127.456  119.774    8.305

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     307.087  +12.91%     -45.52  
307.087  463.571  352.607   29.865
innodb     guid-scale                 50     141.237  +13.28%     -21.62  
141.237  214.960  162.858   14.205
innodb     key                        50      21.478   +0.32%      -0.07   
21.235   21.693   21.547    0.113
innodb     key-scale                  50      10.886   +0.12%      -0.01   
10.743   10.993   10.899    0.060
innodb     mixed                      50     111.507  +13.24%     -17.02  
109.695  177.409  128.526   13.145
innodb     mixed-commit               50      68.960   +8.87%      -6.71   
68.960   84.430   75.673    3.169
innodb     mixed-commit-scale         50      34.023   +8.87%      -3.31   
34.023   38.942   37.333    1.249
innodb     mixed-scale                50      52.261  +17.42%     -11.02   
52.261   86.381   63.284    6.550
innodb     scan                       50      95.578   -0.51%       0.48   
94.450   96.027   95.096    0.456
innodb     scan-scale                 50      48.058   -0.39%       0.19   
47.462   50.725   47.869    0.683
innodb     update                     50     266.245   -3.24%       8.37  
226.807  301.174  257.877   21.290
innodb     update-commit              50      40.809   +2.99%      -1.26   
40.731   43.206   42.068    0.742
innodb     update-commit-scale        50      19.161   +7.79%      -1.62   
19.161   22.532   20.780    0.719
innodb     update-scale               50     127.507   -4.89%       5.94  
108.046  145.665  121.563   10.893
innodb     write                      50     213.064  +15.37%     -38.70  
213.064  271.563  251.764   14.492
innodb     write-commit               50     102.825   +8.80%      -9.92  
102.825  124.187  112.747    4.309
innodb     write-commit-scale         50      52.298   +6.27%      -3.50   
52.298   59.150   55.798    1.793
innodb     write-scale                50     107.867  +13.93%     -17.46  
107.867  136.817  125.326    7.194

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     307.087   +9.76%     -33.20  
280.135  463.571  340.282   24.143
innodb     guid-scale                 50     141.237  +14.25%     -23.47  
127.068  371.518  164.707   29.535
innodb     key                        50      21.478   -0.64%       0.14   
19.827   22.709   21.341    0.580
innodb     key-scale                  50      10.886   -0.80%       0.09   
10.120   11.470   10.800    0.258
innodb     mixed                      50     111.507  +11.36%     -14.30   
93.099  235.464  125.805   15.492
innodb     mixed-commit               50      68.960   +6.16%      -4.53   
63.794  110.784   73.487    3.775
innodb     mixed-commit-scale         50      34.023   +6.92%      -2.53   
31.817   56.701   36.553    1.996
innodb     mixed-scale                50      52.261  +15.24%      -9.39   
49.118  118.559   61.654    7.705
innodb     scan                       50      95.578   -2.53%       2.36   
90.275   98.490   93.219    1.481
innodb     scan-scale                 50      48.058   -2.56%       1.20   
45.180   51.250   46.856    0.784
innodb     update                     50     266.245   -6.62%      16.52  
197.009  448.990  249.722   49.063
innodb     update-commit              50      40.809   +4.08%      -1.73   
39.226  116.667   42.543    5.466
innodb     update-commit-scale        50      19.161   +9.46%      -2.00   
19.161   57.552   21.163    2.698
innodb     update-scale               50     127.507   -1.82%       2.28   
92.257  238.508  125.223   35.235
innodb     write                      50     213.064  +13.43%     -33.06  
187.310  329.376  246.126   22.921
innodb     write-commit               50     102.825   +8.73%      -9.84   
98.280  181.491  112.666    8.157
innodb     write-commit-scale         50      52.298   +6.82%      -3.83   
48.831   92.328   56.125    4.187
innodb     write-scale                50     107.867  +11.64%     -14.21   
93.760  170.551  122.072   11.683
======================================================================================================================

FULL REVISION COMMENTARY:

  1835.1.7: Brian Aker 2010-10-14 Adding in a subquery test.
  1835.1.6: Brian Aker 2010-10-14 This patch returns dynamic SQL into the co...
  1835.1.5: Brian Aker 2010-10-11 Cleans up some spots where we were using m...
  1835.1.4: Brian Aker 2010-10-11 Update to remove more of the getMutableSha...

_______________________________________________
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