====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n01.wc1.dfw1.stabletransit.com
RUN ID: 942
RUN DATE: 2011-02-23T00:22:10.348996
WORKLOAD: innodb_1000K_readonly
SERVER: drizzled
VERSION: staging
REVISION: 2194
COMMENT: 2194: Lee Bieber 2011-02-23 [merge] Merge Andrew - 723389: ORDER BY
on sys_replication_log table causes InnoDB crash
====================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1856.03 -0.05% -0.93 1828.31 1894.11 1856.96
20.44
32 2495.52 +0.36% 8.94 2413.79 2521.40 2486.58
30.86
64 2555.21 +0.63% 15.91 2461.82 2623.23 2539.30
61.29
128 2526.77 -0.94% -23.97 2515.05 2591.16 2550.74
21.92
256 2502.44 -0.67% -16.80 2491.85 2577.93 2519.24
27.34
512 2262.05 -0.78% -17.82 2250.15 2304.67 2279.87
19.93
1024 1301.94 -0.62% -8.08 1273.70 1361.49 1310.02
23.53
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1856.03 +0.66% 12.12 1749.77 1898.05 1843.91
31.20
32 2495.52 +2.45% 59.76 2253.13 2521.40 2435.76
76.06
64 2555.21 +0.30% 7.57 2441.07 2623.23 2547.64
47.38
128 2526.77 -0.65% -16.41 2487.59 2591.16 2543.18
23.56
256 2502.44 -1.12% -28.43 2472.45 2577.93 2530.87
25.46
512 2262.05 -0.84% -19.16 2250.15 2309.02 2281.21
15.70
1024 1301.94 -0.58% -7.64 1273.70 1361.49 1309.58
20.23
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1856.03 -6.37% -126.34 1709.73 2233.42 1982.37
122.54
32 2495.52 -4.14% -107.88 2010.47 2909.92 2603.40
158.84
64 2555.21 -3.80% -100.87 2191.91 2998.80 2656.08
166.39
128 2526.77 -4.15% -109.35 2107.33 2911.98 2636.13
123.78
256 2502.44 -0.97% -24.61 2174.91 2691.02 2527.05
80.80
512 2262.05 +12.54% 252.00 1301.49 2470.12 2010.05
445.55
1024 1301.94 -13.76% -207.81 1251.35 1866.15 1509.75
173.60
====================================================================================================
FULL REVISION COMMENTARY:
2193.1.2: Lee Bieber 2011-02-22 [merge] Merge Andrew - 723389: ORDER BY on
sys_replication_log table causes InnoDB crash
2192.2.1: Andrew Hutchings 2011-02-22 The widths for the indexes in the
SYS_REPLICATION_LOG proto were too small for the index parts. Causing crashes
with a few queries that required filesort
2193.1.1: Lee Bieber 2011-02-22 [merge] Merge Marisa - documentation updates
1994.4.96: Marisa Plumb 2011-02-22 position updates
1994.4.95: Marisa Plumb 2011-02-22 more comparison operators
1994.4.94: Marisa Plumb 2011-02-22 [merge] updating
1994.4.93: Marisa Plumb 2011-02-22 additions, edits
1994.4.92: Marisa Plumb 2011-02-22 current time functions, new content
1994.4.91: Marisa Plumb 2011-02-22 adding aggregate function content
1994.4.90: Marisa Plumb 2011-02-22 [merge] updating to trunk
1994.4.89: Marisa Plumb 2011-02-22 removing file
1994.4.88: Marisa Plumb 2011-02-21 moving functions
1994.4.87: Marisa Plumb 2011-02-21 adding to date functions
1994.4.86: Marisa Plumb 2011-02-21 insert -- added multirow insert
explanation and example
1994.4.85: Marisa Plumb 2011-02-21 create index (no fast index creation)
1994.4.84: Marisa Plumb 2011-02-21 logical operators
1994.4.83: Marisa Plumb 2011-02-20 table update functions edits, starting
authentication
1994.4.82: Marisa Plumb 2011-02-20 additions and updates to transaction docs
1994.4.81: Marisa Plumb 2011-02-20 edits
1994.4.80: Marisa Plumb 2011-02-20 [merge] updating
1994.4.79: Marisa Plumb 2011-02-20 [merge] updating
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
