====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test2
RUN ID: 678
RUN DATE: 2011-02-23T05:26:42.772700
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 2188.10 +0.51% 11.03 2125.68 2227.66 2177.06
30.49
32 2477.19 +2.02% 48.94 2357.39 2496.69 2428.26
42.66
64 1730.38 -0.39% -6.74 1652.20 1809.48 1737.12
43.63
128 1485.05 +4.69% 66.47 1381.16 1496.30 1418.58
35.57
256 1154.53 +1.30% 14.83 1113.26 1172.49 1139.70
16.86
512 747.11 +0.40% 2.97 731.75 752.75 744.14
4.93
1024 482.75 -0.72% -3.52 481.37 491.54 486.27
2.86
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2188.10 +57.20% 796.21 1109.79 2227.66 1391.88
453.68
32 2477.19 +53.42% 862.51 1263.16 2496.69 1614.68
471.67
64 1730.38 +1.68% 28.59 1460.78 1809.48 1701.79
52.87
128 1485.05 +56.71% 537.42 742.39 1496.30 947.63
276.62
256 1154.53 +65.37% 456.39 538.57 1172.49 698.14
255.15
512 747.11 +58.42% 275.51 375.66 752.75 471.60
157.39
1024 482.75 +58.60% 178.38 238.68 491.54 304.37
105.04
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2188.10 +6.47% 132.88 1087.27 2406.76 2055.22
339.62
32 2477.19 +4.55% 107.90 1263.16 3117.60 2369.29
388.62
64 1730.38 -1.39% -24.37 1460.78 2113.34 1754.75
86.75
128 1485.05 +7.40% 102.29 723.69 1743.39 1382.76
210.51
256 1154.53 +5.90% 64.33 538.57 1429.83 1090.20
193.15
512 747.11 +3.57% 25.73 375.66 1042.59 721.38
127.44
1024 482.75 +3.17% 14.82 238.68 590.95 467.92
79.85
====================================================================================================
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
