=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE: orisndriz01
RUN ID: 199
RUN DATE: 2010-02-28T20:28:07.900135
SERVER: drizzled
VERSION: staging
REVISION: 1314
COMMENT: 1314: Brian Aker 2010-02-28 [merge] Merge Padraig.
======================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 6.265 +0.43% -0.03 outside
norms 6.265 6.322 6.292 0.024
blackhole guid_bh 50 12.264 +1.18% -0.15 outside
norms 12.264 12.597 12.411 0.109
blackhole write-scale_bh 50 5.963 +0.70% -0.04 outside
norms 5.963 6.059 6.005 0.033
blackhole write_bh 50 11.842 -0.14% 0.02 within
norms 11.636 11.950 11.826 0.111
innodb guid 50 257.695 -1.43% 3.62 within
norms 239.102 265.332 254.074 8.577
innodb guid-scale 50 130.529 -2.07% 2.64 within
norms 121.573 133.387 127.886 4.048
innodb key 50 21.381 -0.70% 0.15 within
norms 21.039 21.429 21.233 0.150
innodb key-scale 50 11.365 -2.76% 0.31 within
norms 10.506 11.365 11.059 0.324
innodb mixed 50 139.291 -2.28% 3.11 within
norms 125.896 143.500 136.185 5.822
innodb mixed-commit 50 68.969 -2.80% 1.88 outside
norms 64.798 68.969 67.091 1.617
innodb mixed-commit-scale 50 33.973 -1.87% 0.62 within
norms 32.291 33.982 33.351 0.673
innodb mixed-scale 50 69.162 -1.37% 0.93 within
norms 64.098 72.339 68.228 2.657
innodb scan 50 85.374 -0.11% 0.09 within
norms 84.649 85.905 85.283 0.479
innodb scan-scale 50 43.353 -0.04% 0.02 within
norms 42.950 43.744 43.338 0.258
innodb update 50 292.109 -2.02% 5.80 within
norms 277.241 298.973 286.312 8.004
innodb update-commit 50 34.598 -2.72% 0.92 outside
norms 33.041 34.598 33.681 0.562
innodb update-commit-scale 50 17.023 -1.64% 0.27 outside
norms 16.469 17.023 16.749 0.195
innodb update-scale 50 144.882 -2.34% 3.32 within
norms 136.983 146.863 141.567 3.698
innodb write 50 246.252 -1.08% 2.63 within
norms 230.296 257.975 243.625 8.920
innodb write-commit 50 109.854 -1.64% 1.77 within
norms 100.438 113.530 108.080 4.286
innodb write-commit-scale 50 53.934 +0.11% -0.06 within
norms 50.720 56.877 53.991 1.958
innodb write-scale 50 126.072 -3.06% 3.74 within
norms 114.072 127.748 122.329 4.766
======================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 6.265 +0.37% -0.02 within
norms 6.103 6.363 6.288 0.056
blackhole guid_bh 50 12.264 +0.77% -0.09 outside
norms 12.180 12.597 12.359 0.092
blackhole write-scale_bh 50 5.963 +0.86% -0.05 within
norms 5.889 6.111 6.015 0.054
blackhole write_bh 50 11.842 +0.24% -0.03 within
norms 11.636 12.006 11.871 0.106
innodb guid 50 257.695 -2.49% 6.27 within
norms 234.998 272.666 251.425 11.624
innodb guid-scale 50 130.529 -3.50% 4.42 within
norms 116.716 139.583 126.110 6.315
innodb key 50 21.381 -2.44% 0.51 outside
norms 19.915 21.429 20.871 0.357
innodb key-scale 50 11.365 -3.07% 0.34 outside
norms 10.506 11.543 11.026 0.229
innodb mixed 50 139.291 -3.83% 5.14 within
norms 123.268 146.800 134.153 7.431
innodb mixed-commit 50 68.969 -2.21% 1.49 within
norms 63.405 73.361 67.475 2.443
innodb mixed-commit-scale 50 33.973 -1.94% 0.65 within
norms 31.331 36.888 33.327 1.107
innodb mixed-scale 50 69.162 -3.38% 2.26 within
norms 61.871 74.241 66.898 3.895
innodb scan 50 85.374 -0.07% 0.06 within
norms 84.184 88.410 85.315 1.026
innodb scan-scale 50 43.353 +0.35% -0.15 within
norms 42.875 44.785 43.505 0.449
innodb update 50 292.109 -1.40% 4.02 within
norms 272.267 321.605 288.086 12.187
innodb update-commit 50 34.598 -3.04% 1.02 outside
norms 32.924 34.917 33.577 0.539
innodb update-commit-scale 50 17.023 -0.81% 0.14 within
norms 16.147 17.563 16.887 0.309
innodb update-scale 50 144.882 -1.88% 2.67 within
norms 132.322 157.605 142.214 5.820
innodb write 50 246.252 -2.32% 5.57 within
norms 223.560 263.805 240.680 12.341
innodb write-commit 50 109.854 -2.28% 2.45 within
norms 100.438 115.893 107.407 4.626
innodb write-commit-scale 50 53.934 -0.38% 0.20 within
norms 50.504 57.503 53.730 2.427
innodb write-scale 50 126.072 -4.93% 5.93 within
norms 110.254 130.899 120.147 6.527
======================================================================================================================
TRENDING OVER ALL runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 6.265 -0.050 0.000 within
norms 6.103 6.363 6.262 0.050
blackhole guid_bh 50 12.264 0.350 -0.040 within
norms 12.114 12.597 12.307 0.086
blackhole write-scale_bh 50 5.963 0.740 -0.040 within
norms 5.863 6.111 6.007 0.052
blackhole write_bh 50 11.842 0.020 0.000 within
norms 11.628 12.014 11.844 0.098
innodb guid 50 257.695 -2.680 6.710 within
norms 232.232 272.666 250.981 12.521
innodb guid-scale 50 130.529 -3.670 4.620 within
norms 115.437 139.583 125.905 6.416
innodb key 50 21.381 -2.920 0.610 outside
norms 19.915 21.429 20.774 0.312
innodb key-scale 50 11.365 -4.080 0.450 outside
norms 10.374 11.543 10.919 0.215
innodb mixed 50 139.291 -4.230 5.650 within
norms 123.054 146.800 133.639 7.390
innodb mixed-commit 50 68.969 -2.230 1.500 within
norms 63.405 73.361 67.467 1.884
innodb mixed-commit-scale 50 33.973 -2.400 0.790 within
norms 30.593 36.888 33.178 1.144
innodb mixed-scale 50 69.162 -3.570 2.380 within
norms 60.925 74.241 66.781 3.765
innodb scan 50 85.374 0.170 -0.140 within
norms 84.137 93.263 85.517 1.305
innodb scan-scale 50 43.353 0.540 -0.230 within
norms 42.805 47.459 43.588 0.688
innodb update 50 292.109 -2.210 6.330 within
norms 268.017 321.605 285.780 9.885
innodb update-commit 50 34.598 -2.150 0.730 outside
norms 32.449 35.541 33.871 0.684
innodb update-commit-scale 50 17.023 -0.590 0.100 within
norms 16.147 17.684 16.924 0.356
innodb update-scale 50 144.882 -2.480 3.500 within
norms 132.322 157.605 141.383 4.787
innodb write 50 246.252 -1,951.760 234.250 outside
norms 11.899 12.105 12.002 0.103
innodb write-commit 50 109.854 -2.560 2.750 within
norms 98.069 115.893 107.108 4.663
innodb write-commit-scale 50 53.934 -1.490 0.790 within
norms 48.449 57.503 53.141 2.396
innodb write-scale 50 126.072 -1,976.800 120.000 outside
norms 6.061 6.080 6.071 0.010
======================================================================================================================
FULL REVISION COMMENTARY:
1309.1.18: Brian Aker 2010-02-28 [merge] Merge query rewrite.
1307.1.4: Padraig O'Sullivan 2010-02-25 Stopped using bind2 for now beca...
1307.1.3: Padraig O'Sullivan 2010-02-24 Updated based on review comments...
1307.1.2: Padraig O'Sullivan 2010-02-23 Added the plugin point for the q...
1307.1.1: Padraig O'Sullivan 2010-02-23 Added query rewrite interface an...
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
