=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE:  orisndriz04
RUN ID:   654
RUN DATE: 2010-10-23T20:43:59.977707
SERVER:   drizzled
VERSION:  staging
REVISION: 1875
COMMENT:  1875: Brian Aker 2010-10-23 [merge] Merge Brian

======================================================================================================================
TRENDING OVER LAST 5 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     330.673   +1.51%      -5.06  
330.547  347.170  335.736    6.439
innodb     guid-scale                 50     154.422   +0.73%      -1.13  
152.020  157.804  155.556    2.158
innodb     key                        50      22.146   +0.04%      -0.01   
22.133   22.183   22.155    0.020
innodb     key-scale                  50      11.163   +0.32%      -0.04   
11.163   11.225   11.199    0.022
innodb     mixed                      50     119.543   +2.31%      -2.83  
118.010  126.825  122.375    3.581
innodb     mixed-commit               50      73.988   -0.14%       0.10   
72.982   74.260   73.886    0.461
innodb     mixed-commit-scale         50      41.719  -11.52%       4.31   
35.569   41.719   37.409    2.210
innodb     mixed-scale                50      58.839   +1.09%      -0.65   
58.135   61.853   59.490    1.426
innodb     scan                       50      95.961   +0.02%      -0.01   
95.907   96.088   95.976    0.062
innodb     scan-scale                 50      48.139   +0.10%      -0.05   
48.123   48.229   48.187    0.046
innodb     update                     50     297.246   -1.08%       3.16  
286.580  300.370  294.083    4.752
innodb     update-commit              50      40.333   +0.39%      -0.16   
40.333   40.725   40.490    0.147
innodb     update-commit-scale        50      19.772   +0.89%      -0.18   
19.638   20.282   19.949    0.241
innodb     update-scale               50     167.564  -13.48%      19.91  
140.338  167.564  147.659   10.030
innodb     write                      50     241.913   -0.20%       0.47  
238.330  243.411  241.439    1.674
innodb     write-commit               50     110.343   -0.19%       0.20  
109.252  110.603  110.138    0.514
innodb     write-commit-scale         50      54.508   +1.18%      -0.65   
54.508   56.060   55.158    0.542
innodb     write-scale                50     134.869   -9.21%      11.37  
118.383  134.869  123.499    6.115

======================================================================================================================
TRENDING OVER LAST 20 runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     330.673   +1.25%      -4.18  
278.329  414.946  334.851   26.618
innodb     guid-scale                 50     154.422   -0.40%       0.62  
119.520  190.089  153.804   13.654
innodb     key                        50      22.146   -0.56%       0.12   
21.521   22.263   22.022    0.200
innodb     key-scale                  50      11.163   -0.41%       0.05   
10.910   11.259   11.117    0.109
innodb     mixed                      50     119.543   +1.79%      -2.18   
96.431  154.212  121.722   11.016
innodb     mixed-commit               50      73.988   +0.09%      -0.06   
66.124   84.328   74.053    3.947
innodb     mixed-commit-scale         50      41.719  -14.04%       5.14   
32.986   41.719   36.584    2.009
innodb     mixed-scale                50      58.839   +1.90%      -1.14   
49.724   74.377   59.979    5.014
innodb     scan                       50      95.961   -0.10%       0.10   
95.062   96.478   95.863    0.335
innodb     scan-scale                 50      48.139   +0.03%      -0.02   
47.725   48.394   48.155    0.162
innodb     update                     50     297.246   -2.65%       7.68  
253.803  312.674  289.571   14.453
innodb     update-commit              50      40.333   -0.12%       0.05   
39.420   41.630   40.285    0.580
innodb     update-commit-scale        50      19.772   +0.89%      -0.18   
18.846   21.063   19.950    0.533
innodb     update-scale               50     167.564  -19.28%      27.09  
118.549  167.564  140.477    9.793
innodb     write                      50     241.913   -1.29%       3.09  
201.575  260.229  238.823   15.282
innodb     write-commit               50     110.343   -0.57%       0.62  
101.138  116.966  109.722    4.091
innodb     write-commit-scale         50      54.508   +0.18%      -0.10   
50.603   58.046   54.605    2.092
innodb     write-scale                50     134.869  -13.80%      16.36  
101.837  134.869  118.511    8.542

======================================================================================================================
TRENDING OVER ALL runs
Engine     Test                      Conc     Time  % Diff from Avg Diff    Min 
     Max      Avg      STD     
======================================================================================================================
innodb     guid                       50     330.673   +2.51%      -8.51  
249.012  463.571  339.179   24.835
innodb     guid-scale                 50     154.422   +5.62%      -9.20  
104.424  371.518  163.625   29.049
innodb     key                        50      22.146   -3.58%       0.76   
19.827   22.709   21.381    0.582
innodb     key-scale                  50      11.163   -3.19%       0.34   
10.120   11.470   10.818    0.260
innodb     mixed                      50     119.543   +4.59%      -5.76   
93.099  235.464  125.299   15.329
innodb     mixed-commit               50      73.988   -0.77%       0.57   
62.096  110.784   73.420    3.830
innodb     mixed-commit-scale         50      41.719  -14.28%       5.21   
31.659   56.701   36.506    2.012
innodb     mixed-scale                50      58.839   +4.23%      -2.60   
48.583  118.559   61.436    7.594
innodb     scan                       50      95.961   -2.74%       2.56   
90.275   98.490   93.402    1.578
innodb     scan-scale                 50      48.139   -2.54%       1.19   
45.180   51.250   46.945    0.824
innodb     update                     50     297.246  -17.88%      45.09  
197.009  448.990  252.154   48.230
innodb     update-commit              50      40.333   +4.83%      -2.05   
38.508  116.667   42.378    5.310
innodb     update-commit-scale        50      19.772   +6.16%      -1.30   
18.059   57.552   21.070    2.630
innodb     update-scale               50     167.564  -32.94%      41.52   
92.257  238.508  126.041   34.229
innodb     write                      50     241.913   +1.31%      -3.21  
180.889  329.376  245.123   22.953
innodb     write-commit               50     110.343   +1.78%      -2.00   
95.021  181.491  112.346    8.055
innodb     write-commit-scale         50      54.508   +2.60%      -1.45   
47.313   92.328   55.962    4.133
innodb     write-scale                50     134.869  -10.92%      13.28   
93.760  170.551  121.589   11.681
======================================================================================================================

FULL REVISION COMMENTARY:

  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