====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: Drizzle-build-n03
RUN ID: 64
RUN DATE: 2011-02-10T21:17:41.341732
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 2338.79 +1.89% 43.27 2208.50 2391.12 2295.52
53.92
32 2634.41 +1.32% 34.43 2516.93 2676.73 2599.98
49.01
64 2542.83 -4.62% -123.29 2537.93 2764.73 2666.12
74.54
128 2610.70 +0.38% 9.84 2540.89 2638.15 2600.86
30.67
256 2394.64 +0.29% 6.84 2362.94 2404.84 2387.79
14.49
512 1974.95 +0.42% 8.29 1912.33 1999.97 1966.66
27.38
1024 1416.50 +1.84% 25.55 1349.35 1417.48 1390.95
20.74
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2338.79 +0.83% 19.15 2208.50 2438.74 2319.64
51.70
32 2634.41 +0.42% 10.94 2392.11 2757.13 2623.48
79.99
64 2542.83 -5.38% -144.59 2535.41 2831.41 2687.41
76.16
128 2610.70 -0.79% -20.74 2531.85 2699.14 2631.44
45.42
256 2394.64 -0.79% -19.02 2338.43 2473.93 2413.66
36.21
512 1974.95 -0.57% -11.36 1912.33 2042.81 1986.31
32.92
1024 1416.50 +5.55% 74.53 1239.79 1417.48 1341.97
42.67
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2338.79 +0.64% 14.92 2200.04 2454.02 2323.87
51.03
32 2634.41 +0.84% 21.90 2342.44 2769.48 2612.51
93.08
64 2542.83 -5.54% -149.27 2535.41 2831.41 2692.10
61.59
128 2610.70 -0.70% -18.32 2531.85 2725.58 2629.02
46.40
256 2394.64 -0.58% -13.92 2304.16 2500.38 2408.55
46.17
512 1974.95 -0.15% -3.05 1906.66 2051.13 1978.00
37.91
1024 1416.50 +4.08% 55.55 1239.79 1433.76 1360.95
41.43
====================================================================================================
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