=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE: orisndriz01
RUN ID: 201
RUN DATE: 2010-03-01T02:00:54.372273
SERVER: drizzled
VERSION: staging
REVISION: 1315
COMMENT: 1315: Brian Aker 2010-02-28 [merge] MErge Strewart.
======================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 6.325 -0.39% 0.02 within
norms 6.265 6.325 6.300 0.026
blackhole guid_bh 50 12.272 +0.95% -0.12 within
norms 12.264 12.597 12.390 0.123
blackhole write-scale_bh 50 6.021 -0.25% 0.02 within
norms 5.963 6.059 6.006 0.034
blackhole write_bh 50 11.845 +0.19% -0.02 within
norms 11.782 11.950 11.867 0.060
innodb guid 50 240.930 +3.32% -8.26 outside
norms 239.102 257.695 249.193 7.678
innodb guid-scale 50 120.802 +3.64% -4.57 outside
norms 120.802 130.529 125.369 3.747
innodb key 50 21.353 -0.27% 0.06 within
norms 21.113 21.429 21.296 0.118
innodb key-scale 50 10.911 +2.06% -0.23 outside
norms 10.878 11.365 11.140 0.204
innodb mixed 50 125.963 +5.06% -6.71 outside
norms 125.896 139.291 132.677 5.638
innodb mixed-commit 50 64.218 +2.93% -1.94 outside
norms 64.218 68.969 66.158 1.659
innodb mixed-commit-scale 50 32.487 +1.71% -0.57 within
norms 32.291 33.973 33.052 0.658
innodb mixed-scale 50 63.221 +4.79% -3.18 outside
norms 63.221 69.162 66.404 2.316
innodb scan 50 86.358 -1.15% 0.98 outside
norms 84.649 86.358 85.373 0.612
innodb scan-scale 50 43.803 -0.89% 0.39 outside
norms 42.950 43.803 43.416 0.321
innodb update 50 273.886 +2.63% -7.41 outside
norms 273.886 292.109 281.295 6.141
innodb update-commit 50 32.986 +1.48% -0.50 within
norms 32.986 34.598 33.481 0.595
innodb update-commit-scale 50 17.218 -2.32% 0.39 outside
norms 16.469 17.218 16.827 0.274
innodb update-scale 50 135.218 +2.89% -4.02 outside
norms 135.218 144.882 139.238 3.271
innodb write 50 230.453 +3.22% -7.67 outside
norms 230.296 246.252 238.121 6.541
innodb write-commit 50 102.135 +3.47% -3.67 within
norms 100.438 109.854 105.801 3.782
innodb write-commit-scale 50 51.221 +3.10% -1.64 outside
norms 50.720 54.335 52.860 1.556
innodb write-scale 50 115.380 +3.73% -4.48 within
norms 114.072 126.072 119.855 4.515
======================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 6.325 -0.53% 0.03 within
norms 6.103 6.363 6.291 0.056
blackhole guid_bh 50 12.272 +0.69% -0.09 within
norms 12.180 12.597 12.357 0.093
blackhole write-scale_bh 50 6.021 -0.05% 0.00 within
norms 5.889 6.111 6.018 0.053
blackhole write_bh 50 11.845 +0.27% -0.03 within
norms 11.636 12.006 11.877 0.101
innodb guid 50 240.930 +3.95% -9.92 within
norms 234.998 272.666 250.846 11.842
innodb guid-scale 50 120.802 +4.02% -5.06 within
norms 116.716 139.583 125.858 6.421
innodb key 50 21.353 -2.19% 0.46 outside
norms 19.915 21.429 20.896 0.372
innodb key-scale 50 10.911 +1.06% -0.12 within
norms 10.506 11.543 11.028 0.228
innodb mixed 50 125.963 +5.74% -7.67 outside
norms 123.268 146.800 133.631 7.619
innodb mixed-commit 50 64.218 +4.41% -2.96 outside
norms 63.405 73.361 67.181 2.463
innodb mixed-commit-scale 50 32.487 +2.45% -0.82 within
norms 31.331 36.888 33.302 1.120
innodb mixed-scale 50 63.221 +5.12% -3.41 within
norms 61.871 74.241 66.634 3.956
innodb scan 50 86.358 -1.09% 0.93 within
norms 84.298 88.410 85.423 1.015
innodb scan-scale 50 43.803 -0.70% 0.31 within
norms 42.875 44.785 43.498 0.443
innodb update 50 273.886 +4.78% -13.76 outside
norms 272.267 321.605 287.649 12.527
innodb update-commit 50 32.986 +1.48% -0.49 outside
norms 32.924 34.598 33.480 0.457
innodb update-commit-scale 50 17.218 -1.91% 0.32 outside
norms 16.147 17.563 16.895 0.316
innodb update-scale 50 135.218 +4.70% -6.66 outside
norms 132.322 157.605 141.879 6.017
innodb write 50 230.453 +3.95% -9.49 within
norms 223.560 263.805 239.942 12.489
innodb write-commit 50 102.135 +4.66% -4.99 outside
norms 100.438 115.893 107.122 4.764
innodb write-commit-scale 50 51.221 +4.42% -2.37 within
norms 50.504 57.503 53.588 2.486
innodb write-scale 50 115.380 +3.64% -4.36 within
norms 110.254 130.899 119.739 6.557
======================================================================================================================
TRENDING OVER ALL runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 6.325 -0.990 0.060 outside
norms 6.103 6.363 6.263 0.051
blackhole guid_bh 50 12.272 0.280 -0.030 within
norms 12.114 12.597 12.306 0.085
blackhole write-scale_bh 50 6.021 -0.220 0.010 within
norms 5.863 6.111 6.008 0.052
blackhole write_bh 50 11.845 -0.010 0.000 within
norms 11.628 12.014 11.844 0.097
innodb guid 50 240.930 3.960 -9.940 within
norms 232.232 272.666 250.871 12.496
innodb guid-scale 50 120.802 4.010 -5.050 within
norms 115.437 139.583 125.850 6.402
innodb key 50 21.353 -2.760 0.570 outside
norms 19.915 21.429 20.780 0.316
innodb key-scale 50 10.911 0.080 -0.010 within
norms 10.374 11.543 10.919 0.214
innodb mixed 50 125.963 5.680 -7.590 outside
norms 123.054 146.800 133.555 7.393
innodb mixed-commit 50 64.218 4.770 -3.210 outside
norms 63.405 73.361 67.431 1.904
innodb mixed-commit-scale 50 32.487 2.060 -0.680 within
norms 30.593 36.888 33.171 1.140
innodb mixed-scale 50 63.221 5.280 -3.520 within
norms 60.925 74.241 66.743 3.763
innodb scan 50 86.358 -0.970 0.830 within
norms 84.137 93.263 85.527 1.301
innodb scan-scale 50 43.803 -0.490 0.210 within
norms 42.805 47.459 43.590 0.685
innodb update 50 273.886 4.120 -11.760 outside
norms 268.017 321.605 285.650 9.908
innodb update-commit 50 32.986 2.590 -0.880 outside
norms 32.449 35.541 33.862 0.687
innodb update-commit-scale 50 17.218 -1.720 0.290 within
norms 16.147 17.684 16.927 0.355
innodb update-scale 50 135.218 4.310 -6.100 outside
norms 132.322 157.605 141.316 4.803
innodb write 50 230.453 -1,820.120 218.450 outside
norms 11.899 12.105 12.002 0.103
innodb write-commit 50 102.135 4.600 -4.920 outside
norms 98.069 115.893 107.054 4.666
innodb write-commit-scale 50 51.221 3.580 -1.900 within
norms 48.449 57.503 53.121 2.391
innodb write-scale 50 115.380 -1,800.670 109.310 outside
norms 6.061 6.080 6.071 0.010
======================================================================================================================
FULL REVISION COMMENTARY:
1309.1.19: Brian Aker 2010-02-28 [merge] Merge Stewart.
1313.1.36: Stewart Smith 2010-03-01 remove unused SCROLL_EXTRA define. n...
1313.1.35: Stewart Smith 2010-03-01 remove now unused SCALE_SEC and SCAL...
1313.1.34: Stewart Smith 2010-03-01 remove unused MEM_ROOT_BLOCK_SIZE an...
1313.1.33: Stewart Smith 2010-03-01 remove unused PROGDIR define
1313.1.32: Stewart Smith 2010-03-01 remove unused and strange LIBLEN def...
1313.1.31: Stewart Smith 2010-03-01 remove unused SHOW_LOG_STATUS_FREE a...
1313.1.30: Stewart Smith 2010-03-01 remove unused f_packtype() macro.
1313.1.29: Stewart Smith 2010-03-01 remove unused MAXGTRIDSIZE and MAXBQ...
1313.1.28: Stewart Smith 2010-03-01 remove #undef remove. We do totally ...
1313.1.27: Stewart Smith 2010-03-01 remove now unused MY_I_S_MAYBE_NULL ...
1313.1.26: Stewart Smith 2010-03-01 remove unused IS_EQUAL_NO, IS_EQUAL_...
1313.1.25: Stewart Smith 2010-03-01 remove some Insane Clown Posse defin...
1313.1.24: Stewart Smith 2010-03-01 remove unused HA_NOT_DELETE_WITH_CAC...
1313.1.23: Stewart Smith 2010-03-01 remove unused FIELD_NAME_USED and FI...
1313.1.22: Stewart Smith 2010-03-01 remove unused FERR define. we just u...
1313.1.21: Stewart Smith 2010-03-01 remove unused CREATE_MODE define.
1313.1.20: Stewart Smith 2010-03-01 remove unused MIN_ROWS_TO_USE_BULK_I...
1313.1.19: Stewart Smith 2010-03-01 TABLE_OPEN_CACHE_MIN should be used ...
1313.1.18: Stewart Smith 2010-03-01 remove unused macros: TRANS_ALLOC_BL...
1313.1.17: Stewart Smith 2010-03-01 remove unused TEMP_POOL_SIZE define.
1313.1.16: Stewart Smith 2010-03-01 move COLUMN_FORMAT_FLAGS define so i...
1313.1.15: Stewart Smith 2010-03-01 remove unused COLUMN_FORMAT_SHIFT #d...
1313.1.14: Stewart Smith 2010-03-01 remove old and unused ME_INFO #defin...
1313.1.13: Stewart Smith 2010-03-01 remove unused mysys my_b_get_buffer_...
1313.1.12: Stewart Smith 2010-03-01 remove unused mysys #define for MY_P...
1313.1.11: Stewart Smith 2010-03-01 remove now unused mysys #define ME_H...
1313.1.10: Stewart Smith 2010-03-01 remove some unused mysys #defines ab...
1313.1.9: Stewart Smith 2010-03-01 remove unused mysys ME_WAITTOT macro....
1313.1.8: Stewart Smith 2010-03-01 remove unused ME_NOCUR define... some...
1313.1.7: Stewart Smith 2010-03-01 remove unused string2decimal_fixed() ...
1313.1.6: Stewart Smith 2010-03-01 remove unused HA_STATE_BUFF_SAVED define
1313.1.5: Stewart Smith 2010-03-01 remove unused HA_STATE_NO_KEY define
1313.1.4: Stewart Smith 2010-03-01 remove unused QUICK_USED define... so...
1313.1.3: Stewart Smith 2010-03-01 remove unused MBR_DATA define. not re...
1313.1.2: Stewart Smith 2010-03-01 remove unused HA_KEYFLAG_MASK macro
1313.1.1: Stewart Smith 2010-03-01 remove unused HA_MAX_KEYTYPE macro
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp