====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: Drizzle-build-n03
RUN ID: 143
RUN DATE: 2011-03-17T23:32:54.326015
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 2345.58 +1.17% 27.18 2282.27 2372.30 2318.39
24.63
32 2609.20 +0.25% 6.59 2512.59 2661.37 2602.61
42.76
64 2688.48 +0.12% 3.23 2630.15 2761.85 2685.25
38.88
128 2597.64 +0.38% 9.96 2555.18 2610.92 2587.67
18.44
256 2359.27 -0.42% -9.98 2349.75 2395.24 2369.25
14.64
512 1937.28 -0.15% -2.90 1919.37 1958.45 1940.18
11.62
1024 1325.37 -1.74% -23.53 1308.93 1384.37 1348.90
24.50
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2345.58 +1.15% 26.66 2223.42 2416.25 2318.91
46.73
32 2609.20 +0.31% 8.08 2478.49 2716.22 2601.12
52.18
64 2688.48 +1.54% 40.64 2534.79 2761.85 2647.84
58.58
128 2597.64 +0.35% 9.18 2555.18 2620.97 2588.46
16.67
256 2359.27 -0.16% -3.79 2324.95 2399.72 2363.06
21.66
512 1937.28 +0.31% 6.07 1890.60 1962.57 1931.21
15.65
1024 1325.37 -1.07% -14.31 1284.35 1384.37 1339.68
24.03
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2345.58 +1.35% 31.15 2171.92 2454.02 2314.43
49.21
32 2609.20 +0.75% 19.49 2290.10 2769.48 2589.71
91.34
64 2688.48 +0.58% 15.43 2489.95 2831.41 2673.05
58.03
128 2597.64 -0.35% -9.22 2531.85 2725.58 2606.86
40.04
256 2359.27 -0.90% -21.49 2302.55 2500.38 2380.76
43.09
512 1937.28 -0.61% -11.87 1879.21 2051.13 1949.15
39.57
1024 1325.37 -1.47% -19.83 1239.79 1445.26 1345.20
38.71
====================================================================================================
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
