====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: Drizzle-build-n03
RUN ID: 97
RUN DATE: 2011-02-23T05:16:32.493595
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 2370.22 +1.59% 37.20 2285.05 2408.06 2333.02
40.96
32 2414.60 -3.64% -91.17 2292.54 2683.47 2505.76
117.93
64 2683.09 -0.06% -1.71 2596.52 2739.29 2684.80
33.59
128 2578.87 -1.05% -27.49 2571.75 2642.08 2606.36
17.56
256 2372.98 +0.16% 3.70 2348.71 2396.53 2369.28
12.79
512 1953.85 +0.40% 7.80 1934.42 1962.19 1946.04
8.41
1024 1355.09 +0.57% 7.61 1307.61 1363.33 1347.47
14.60
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2370.22 +2.85% 65.68 2192.32 2408.06 2304.54
47.71
32 2414.60 -5.95% -152.72 2292.54 2690.27 2567.31
83.55
64 2683.09 +1.04% 27.59 2501.60 2739.29 2655.50
51.16
128 2578.87 -0.49% -12.78 2547.76 2642.08 2591.64
21.05
256 2372.98 +0.54% 12.67 2319.06 2400.77 2360.31
16.51
512 1953.85 +1.20% 23.17 1901.43 1963.58 1930.67
16.71
1024 1355.09 +1.84% 24.43 1267.57 1381.10 1330.66
29.42
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2370.22 +2.32% 53.76 2171.92 2454.02 2316.47
50.03
32 2414.60 -7.02% -182.33 2290.10 2769.48 2596.92
96.20
64 2683.09 +0.02% 0.60 2501.60 2831.41 2682.49
59.49
128 2578.87 -1.41% -36.94 2531.85 2725.58 2615.81
44.06
256 2372.98 -0.81% -19.41 2302.55 2500.38 2392.39
46.25
512 1953.85 -0.40% -7.82 1879.21 2051.13 1961.67
40.97
1024 1355.09 +0.15% 2.04 1239.79 1445.26 1353.05
41.66
====================================================================================================
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
