=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   573
RUN DATE: 2010-10-12T13:03:50.786735
SERVER:   drizzled
VERSION:  staging
REVISION: 1842
COMMENT:  1842: Brian Aker 2010-10-12 [merge] Merge for Stewart

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     329.796   +5.86%     -20.51  
329.796  362.884  350.310   11.698
innodb     guid-scale                 50     152.903   +5.19%      -8.38  
152.903  166.004  161.281    4.462
innodb     key                        50      21.608   -0.03%       0.01   
21.563   21.693   21.602    0.048
innodb     key-scale                  50      10.941   -0.33%       0.04   
10.873   10.941   10.905    0.026
innodb     mixed                      50     119.214   +6.05%      -7.68  
119.214  135.324  126.892    5.158
innodb     mixed-commit               50      71.641   +4.83%      -3.63   
71.641   77.808   75.273    2.026
innodb     mixed-commit-scale         50      36.451   +3.63%      -1.37   
36.451   38.942   37.825    0.839
innodb     mixed-scale                50      56.691   +8.80%      -5.47   
56.691   66.867   62.159    3.598
innodb     scan                       50      94.651   +0.11%      -0.10   
94.651   94.907   94.751    0.095
innodb     scan-scale                 50      47.488   +0.11%      -0.05   
47.462   47.671   47.539    0.080
innodb     update                     50     229.125   +5.92%     -14.42  
229.125  249.333  243.542    7.343
innodb     update-commit              50      42.508   +0.18%      -0.08   
42.367   43.043   42.586    0.238
innodb     update-commit-scale        50      20.177   +2.87%      -0.60   
20.177   21.584   20.772    0.488
innodb     update-scale               50     111.592   +3.90%      -4.53  
111.592  120.605  116.124    3.077
innodb     write                      50     240.156   +6.46%     -16.57  
240.156  271.563  256.728   11.069
innodb     write-commit               50     108.436   +4.34%      -4.92  
108.436  116.288  113.352    2.637
innodb     write-commit-scale         50      54.013   +3.35%      -1.87   
54.013   58.416   55.886    1.442
innodb     write-scale                50     119.419   +4.86%      -6.10  
119.419  130.282  125.521    3.585

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     329.796   +8.24%     -29.60  
329.796  463.571  359.398   25.268
innodb     guid-scale                 50     152.903   +8.01%     -13.32  
152.903  214.960  166.225   11.905
innodb     key                        50      21.608   -0.57%       0.12   
21.235   21.693   21.485    0.140
innodb     key-scale                  50      10.941   -0.78%       0.08   
10.743   10.993   10.857    0.073
innodb     mixed                      50     119.214   +9.46%     -12.46  
119.214  177.409  131.669   11.239
innodb     mixed-commit               50      71.641   +6.33%      -4.84   
71.641   84.430   76.486    2.239
innodb     mixed-commit-scale         50      36.451   +3.41%      -1.29   
36.451   38.942   37.739    0.748
innodb     mixed-scale                50      56.691  +11.39%      -7.29   
56.691   86.381   63.981    5.935
innodb     scan                       50      94.651   +0.27%      -0.26   
94.519   96.319   94.910    0.382
innodb     scan-scale                 50      47.488   +0.23%      -0.11   
47.462   47.797   47.599    0.099
innodb     update                     50     229.125   +7.71%     -19.14  
229.125  283.202  248.263   10.236
innodb     update-commit              50      42.508   -0.07%       0.03   
41.474   43.222   42.476    0.495
innodb     update-commit-scale        50      20.177   +4.22%      -0.89   
20.177   22.532   21.067    0.493
innodb     update-scale               50     111.592   +4.01%      -4.66  
111.535  120.605  116.248    2.878
innodb     write                      50     240.156   +6.55%     -16.84  
240.156  271.563  256.998    8.492
innodb     write-commit               50     108.436   +4.85%      -5.53  
108.436  124.187  113.966    2.919
innodb     write-commit-scale         50      54.013   +4.25%      -2.40   
54.013   59.150   56.409    1.351
innodb     write-scale                50     119.419   +6.49%      -8.28  
119.419  136.817  127.701    4.598

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     329.796   +3.13%     -10.65  
280.135  463.571  340.451   24.222
innodb     guid-scale                 50     152.903   +7.28%     -12.01  
127.068  371.518  164.910   29.713
innodb     key                        50      21.608   -1.27%       0.27   
19.827   22.709   21.337    0.584
innodb     key-scale                  50      10.941   -1.33%       0.14   
10.120   11.470   10.798    0.260
innodb     mixed                      50     119.214   +5.31%      -6.68   
93.099  235.464  125.896   15.566
innodb     mixed-commit               50      71.641   +2.52%      -1.85   
63.794  110.784   73.493    3.786
innodb     mixed-commit-scale         50      36.451   +0.29%      -0.11   
31.817   56.701   36.558    2.002
innodb     mixed-scale                50      56.691   +8.10%      -5.00   
49.118  118.559   61.691    7.748
innodb     scan                       50      94.651   -1.58%       1.47   
90.275   98.490   93.181    1.460
innodb     scan-scale                 50      47.488   -1.40%       0.66   
45.180   51.250   46.831    0.753
innodb     update                     50     229.125   +8.08%     -20.13  
197.009  448.990  249.253   49.235
innodb     update-commit              50      42.508   +0.13%      -0.06   
39.226  116.667   42.565    5.508
innodb     update-commit-scale        50      20.177   +4.73%      -1.00   
19.428   57.552   21.179    2.716
innodb     update-scale               50     111.592  +10.79%     -13.50   
92.257  238.508  125.088   35.466
innodb     write                      50     240.156   +2.46%      -6.07  
187.310  329.376  246.224   22.990
innodb     write-commit               50     108.436   +3.80%      -4.29   
98.280  181.491  112.722    8.193
innodb     write-commit-scale         50      54.013   +3.81%      -2.14   
48.831   92.328   56.154    4.210
innodb     write-scale                50     119.419   +2.22%      -2.71   
93.760  170.551  122.126   11.727
======================================================================================================================

FULL REVISION COMMENTARY:

  1815.2.12: Stewart Smith 2010-10-13 remove HailDB config_fast_shutdown2 te...
  1815.2.11: Stewart Smith 2010-10-13 fix index definitions of HailDB system...
  1815.2.10: Stewart Smith 2010-10-13 check query plan of HailDB datadict ta...
  1815.2.9: Stewart Smith 2010-10-13 remove HAILDB_VERSION() function - you ...
  1815.2.8: Stewart Smith 2010-10-13 update haildb.status_table_function res...
  1815.2.7: Stewart Smith 2010-10-13 update haildb config_file_per_table_ena...
  1815.2.6: Stewart Smith 2010-10-12 [merge] merge trunk
  1815.2.5: Stewart Smith 2010-10-07 use the new ib_get_table_statistics() H...
  1815.2.4: Stewart Smith 2010-10-06 make all HailDB tests using EXPLAIN sub...
  1815.2.3: Stewart Smith 2010-10-06 use ib_get_table_statistics() - new in ...
  1815.2.2: Stewart Smith 2010-10-06 change HailDB status table function to ...
  1815.2.1: Stewart Smith 2010-10-06 only include haildb.h in HailDB Plugin,...

_______________________________________________
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