====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test2
RUN ID: 679
RUN DATE: 2011-02-23T07:09:21.765442
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 1705.02 -0.27% -4.64 1675.62 1745.02 1709.65
19.32
32 1993.88 +0.15% 3.00 1896.59 2045.28 1990.88
41.89
64 1361.30 -4.23% -60.09 1350.00 1469.64 1421.39
37.67
128 1058.06 -2.00% -21.61 1040.22 1121.91 1079.66
25.80
256 870.33 -2.73% -24.47 866.82 940.07 894.80
23.31
512 618.64 +0.15% 0.92 607.25 629.75 617.73
6.28
1024 404.65 +0.35% 1.39 399.15 406.07 403.26
2.18
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1705.02 +53.13% 591.60 896.53 1745.02 1113.42
344.46
32 1993.88 +49.88% 663.53 1036.70 2045.28 1330.35
382.61
64 1361.30 +1.34% 18.05 878.49 1469.64 1343.25
113.79
128 1058.06 +37.03% 285.95 613.33 1121.91 772.11
188.61
256 870.33 +53.02% 301.55 449.38 940.07 568.78
188.68
512 618.64 +57.63% 226.17 312.39 629.75 392.48
130.11
1024 404.65 +61.02% 153.34 198.52 406.07 251.31
87.74
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1705.02 +4.99% 81.00 893.86 1869.76 1624.02
252.65
32 1993.88 +3.93% 75.39 1034.28 2395.61 1918.49
310.88
64 1361.30 -5.03% -72.04 878.49 1721.72 1433.34
88.87
128 1058.06 +0.58% 6.09 613.33 1345.78 1051.97
148.49
256 870.33 +3.12% 26.30 449.38 1034.59 844.03
136.20
512 618.64 +4.33% 25.67 311.90 781.01 592.97
100.23
1024 404.65 +5.94% 22.68 198.22 487.49 381.97
65.94
====================================================================================================
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
