====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test1
RUN ID: 39
RUN DATE: 2011-03-17T23:34:50.192418
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 2228.28 +3.03% 65.53 2090.23 2241.55 2162.75
42.45
32 2392.69 -0.77% -18.46 2307.04 2543.96 2411.16
70.50
64 1751.74 +2.08% 35.69 1675.65 1758.75 1716.05
24.61
128 1378.19 -2.87% -40.75 1369.08 1465.81 1418.94
32.89
256 1153.33 +0.78% 8.93 1110.62 1182.96 1144.40
20.33
512 734.45 -1.17% -8.67 733.21 761.40 743.12
9.30
1024 485.59 -0.18% -0.85 477.57 493.64 486.44
4.84
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2228.28 +3.52% 75.76 2065.18 2256.68 2152.52
38.17
32 2392.69 +0.08% 1.81 2276.13 2566.42 2390.88
69.85
64 1751.74 +2.37% 40.56 1608.65 1783.76 1711.18
38.58
128 1378.19 -1.99% -28.05 1327.93 1498.50 1406.24
38.38
256 1153.33 +2.78% 31.21 1054.45 1182.96 1122.12
31.78
512 734.45 -0.47% -3.48 724.12 761.40 737.94
9.01
1024 485.59 +0.67% 3.25 471.20 494.29 482.34
5.56
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2228.28 +3.53% 76.06 2065.18 2256.68 2152.22
34.45
32 2392.69 +0.45% 10.63 2262.47 2566.42 2382.06
59.51
64 1751.74 +2.98% 50.71 1608.65 1783.76 1701.03
38.37
128 1378.19 -2.01% -28.23 1327.93 1498.50 1406.42
34.99
256 1153.33 +3.31% 36.93 1030.78 1182.96 1116.40
30.28
512 734.45 -0.49% -3.58 715.51 761.40 738.03
9.66
1024 485.59 +0.78% 3.77 471.20 494.29 481.82
4.95
====================================================================================================
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
