====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test2
RUN ID: 615
RUN DATE: 2011-02-10T21:35:53.074514
WORKLOAD: innodb_1000K_readonly
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 1126.12 -1.02% -11.57 1118.67 1158.65 1137.68
13.42
32 1294.79 -5.30% -72.39 1291.67 1418.90 1367.18
42.42
64 1694.68 -0.35% -5.94 1476.29 1808.39 1700.62
82.73
128 981.81 +21.76% 175.49 738.03 1097.07 806.32
99.88
256 559.52 +0.53% 2.97 549.38 561.44 556.55
3.97
512 381.87 -0.52% -2.01 381.09 387.92 383.88
1.89
1024 245.53 -0.71% -1.76 245.39 250.34 247.29
1.56
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1126.12 -37.59% -678.20 1116.32 2220.91 1804.31
491.49
32 1294.79 -37.96% -792.09 1291.67 2578.90 2086.88
526.55
64 1694.68 -1.91% -33.08 1476.29 1820.73 1727.76
57.99
128 981.81 -21.42% -267.65 738.03 1505.87 1249.46
278.80
256 559.52 -40.14% -375.14 549.38 1183.38 934.66
277.69
512 381.87 -38.14% -235.39 381.09 759.21 617.26
171.11
1024 245.53 -38.89% -156.23 244.45 494.76 401.77
113.69
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1126.12 -47.24% -1008.26 1087.27 2406.76 2134.38
214.40
32 1294.79 -47.34% -1164.14 1291.67 3117.60 2458.93
256.16
64 1694.68 -3.72% -65.43 1476.29 2113.34 1760.11
88.12
128 981.81 -31.53% -452.19 738.03 1743.39 1434.00
125.49
256 559.52 -50.84% -578.54 549.38 1429.83 1138.06
113.03
512 381.87 -49.21% -369.98 381.09 1042.59 751.85
81.14
1024 245.53 -49.74% -242.95 244.45 590.95 488.48
44.46
====================================================================================================
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
