====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID: 969
RUN DATE: 2011-02-23T00:22:08.765040
WORKLOAD: innodb_1000K_readwrite
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 1367.84 +1.51% 20.29 1296.05 1383.52 1347.55
26.86
32 1622.42 +4.16% 64.82 1408.94 1657.25 1557.60
76.03
64 1536.96 -5.20% -84.28 1521.75 1717.06 1621.24
62.71
128 1710.32 -0.37% -6.27 1674.68 1758.75 1716.59
27.52
256 1652.75 -2.35% -39.76 1648.53 1726.75 1692.51
25.94
512 1513.07 +0.20% 3.10 1491.24 1528.07 1509.97
9.72
1024 1043.79 -2.44% -26.11 1018.89 1115.20 1069.90
30.66
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1367.84 +1.35% 18.22 1278.19 1401.12 1349.63
27.00
32 1622.42 +3.61% 56.60 1408.94 1680.58 1565.82
77.92
64 1536.96 -6.81% -112.32 1521.75 1722.35 1649.29
46.58
128 1710.32 -0.88% -15.16 1666.88 1774.48 1725.48
28.51
256 1652.75 -2.90% -49.31 1648.53 1737.40 1702.06
22.48
512 1513.07 +0.25% 3.79 1466.40 1538.49 1509.28
14.49
1024 1043.79 -2.17% -23.15 1002.65 1119.58 1066.94
26.03
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1367.84 +5.14% 66.91 345.67 1503.03 1300.93
76.41
32 1622.42 +1.34% 21.49 616.39 1870.18 1600.93
119.91
64 1536.96 -11.31% -195.96 978.24 2059.46 1732.92
140.51
128 1710.32 -4.18% -74.56 1289.29 2051.37 1784.88
110.99
256 1652.75 -3.21% -54.81 1223.81 1824.49 1707.56
65.49
512 1513.07 +10.13% 139.16 1004.97 1554.29 1373.91
174.74
1024 1043.79 -2.43% -26.02 900.25 1143.07 1069.81
33.36
====================================================================================================
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
