====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n01.wc1.dfw1.stabletransit.com
RUN ID: 990
RUN DATE: 2011-03-17T19:41:44.101099
WORKLOAD: innodb_1000K_readonly
SERVER: drizzled
VERSION: staging
REVISION: 2241
COMMENT: 2241: Lee Bieber 2011-03-17 [merge] Merge Stewart - 728855: BLOB
column can have default '' (empty string) in CREATE TABLE but not ALTER TABLE
ALTER
====================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1812.82 -0.12% -2.26 1770.98 1871.52 1815.08
27.33
32 2479.45 +1.23% 30.22 2357.74 2505.91 2449.22
39.97
64 2550.50 -0.37% -9.58 2476.67 2657.35 2560.08
48.44
128 2518.01 -1.29% -32.92 2510.95 2607.09 2550.93
26.86
256 2503.16 -0.04% -0.88 2465.67 2533.69 2504.04
23.37
512 2204.46 -0.32% -7.02 2180.71 2241.07 2211.48
19.72
1024 1124.55 -2.83% -32.72 1111.11 1205.15 1157.27
32.22
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1812.82 +0.13% 2.39 1686.21 1882.70 1810.43
43.16
32 2479.45 +2.49% 60.12 2261.27 2505.91 2419.32
60.08
64 2550.50 +0.71% 18.08 2445.38 2657.35 2532.42
49.50
128 2518.01 -0.57% -14.42 2475.97 2607.09 2532.44
29.77
256 2503.16 +0.21% 5.18 2439.01 2533.69 2497.98
23.36
512 2204.46 -0.11% -2.41 2163.74 2241.07 2206.87
18.90
1024 1124.55 -3.47% -40.44 1109.96 1232.76 1164.99
34.61
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1812.82 -8.13% -160.53 1686.21 2233.42 1973.35
125.37
32 2479.45 -4.43% -115.00 2010.47 2909.92 2594.45
160.21
64 2550.50 -3.75% -99.24 2191.91 2998.80 2649.74
164.91
128 2518.01 -4.31% -113.35 2107.33 2911.98 2631.36
122.60
256 2503.16 -0.90% -22.72 2174.91 2691.02 2525.88
79.17
512 2204.46 +9.09% 183.65 1301.49 2470.12 2020.81
436.47
1024 1124.55 -24.35% -361.88 1097.51 1866.15 1486.43
187.05
====================================================================================================
FULL REVISION COMMENTARY:
2240.1.3: Lee Bieber 2011-03-17 [merge] Merge Stewart - 728856: CREATE TABLE
t1 (a int default 'aoeu'); succeeds
2221.12.14: Stewart Smith 2011-03-17 [merge] merge the cherrypick of bug
728856 into elliott
2221.12.13: Stewart Smith 2011-03-17 [merge] merge elliot
2221.12.12: Stewart Smith 2011-03-17 check for error in converting
default_value to Item in default_value_item(). This means that INT DEFAULT
'aoeu' will properly error out.
2221.12.11: Stewart Smith 2011-03-15 [merge] merge trunk
2221.12.10: Stewart Smith 2011-03-11 fix bug 728856 result file
2221.12.9: Stewart Smith 2011-03-11 [merge] merge trunk
2221.12.8: Stewart Smith 2011-03-07 fix logic for ON UPDATE for TEMPSTAMP
columns in CreateField::setDefaultValue in ALTER TABLE SET DEFAULT code path
(as we're modifying existing CreateField, not just creating one
2221.12.7: Stewart Smith 2011-03-07 in ALTER TABLE SET DEFAULT code path,
use the new CreateField::setDefaultValue method - this means we have the same
logic for setting default values for a CreateField as in CREATE TABLE
2221.12.6: Stewart Smith 2011-03-07 add test for bug lp:728855 - ALTER
TABLE SET DEFAULT '' for a blob column should work (it does in CREATE TABLE).
Currently fails.
2221.12.5: Stewart Smith 2011-03-07 factor out setting default value out
from CreatField::init and into new CreateField::setDefaultValue. This also
means we fix up a error message to be correct in type_blob.
2221.12.4: Stewart Smith 2011-03-07 fix ER_TOO_BIG_FIELDLENGTH error
message to always be number of characters, not sometimes number of bytes
2221.12.3: Stewart Smith 2011-03-07 add a test case for CREATE TABLE with
auto_increment on a decimal column (which isn't supported).
2221.12.2: Stewart Smith 2011-03-07 add a test case for some CREATE TABLE
errors around ER_TOO_BIG_FIELDWIDTH - turns out we had only 1
2240.1.2: Lee Bieber 2011-03-17 [merge] Merge Stewart - 728855: BLOB column
can have default '' (empty string) in CREATE TABLE but not ALTER TABLE ALTER
2239.3.3: Stewart Smith 2011-03-17 merge bug 728856 fix
2239.3.2: Stewart Smith 2011-03-17 merge bug 728856 result file fix
2239.3.1: Stewart Smith 2011-03-17 [merge] merge test for bug 728856
2221.12.1: Stewart Smith 2011-03-07 add test for bug 728856, CREATE TABLE
t1 (a int default 'foo'); succeeds. This is a bug somewhere in the
CreateField/CREATE TABLE logic of not checking type of the default value
provided
2240.1.1: Lee Bieber 2011-03-17 [merge] Merge Stewart - dbqp source (and all
its libs) should use emacs python mode, not emacs C mode
2235.5.2: Stewart Smith 2011-03-17 dbqp source (and all its libs) should
use emacs python mode, not emacs C mode
2235.5.1: Stewart Smith 2011-03-17 dbqp source should use emacs python
mode, not emacs C mode
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
