=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   1079
RUN DATE: 2011-01-03T15:32:06.319637
SERVER:   drizzled
VERSION:  staging
REVISION: 2049
COMMENT:  2049: Brian Aker 2011-01-03 [merge] Refactor drop schema so that it 
can be u...

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     252.179   -6.15%      14.60  
228.270  252.179  237.575    8.328
innodb     guid-scale                 50     113.954   -5.93%       6.38  
101.818  113.954  107.575    4.535
innodb     key                        50      21.922  +14.20%      -3.63   
21.899   40.122   25.550    7.286
innodb     key-scale                  50      11.088  +13.52%      -1.73   
11.044   19.828   12.822    3.503
innodb     mixed                      50     105.468  -10.95%      10.41   
85.141  105.468   95.057    6.503
innodb     mixed-commit               50      63.566   -1.67%       1.04   
60.568   65.500   62.522    1.784
innodb     mixed-commit-scale         50      30.181   -1.36%       0.40   
28.604   31.050   29.776    0.893
innodb     mixed-scale                50      46.933   -1.54%       0.71   
42.666   48.196   46.221    1.909
innodb     scan                       50      96.253   +3.82%      -3.83   
95.794  116.260  100.079    8.093
innodb     scan-scale                 50      48.168   +4.20%      -2.11   
48.073   58.600   50.281    4.160
innodb     update                     50     245.231   -3.45%       8.19  
227.160  245.231  237.043    5.899
innodb     update-scale               50     120.957   -4.54%       5.25  
110.151  120.957  115.703    3.716
innodb     write                      50     209.669   -7.36%      14.38  
183.131  209.669  195.293    9.181
innodb     write-commit               50      97.880   -2.61%       2.49   
93.817   97.880   95.388    1.540
innodb     write-commit-scale         50      48.051   -2.10%       0.99   
46.391   48.051   47.063    0.560
innodb     write-scale                50      99.956   -5.52%       5.23   
91.187   99.956   94.730    3.174

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     252.179   -5.06%      12.13  
215.107  268.311  240.044   14.662
innodb     guid-scale                 50     113.954   -5.44%       5.88   
96.639  121.868  108.073    6.759
innodb     key                        50      21.922   +6.21%      -1.45   
21.848   40.122   23.374    3.865
innodb     key-scale                  50      11.088   +5.79%      -0.68   
10.993   19.828   11.769    1.860
innodb     mixed                      50     105.468   -9.05%       8.75   
85.141  107.845   96.715    6.943
innodb     mixed-commit               50      63.566   -2.11%       1.31   
57.403   67.807   62.252    2.922
innodb     mixed-commit-scale         50      30.181   -1.66%       0.49   
27.016   32.551   29.689    1.525
innodb     mixed-scale                50      46.933   -0.94%       0.44   
40.196   52.631   46.497    3.234
innodb     scan                       50      96.253   +0.74%      -0.72   
95.610  116.260   96.968    4.431
innodb     scan-scale                 50      48.168   +1.12%      -0.55   
48.071   58.600   48.714    2.270
innodb     update                     50     245.231   -1.93%       4.64  
212.330  269.308  240.591   15.234
innodb     update-scale               50     120.957   -2.90%       3.41   
98.865  132.389  117.549    8.555
innodb     write                      50     209.669   -6.22%      12.28  
169.053  224.658  197.388   15.503
innodb     write-commit               50      97.880   -2.00%       1.92   
89.108  104.213   95.957    4.000
innodb     write-commit-scale         50      48.051   -0.57%       0.27   
44.254   52.188   47.778    2.088
innodb     write-scale                50      99.956   -4.60%       4.40   
80.718  108.676   95.556    7.234

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     252.179  +20.92%     -66.70  
215.107  463.571  318.880   43.476
innodb     guid-scale                 50     113.954  +24.90%     -37.77   
96.639  371.518  151.727   32.354
innodb     key                        50      21.922   -0.38%       0.08   
19.827   40.122   21.839    1.168
innodb     key-scale                  50      11.088   -0.47%       0.05   
10.120   19.828   11.036    0.552
innodb     mixed                      50     105.468  +11.69%     -13.96   
85.141  235.464  119.431   17.158
innodb     mixed-commit               50      63.566  +11.00%      -7.85   
57.403  110.784   71.420    5.279
innodb     mixed-commit-scale         50      30.181  +14.47%      -5.11   
27.016   56.701   35.287    2.990
innodb     mixed-scale                50      46.933  +19.59%     -11.43   
40.196  118.559   58.365    8.742
innodb     scan                       50      96.253   -2.05%       1.94   
90.275  116.260   94.317    2.131
innodb     scan-scale                 50      48.168   -1.64%       0.78   
45.180   58.600   47.390    1.077
innodb     update                     50     245.231   +3.77%      -9.62  
197.009  448.990  254.852   42.948
innodb     update-scale               50     120.957   +3.99%      -5.03   
92.257  238.508  125.985   29.469
innodb     write                      50     209.669  +11.25%     -26.58  
169.021  329.376  236.251   26.728
innodb     write-commit               50      97.880  +10.42%     -11.39   
89.108  181.491  109.267    9.197
innodb     write-commit-scale         50      48.051  +11.65%      -6.34   
44.254   92.328   54.390    4.602
innodb     write-scale                50      99.956  +14.36%     -16.77   
80.718  170.551  116.722   13.962
======================================================================================================================

FULL REVISION COMMENTARY:

  2041.3.12: Brian Aker 2011-01-02 Move to private.
  2041.3.11: Brian Aker 2011-01-02 Only change schemas if we DROP the schema.
  2041.3.10: Brian Aker 2011-01-02 Put more of drop schema behind interface.
  2041.3.9: Brian Aker 2010-12-31 Remove std::cerr messages
  2041.3.8: Brian Aker 2010-12-31 Fixed issue with drop schema when working ...
  2041.3.7: Brian Aker 2010-12-31 Cleanup for error, there is still a failur...
  2041.3.6: Brian Aker 2010-12-31 Cleanup of drop table.
  2041.3.5: Brian Aker 2010-12-30 Make it so that tables are sent not as raw...
  2041.3.4: Brian Aker 2010-12-30 remove goto
  2041.3.3: Brian Aker 2010-12-30 Just grab the identifiers, and run with them.
  2041.3.2: Brian Aker 2010-12-30 Improve on drop schema temp tables.
  2041.3.1: Brian Aker 2010-12-30 Move temp table schema drop inside of API.

_______________________________________________
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