=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   590
RUN DATE: 2010-10-15T00:27:50.552475
SERVER:   drizzled
VERSION:  staging
REVISION: 1853
COMMENT:  1853: Brian Aker 2010-10-14 [merge] MErge in user locks.

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     309.138   +4.27%     -13.78  
307.087  346.049  322.922   15.891
innodb     guid-scale                 50     137.925   +6.97%     -10.34  
137.925  160.622  148.263    9.429
innodb     key                        50      21.655   -0.35%       0.08   
21.478   21.655   21.580    0.065
innodb     key-scale                  50      10.897   +0.18%      -0.02   
10.886   10.953   10.917    0.025
innodb     mixed                      50     113.141   +3.86%      -4.54  
109.695  132.460  117.680    8.441
innodb     mixed-commit               50      67.185   +6.31%      -4.53   
67.185   76.935   71.712    3.788
innodb     mixed-commit-scale         50      33.767   +5.50%      -1.97   
33.767   38.008   35.732    1.834
innodb     mixed-scale                50      53.379   +7.25%      -4.17   
52.261   63.062   57.550    4.190
innodb     scan                       50      95.791   +0.01%      -0.01   
95.578   96.027   95.804    0.154
innodb     scan-scale                 50      48.051   +1.13%      -0.55   
47.975   50.725   48.600    1.065
innodb     update                     50     267.084   +4.66%     -13.05  
266.245  301.174  280.133   14.158
innodb     update-commit              50      40.066   +2.35%      -0.96   
40.066   41.779   41.030    0.629
innodb     update-commit-scale        50      19.393   +2.02%      -0.40   
19.161   20.876   19.793    0.592
innodb     update-scale               50     127.649   +5.79%      -7.84  
127.507  145.665  135.492    7.820
innodb     write                      50     207.669  +10.83%     -25.23  
207.669  262.752  232.902   22.238
innodb     write-commit               50     102.257   +4.65%      -4.99  
102.257  113.820  107.248    4.862
innodb     write-commit-scale         50      51.065   +4.52%      -2.42   
51.065   55.818   53.481    1.963
innodb     write-scale                50     103.940   +9.67%     -11.13  
103.940  126.061  115.071    9.230

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     309.138  +11.86%     -41.61  
307.087  463.571  350.746   31.321
innodb     guid-scale                 50     137.925  +14.78%     -23.92  
137.925  214.960  161.850   15.189
innodb     key                        50      21.655   -0.41%       0.09   
21.235   21.693   21.566    0.098
innodb     key-scale                  50      10.897   +0.09%      -0.01   
10.793   10.993   10.907    0.048
innodb     mixed                      50     113.141  +11.36%     -14.50  
109.695  177.409  127.643   13.549
innodb     mixed-commit               50      67.185  +10.68%      -8.03   
67.185   84.430   75.217    3.663
innodb     mixed-commit-scale         50      33.767   +9.11%      -3.39   
33.767   38.942   37.153    1.471
innodb     mixed-scale                50      53.379  +15.29%      -9.63   
52.261   86.381   63.011    6.837
innodb     scan                       50      95.791   -0.69%       0.66   
94.450   96.027   95.132    0.480
innodb     scan-scale                 50      48.051   -0.34%       0.16   
47.462   50.725   47.888    0.683
innodb     update                     50     267.084   -2.99%       7.76  
226.807  301.174  259.328   20.875
innodb     update-commit              50      40.066   +4.51%      -1.89   
40.066   43.206   41.958    0.858
innodb     update-commit-scale        50      19.393   +6.34%      -1.31   
19.161   22.532   20.706    0.780
innodb     update-scale               50     127.649   -4.35%       5.33  
108.046  145.665  122.323   10.760
innodb     write                      50     207.669  +16.92%     -42.30  
207.669  271.563  249.973   17.338
innodb     write-commit               50     102.257   +8.91%     -10.01  
102.257  124.187  112.264    4.878
innodb     write-commit-scale         50      51.065   +8.16%      -4.53   
51.065   59.150   55.600    2.065
innodb     write-scale                50     103.940  +16.41%     -20.41  
103.940  136.817  124.350    8.573

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     309.138   +9.13%     -31.05  
280.135  463.571  340.190   24.166
innodb     guid-scale                 50     137.925  +16.22%     -26.71  
127.068  371.518  164.636   29.527
innodb     key                        50      21.655   -1.47%       0.31   
19.827   22.709   21.341    0.580
innodb     key-scale                  50      10.897   -0.90%       0.10   
10.120   11.470   10.800    0.258
innodb     mixed                      50     113.141  +10.04%     -12.63   
93.099  235.464  125.771   15.485
innodb     mixed-commit               50      67.185   +8.56%      -6.29   
63.794  110.784   73.471    3.784
innodb     mixed-commit-scale         50      33.767   +7.60%      -2.78   
31.817   56.701   36.545    1.999
innodb     mixed-scale                50      53.379  +13.39%      -8.25   
49.118  118.559   61.632    7.706
innodb     scan                       50      95.791   -2.75%       2.57   
90.275   98.490   93.226    1.485
innodb     scan-scale                 50      48.051   -2.54%       1.19   
45.180   51.250   46.859    0.786
innodb     update                     50     267.084   -6.93%      17.31  
197.009  448.990  249.771   49.003
innodb     update-commit              50      40.066   +5.81%      -2.47   
39.226  116.667   42.536    5.461
innodb     update-commit-scale        50      19.393   +8.34%      -1.77   
19.161   57.552   21.158    2.696
innodb     update-scale               50     127.649   -1.93%       2.42   
92.257  238.508  125.229   35.188
innodb     write                      50     207.669  +15.59%     -38.36  
187.310  329.376  246.024   22.976
innodb     write-commit               50     102.257   +9.22%     -10.38   
98.280  181.491  112.638    8.163
innodb     write-commit-scale         50      51.065   +8.99%      -5.05   
48.831   92.328   56.111    4.190
innodb     write-scale                50     103.940  +14.82%     -18.08   
93.760  170.551  122.024   11.705
======================================================================================================================

FULL REVISION COMMENTARY:

  1823.6.9: Brian Aker 2010-10-14 [merge] Merge with trunk.
  1823.6.8: Brian Aker 2010-10-14 Fix lint issue.
  1823.6.7: Brian Aker 2010-10-12 Cleans up namespace for locks (now per user).
  1823.6.6: Brian Aker 2010-10-12 Added a table function to see locks, updat...
  1823.6.5: Brian Aker 2010-10-12 Added get_locks() and release_locks();
  1823.6.4: Brian Aker 2010-10-12 Enables the MySQL behavior where if you ta...
  1823.6.3: Brian Aker 2010-10-12 Time out code now inserted for user locks.
  1823.6.2: Brian Aker 2010-10-11 Solves the "dangling lock" problem.
  1823.6.1: Brian Aker 2010-10-09 First pass through adding back user_locks.

_______________________________________________
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