====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test2
RUN ID: 545
RUN DATE: 2011-01-21T08:19:24.932171
WORKLOAD: innodb_1000K_readwrite
SERVER: drizzled
VERSION: staging
REVISION: 2100
COMMENT: 2100: Lee Bieber 2011-01-21 [merge] Merge Stewart - Fix bug 664222:
DDL operations have an implicit commit
====================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1719.55 -0.38% -6.58 1690.47 1757.12 1726.14
19.07
32 1937.25 -2.41% -47.80 1926.23 2045.24 1985.05
35.99
64 1385.82 -1.65% -23.27 1376.58 1468.22 1409.09
28.93
128 1064.06 -0.12% -1.26 1056.17 1076.96 1065.31
5.40
256 904.60 +2.89% 25.43 847.96 911.52 879.18
18.62
512 624.86 -0.08% -0.51 618.18 634.92 625.37
4.79
1024 405.85 +0.78% 3.15 395.63 407.32 402.70
3.55
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1719.55 +5.31% 86.64 1165.54 1768.07 1632.91
196.75
32 1937.25 -0.52% -10.07 1576.30 2110.89 1947.32
147.52
64 1385.82 -2.19% -31.07 1322.51 1477.23 1416.89
33.82
128 1064.06 -1.30% -14.04 1020.28 1157.26 1078.10
29.71
256 904.60 +2.45% 21.64 808.85 923.97 882.96
26.68
512 624.86 -0.47% -2.98 611.90 647.17 627.84
6.88
1024 405.85 +0.67% 2.72 395.43 408.81 403.13
3.39
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1719.55 +0.79% 13.47 1165.54 1869.76 1706.09
71.54
32 1937.25 -3.89% -78.40 1101.01 2395.61 2015.65
156.26
64 1385.82 -4.23% -61.21 899.67 1721.72 1447.03
82.03
128 1064.06 -3.28% -36.09 638.89 1345.78 1100.14
68.63
256 904.60 +1.58% 14.04 808.85 1034.59 890.57
32.96
512 624.86 -0.33% -2.04 593.30 781.01 626.90
32.89
1024 405.85 +0.37% 1.49 361.44 487.49 404.36
20.73
====================================================================================================
FULL REVISION COMMENTARY:
2099.1.3: Lee Bieber 2011-01-21 [merge] Merge Stewart - Fix bug 664222: DDL
operations have an implicit commit
1890.2.53: Stewart Smith 2011-01-21 [merge] merge trunk
1890.2.52: Stewart Smith 2011-01-07 add test for EXECUTE WAIT doing DDL
that will actually do the DDL - run a COMMIT first.
1890.2.51: Stewart Smith 2011-01-07 revert patch that changed EXECUTE to
use AUTOCOMMIT=0 instead of START TRANSACTION. Of course, this means that you
cannot do DDL inside EXECUTE, so change the test and result for execute_wait
test which did that.
1890.2.50: Stewart Smith 2011-01-06 [merge] merge trunk
1890.2.49: Stewart Smith 2011-01-04 error out on DROP INDEX inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED.
1890.2.48: Stewart Smith 2011-01-04 error out on CREATE INDEX inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED.
1890.2.47: Stewart Smith 2011-01-04 statement_boundaries test relied on
implicit commits in schema operations. use explicit commits instead
1890.2.46: Stewart Smith 2011-01-04 add test for DROP SCHEMA inside a txn
erroring out
1890.2.45: Stewart Smith 2011-01-04 error out on DROP SCHEMA inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED. You may have been mistaken
that this would previously error out on ER_LOCK_OR_ACTIVE_TRANSACTION. It
didn't.
1890.2.44: Stewart Smith 2011-01-04 error out on ALTER SCHEMA inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED. Previously this would be
ER_LOCK_OR_ACTIVE_TRANSACTION which isn't exactly correct or consistent with
others.
1890.2.43: Stewart Smith 2011-01-04 add test for CREATE SCHEMA inside a txn
erroring out
1890.2.42: Stewart Smith 2011-01-04 error out on CREATE SCHEMA inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED
1890.2.41: Stewart Smith 2011-01-04 innobase innodb test relied on implicit
commits in TRUNCATE TABLE and RENAME TABLE. use explicit commits instead
1890.2.40: Stewart Smith 2011-01-04 error out on RENAME TABLE inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED
1890.2.39: Stewart Smith 2011-01-04 error out on TRUNCATE TABLE inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED
1890.2.38: Stewart Smith 2011-01-04 change EXECUTE to use SET AUTOCOMMIT=0
instead of START TRANSACTION as this continues to allow us to execute DDL using
EXECUTE as we won't have an ongoing transaction to cause us to error out....
although if we're running any other statement, we will start a transaction.
neat trick(tm)
1890.2.37: Stewart Smith 2011-01-04 update Transactional DDL not supported
error number
1890.2.36: Stewart Smith 2011-01-04 fix merge conflict that was accidently
committed
1890.2.35: Stewart Smith 2011-01-04 add ddl_transactions to list of default
test suites
1890.2.34: Stewart Smith 2011-01-04 [merge] merge run-more-suites (incl
trunk
1890.2.33: Stewart Smith 2011-01-04 add a small test suite for DDL
transactions (i.e. that we get an error when doing them
1890.2.32: Stewart Smith 2011-01-04 innobase innodb test relied on implicit
commit in ALTER TABLE. use explicit commit instead
1890.2.31: Stewart Smith 2011-01-04 myisam mix2 test relied on implicit
commit in ALTER TABLE. use explicit commit instead
1890.2.30: Stewart Smith 2011-01-04 throw
ER_TRANSACTIONAL_DDL_NOT_SUPPORTED in ALTER TABLE if there is an ongoing txn
1890.2.29: Stewart Smith 2010-12-29 use explicit commit in
haildb.trx_isolation_serializable test instead of implicit commit in DROP TABLE
1890.2.28: Stewart Smith 2010-12-29 use explicit commit in
haildb.trx_isolation_repeatable_read test instead of implicit commit in DROP
TABLE
1890.2.27: Stewart Smith 2010-12-29 use explicit commit in
haildb.trx_isolation_read_uncommitted test instead of implicit commit in DROP
TABLE
1890.2.26: Stewart Smith 2010-12-29 use explicit commit in
storage_engine_apI_tester.transaction test instead of implicit commit in DROP
TABLE
1890.2.25: Stewart Smith 2010-12-29 use explicit COMMIT in
transaction_log.auto_commit test instead of implicit commit in DROP TABLE
1890.2.24: Stewart Smith 2010-12-29 use explicit COMMIT in innodb_bug51920
test intesad of implicit commit in DROP TABLE
1890.2.23: Stewart Smith 2010-12-29 use explicit COMMIT in innodb_bug53674
test intesad of implicit commit in DROP TABLE
1890.2.22: Stewart Smith 2010-12-29 use explicit COMMIT in innodb test
intesad of implicit commit in DROP TABLE
1890.2.21: Stewart Smith 2010-12-29 use explicit COMMIT in
innodb-semi-consistent test intesad of implicit commit in DROP TABLE
1890.2.20: Stewart Smith 2010-12-29 use explicit COMMIT in
trx_isolation_read_committed test instead of implicit commit in DROP TABLE
1890.2.19: Stewart Smith 2010-12-29 use explicit COMMIT in transaction test
instead of implicit commit in DROP TABLE
1890.2.18: Stewart Smith 2010-12-29 use explicit COMMIT in
statement_boundaries test instead of relying on implicit COMMIT in DROP TABLE
statement
1890.2.17: Stewart Smith 2010-12-29 use explicit COMMITs in savepoints test
instead of implicit COMMITs in DROP TABLE statement
1890.2.16: Stewart Smith 2010-12-29 use explicit COMMIT in randgen_queries
test instead of implicit COMMIt in DROP TABLE
1890.2.15: Stewart Smith 2010-12-29 make insert test use an explicit commit
instead of an implicit one in DROP TABLE
1890.2.14: Stewart Smith 2010-12-29 update flush_block_commit test to use
an explicit COMMIT instead of the implicit one in DROP TABLE
1890.2.13: Stewart Smith 2010-12-29 error out with
ER_TRANSACTIONAL_DDL_NOT_SUPPORTED in DROP TABLE if there is an ongoing
transaction.
1890.2.12: Stewart Smith 2010-12-29 update docs on Transactional DDL support
1890.2.11: Stewart Smith 2010-12-29 use explicit COMMIT in innobase
unsafe_binlog test
1890.2.10: Stewart Smith 2010-12-29 use explicit commit in innodb_mysql
test instead of implicit in CREATE TABLE
1890.2.9: Stewart Smith 2010-12-29 innobase.innodb test: use explicit
COMMIT instead of relying on implicit commit in CREATE TABLE
1890.2.8: Stewart Smith 2010-12-29 transaction log test: use explicit
COMMIT instead of relying on implicit in CREATE TABLE
1890.2.7: Stewart Smith 2010-12-29 select_in_null test was attempting DDL
inside txn. remove begin/commit as it's not needed anyway
1890.2.6: Stewart Smith 2010-12-29 insert.test was setting autocommit=0 but
not resetting it. really we just wanted a txn for bulk loading, which we had
anyway. remove the set
1890.2.5: Stewart Smith 2010-12-29 SET AUTOCOMMIT=1 was not completely
performing a COMMIT
1890.2.4: Stewart Smith 2010-12-29 remove unneeded and incorrectly added
errname.cc.THIS
1890.2.3: Stewart Smith 2010-12-29 [merge] merge fixing test-run --gdb
1890.2.2: Stewart Smith 2010-12-29 [merge] merge trunk
1890.2.1: Stewart Smith 2010-11-01 add error message for Transactional DDL
not being supported. Throw it in CREATE TABLE instead of implicit commit.
2099.1.2: Lee Bieber 2011-01-21 Add BSD copyright file to win32/config.h
2099.1.1: Lee Bieber 2011-01-20 [merge] Merge Brian - cleanup
user_locks.kill_wait test
2098.2.1: Brian Aker 2011-01-20 Fix lcov issue.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
