====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n01.wc1.dfw1.stabletransit.com
RUN ID: 905
RUN DATE: 2011-02-10T16:23:52.555839
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 1874.14 +1.69% 31.22 1769.46 1887.70 1842.92
32.01
32 2427.70 +0.68% 16.48 2268.00 2514.86 2411.22
85.47
64 2599.55 +0.08% 2.07 2553.04 2628.20 2597.48
23.70
128 2568.69 -0.40% -10.23 2544.27 2611.41 2578.92
20.97
256 2555.93 -0.65% -16.75 2549.07 2599.30 2572.68
12.47
512 2329.93 +0.51% 11.82 2297.34 2333.18 2318.11
10.04
1024 1380.04 -2.72% -38.55 1363.11 1552.06 1418.58
57.33
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1874.14 +1.90% 34.94 1744.57 1914.70 1839.20
37.04
32 2427.70 +0.29% 7.11 2250.06 2548.17 2420.60
80.19
64 2599.55 +1.17% 30.12 2451.33 2628.20 2569.43
42.57
128 2568.69 +0.31% 7.87 2464.78 2620.90 2560.82
29.48
256 2555.93 -0.15% -3.86 2502.80 2599.30 2559.80
25.42
512 2329.93 +0.74% 17.08 2282.31 2346.61 2312.85
14.43
1024 1380.04 -1.71% -23.98 1329.92 1552.06 1404.01
44.86
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1874.14 -5.75% -114.31 1709.73 2233.42 1988.45
120.99
32 2427.70 -7.01% -183.06 2010.47 2909.92 2610.76
157.06
64 2599.55 -2.31% -61.51 2191.91 2998.80 2661.05
167.64
128 2568.69 -2.70% -71.41 2107.33 2911.98 2640.10
124.61
256 2555.93 +1.15% 28.94 2174.91 2691.02 2527.00
82.27
512 2329.93 +16.58% 331.44 1301.49 2470.12 1998.49
451.32
1024 1380.04 -9.34% -142.19 1251.35 1866.15 1522.23
171.91
====================================================================================================
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
