====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n01.wc1.dfw1.stabletransit.com
RUN ID: 623
RUN DATE: 2010-11-07T17:36:17.306335
WORKLOAD: innodb_1000K_readonly
SERVER: drizzled
VERSION: staging
REVISION: 1911
COMMENT: 1911: Lee Bieber 2010-11-07 [merge] Merge Stewart - including
adapting and expanding the "differences from mysql" page from the wiki.
====================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1923.92 -0.96% -18.67 1896.95 1988.19 1942.58
27.60
32 2561.37 -0.68% -17.44 2545.85 2602.22 2578.81
18.01
64 2578.53 -0.30% -7.65 2556.34 2622.57 2586.19
19.69
128 2591.69 -0.57% -14.76 2585.52 2631.54 2606.45
11.95
256 2608.92 +0.67% 17.28 2570.70 2616.15 2591.63
11.16
512 2347.63 -0.61% -14.32 2347.35 2382.55 2361.95
10.54
1024 1331.88 -4.85% -67.92 1317.48 1599.29 1399.80
75.62
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1923.92 -0.90% -17.40 1882.34 2017.29 1941.31
29.57
32 2561.37 -0.01% -0.34 2457.92 2608.23 2561.71
36.05
64 2578.53 -0.36% -9.41 2490.50 2650.41 2587.94
35.24
128 2591.69 -0.78% -20.34 2543.55 2654.83 2612.02
26.93
256 2608.92 +0.95% 24.49 2533.73 2616.15 2584.42
19.81
512 2347.63 -0.48% -11.37 2319.43 2420.84 2359.01
19.98
1024 1331.88 -6.15% -87.33 1276.12 1794.48 1419.21
126.82
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1923.92 -6.21% -127.46 1765.65 2233.42 2051.37
83.07
32 2561.37 -4.70% -126.19 2010.47 2909.92 2687.56
113.90
64 2578.53 -5.63% -153.85 2191.91 2998.80 2732.38
143.76
128 2591.69 -3.85% -103.84 2107.33 2911.98 2695.52
101.43
256 2608.92 +2.76% 70.14 2174.91 2691.02 2538.78
86.72
512 2347.63 +27.62% 508.05 968.50 2470.12 1839.58
514.28
1024 1331.88 +19.09% 213.51 485.25 1866.15 1118.37
511.11
====================================================================================================
FULL REVISION COMMENTARY:
1910.1.2: Lee Bieber 2010-11-07 [merge] Merge Stewart - including adapting
and expanding the "differences from mysql" page from the wiki.
1900.2.19: Stewart Smith 2010-11-05 few cleanup to Differences between
Drizzle and mySQL documentation
1900.2.18: Stewart Smith 2010-11-05 add section on notable differences from
MySQL
1900.2.17: Stewart Smith 2010-11-05 jazz up what_is_drizzle
1900.2.16: Stewart Smith 2010-11-05 slightly fill out the SHOW documentation
1900.2.15: Stewart Smith 2010-11-05 flesh out the KILL documentation
1900.2.14: Stewart Smith 2010-11-05 [merge] merge trunk
1910.1.1: Lee Bieber 2010-11-07 [merge] Merge Stewart - fix bug 668143:
drizzleslap with --commit runs second iteration data load in a transaction
1878.9.8: Stewart Smith 2010-11-05 [merge] merge fixes
1878.9.7: Stewart Smith 2010-11-03 [merge] merge trunk and drizzleslap
solaris compiler warning fixes
1878.9.6: Stewart Smith 2010-11-01 [merge] merge drizzleslap client test
1878.9.5: Stewart Smith 2010-11-01 update drizzleslap test results for
fixing autocommit=0 being present in connection that loads data
1878.9.4: Stewart Smith 2010-11-01 [merge] merge drizzleslap displaying
connection ids in --only-print
1878.9.3: Stewart Smith 2010-11-01 [merge] merge trunk
1878.9.2: Stewart Smith 2010-10-29 fix drizzleslap test results so that the
autocommit isn't in the log of queries run
1878.9.1: Stewart Smith 2010-10-29 don't set autocommit to 0 for connection
to server that loads data. otherwise on second iteration, when running with
commit_count, you get your rows loaded, but not committed
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
