====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID: 1012
RUN DATE: 2011-03-17T19:41:54.469555
WORKLOAD: innodb_1000K_readwrite
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 1346.77 +0.56% 7.52 1303.58 1368.67 1339.25
21.33
32 1515.46 -1.14% -17.53 1374.00 1621.10 1532.99
82.12
64 1703.38 +4.46% 72.69 1545.42 1732.67 1630.70
52.93
128 1709.87 +0.20% 3.44 1628.51 1750.14 1706.44
40.48
256 1691.26 +0.81% 13.63 1632.04 1711.85 1677.63
23.60
512 1465.80 -0.52% -7.73 1446.76 1496.36 1473.53
12.39
1024 885.58 -2.68% -24.40 883.75 949.11 909.98
20.01
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1346.77 +1.05% 14.00 1268.38 1376.80 1332.77
26.10
32 1515.46 -3.07% -47.93 1374.00 1666.87 1563.39
61.27
64 1703.38 +4.44% 72.47 1448.84 1732.67 1630.92
51.09
128 1709.87 +1.12% 18.87 1604.37 1750.14 1691.00
34.33
256 1691.26 +1.28% 21.31 1632.04 1711.85 1669.95
16.60
512 1465.80 -0.42% -6.16 1430.89 1500.88 1471.96
15.44
1024 885.58 -2.74% -24.99 859.21 953.16 910.57
24.06
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1346.77 +3.39% 44.22 345.67 1503.03 1302.56
75.17
32 1515.46 -5.27% -84.23 616.39 1870.18 1599.69
117.90
64 1703.38 -1.47% -25.46 978.24 2059.46 1728.85
138.92
128 1709.87 -4.00% -71.27 1289.29 2051.37 1781.15
109.97
256 1691.26 -0.88% -15.03 1223.81 1824.49 1706.29
64.34
512 1465.80 +6.36% 87.65 661.33 1554.29 1378.15
172.86
1024 885.58 -16.56% -175.70 859.21 1143.07 1061.28
49.27
====================================================================================================
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
