====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test2
RUN ID: 616
RUN DATE: 2011-02-10T23:17:10.078429
WORKLOAD: innodb_1000K_readwrite
SERVER: drizzled
VERSION: staging
REVISION: 2155
COMMENT: 2155: Lee Bieber 2011-02-10 [merge] Merge Patrick - 715885: dbqp
needs to return non-zero if tests fail
====================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 912.89 -0.13% -1.21 893.86 930.01 914.10
9.68
32 1086.45 -0.72% -7.86 1034.28 1151.51 1094.32
41.99
64 1386.60 -0.63% -8.75 1335.15 1439.87 1395.35
29.53
128 680.99 +3.72% 24.45 619.62 716.67 656.54
27.29
256 460.49 -0.79% -3.67 456.67 472.36 464.16
5.11
512 322.95 +1.12% 3.59 316.37 324.90 319.36
2.35
1024 201.39 -0.87% -1.76 201.14 206.25 203.15
1.59
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 912.89 -37.88% -556.66 893.86 1762.20 1469.55
377.53
32 1086.45 -36.60% -627.18 1034.28 2100.27 1713.63
418.88
64 1386.60 -2.21% -31.40 1335.15 1490.18 1418.01
36.08
128 680.99 -27.41% -257.15 619.62 1128.50 938.14
194.22
256 460.49 -38.92% -293.38 456.67 917.23 753.87
196.60
512 322.95 -38.59% -202.95 316.37 634.33 525.89
140.37
1024 201.39 -40.27% -135.79 201.14 410.50 337.18
91.32
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 912.89 -45.93% -775.44 893.86 1869.76 1688.33
141.39
32 1086.45 -45.44% -904.96 1034.28 2395.61 1991.41
204.46
64 1386.60 -3.93% -56.80 899.67 1721.72 1443.40
79.20
128 680.99 -37.37% -406.38 619.62 1345.78 1087.37
93.92
256 460.49 -47.64% -418.98 456.67 1034.59 879.46
73.86
512 322.95 -47.80% -295.75 316.37 781.01 618.70
57.60
1024 201.39 -49.52% -197.56 201.14 487.49 398.95
37.44
====================================================================================================
FULL REVISION COMMENTARY:
2154.1.3: Lee Bieber 2011-02-10 [merge] Merge Patrick - 715885: dbqp needs to
return non-zero if tests fail
2151.8.3: patrick crews 2011-02-09 Fix to drizzletest output handling
2151.8.2: patrick crews 2011-02-09 change to include.am
2151.8.1: patrick crews 2011-02-09 Updates to allow several dbqp's run run
on one system (via uuid) and fix to return a relevant code post-execution (ie 1
if tests failed or timed out))
2154.1.2: Lee Bieber 2011-02-10 [merge] Merge Stewart - 715539:
(get|set)_session_proc_info() still exists
2151.7.9: Stewart Smith 2011-02-10 switch doing_tablespace_operation to
doingTablespaceOperation and set_doing_tablespace_operation to
setDoingTablespaceOperation
2151.7.8: Stewart Smith 2011-02-10 switch doing_tablespace_operation to
doingTablespaceOperation and set_doing_tablespace_operation to
setDoingTablespaceOperation
2151.7.7: Stewart Smith 2011-02-10 fix Session::tx_isolation to be
getTxIsolation to follow coding style, but look weird
2151.7.6: Stewart Smith 2011-02-10 switch get_sql_command to getSqlCommand
2151.7.5: Stewart Smith 2011-02-09 fix up two uses of session->tx_isolation
to be correct call
2151.7.4: Stewart Smith 2011-02-09 properly encapsulate
Session::Lex->sql_command and stop using (and remove)
session_sql_command(session)
2151.7.3: Stewart Smith 2011-02-09 removes session_tx_isolation() and
replace with Session::tx_isolation()
2151.7.2: Stewart Smith 2011-02-09 properly encapsulate
Session::tablespace_op and stop using (and remove)
session_tablespace_op(session)
2151.7.1: Stewart Smith 2011-02-09 use Session::(get|set)_proc_info instead
of (get|set)_session_proc_info in ARCHIVE engine, which means we can remove the
non-member functions.
2154.1.1: Lee Bieber 2011-02-10 [merge] Merge Stewart - 712843: SAVEPOINT
after rollback due to deadlock with autocommit=off in transaction will call
startTransaction with an existing transaction where one shouldn't exist
2140.2.9: Stewart Smith 2011-02-08 switch default
Statement::isTransactional() to false, have explicit overriding of true where
needed.
2140.2.8: Stewart Smith 2011-02-07 update test result due to changed error
code once the branch that introduced it was merged with trunk
2140.2.7: Stewart Smith 2011-02-07 [merge] merge trunk
2140.2.6: Stewart Smith 2011-02-07 be sure to start a transaction with a
startTransaction call on the first statement when autocommit is OFF. The only
statements that DO NOT do this are a) DDL and b) SELECT without a table (e.g.
SELECT DATABASE() and SHOW STATUS.
2140.2.5: Stewart Smith 2011-02-07 fix SERVER_STATUS_IN_TRANS for rollback
in autocommitOrRollback
2140.2.4: Stewart Smith 2011-02-04 [merge] merge removal of implicit commit
in START TRANSACTION
2140.2.3: Stewart Smith 2011-02-04 reset SEAPITESTER_ERROR_INJECT in test
2140.2.2: Stewart Smith 2011-02-04 change Session::startTransaction() to
assert that there is not already a transaction in progress before starting one
(i.e. NO IMPLICIT COMMIT)
2140.2.1: Stewart Smith 2011-02-04 add test for checking behaviour around
SAVEPOINT with autocommit=off and deadlock caused rollbacks. This is for Bug
lp:712843
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
