====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test2
RUN ID: 723
RUN DATE: 2011-03-17T23:54:46.948644
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 1717.08 -0.09% -1.50 1685.29 1748.51 1718.58
14.32
32 2022.82 +3.70% 72.19 1885.37 2046.91 1950.64
59.47
64 1343.30 -2.19% -30.09 1330.45 1419.76 1373.39
31.94
128 1075.40 -0.00% 0.00 1072.03 1079.50 1075.40
3.09
256 873.04 -0.00% 0.00 864.36 884.78 873.04
8.61
512 612.70 +0.00% 0.00 609.96 618.09 612.70
3.81
1024 401.90 -0.00% 0.00 400.56 404.36 401.90
1.74
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1717.08 -0.33% -5.72 1670.79 1765.58 1722.80
21.63
32 2022.82 +3.09% 60.65 1884.77 2049.55 1962.17
41.21
64 1343.30 -4.71% -66.37 1330.45 1492.80 1409.66
34.21
128 1075.40 +0.01% 0.09 1024.87 1133.78 1075.31
32.77
256 873.04 -0.95% -8.33 853.07 927.71 881.37
15.91
512 612.70 -0.56% -3.44 596.94 631.88 616.14
6.47
1024 401.90 +0.98% 3.90 386.31 404.36 398.00
3.81
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1717.08 +5.09% 83.18 893.86 1869.76 1633.90
242.10
32 2022.82 +5.22% 100.38 1034.28 2395.61 1922.44
297.13
64 1343.30 -6.11% -87.45 878.49 1721.72 1430.75
85.90
128 1075.40 +2.10% 22.15 613.33 1345.78 1053.25
142.46
256 873.04 +3.05% 25.84 449.38 1034.59 847.20
130.62
512 612.70 +2.94% 17.48 311.90 781.01 595.22
96.06
1024 401.90 +4.80% 18.42 198.22 487.49 383.48
63.19
====================================================================================================
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
