====================================================================================================
SYSBENCH BENCHMARK REPORT compared to staging historical data
====================================================================================================
MACHINE: drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID: 756
RUN DATE: 2010-12-15T14:28:17.473248
WORKLOAD: innodb_1000K_readwrite
SERVER: drizzled
VERSION: lp:~brianaker/drizzle/check-identifiers
REVISION: 1995
COMMENT: 1995: Brian Aker 2010-12-15 [merge] Merge in trunks.
====================================================================================================
TRENDING OVER LAST 5 runs compared to staging historical data
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1309.06 -2.45% -32.94 1285.34 1388.53 1342.00
27.79
32 1553.40 +1.27% 19.41 1449.41 1616.35 1533.98
58.61
64 1644.03 +0.32% 5.18 1580.31 1703.77 1638.85
39.10
128 1644.42 -2.85% -48.27 1653.70 1740.04 1692.69
24.93
256 1678.19 +0.64% 10.65 1625.86 1691.26 1667.54
20.48
512 1464.80 -1.64% -24.40 1463.57 1507.40 1489.20
11.53
1024 1086.27 -0.36% -3.88 1068.03 1115.17 1090.15
13.00
====================================================================================================
TRENDING OVER Last 20 runs compared to staging historical data
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1309.06 -2.69% -36.18 1285.34 1409.70 1345.24
24.97
32 1553.40 +2.76% 41.74 1379.09 1616.35 1511.66
57.66
64 1644.03 +2.79% 44.62 1457.75 1716.72 1599.41
68.96
128 1644.42 -2.53% -42.73 1637.40 1749.92 1687.15
31.28
256 1678.19 +0.56% 9.27 1625.86 1703.35 1668.92
20.87
512 1464.80 -1.44% -21.34 1442.78 1508.56 1486.14
13.45
1024 1086.27 -0.45% -4.96 1028.09 1131.77 1091.23
18.69
====================================================================================================
TRENDING OVER ALL runs compared to staging historical data
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1309.06 +1.42% 18.34 1111.61 1503.03 1290.72
71.04
32 1553.40 -4.11% -66.52 664.38 1870.18 1619.92
121.11
64 1644.03 -6.94% -122.64 711.60 2059.46 1766.67
136.96
128 1644.42 -9.25% -167.57 1472.01 2051.37 1812.00
106.14
256 1678.19 -2.22% -38.02 1340.97 1824.49 1716.22
61.32
512 1464.80 +10.60% 140.40 828.88 1554.29 1324.40
198.11
1024 1086.27 +32.02% 263.48 450.29 1132.65 822.79
247.31
====================================================================================================
FULL REVISION COMMENTARY:
1992.5.3: Lee Bieber 2010-12-14 [merge] Merge Stewart - fix bug 655805 -
HailDB Cursor not resetting this->cursor to clustered index after secondary
index operations
1992.10.2: Lee Bieber 2010-12-14 [merge] Merge Stewart - fix bug 655805 -
HailDB Cursor not resetting this->cursor to clustered index after secondary
index operations
1977.3.15: Stewart Smith 2010-12-14 read set IS A LIE. It does *NOT* give
you what you need. single threaded sysbench now works with HailDB if we ignore
doing the right thing and just violate the API. arse.
1977.3.14: Stewart Smith 2010-12-14 fix comment
1977.3.13: Stewart Smith 2010-12-14 HailDB doDeleteRecord do error
conversion properly
1977.3.12: Stewart Smith 2010-12-13 HailDB cursor not reset to clustered
index.
1977.3.11: Stewart Smith 2010-12-12 some more correctino of error
conversion in HailDB
1977.3.10: Stewart Smith 2010-12-12 improve errors being returned from
read_row_from_haildb
1977.3.9: Stewart Smith 2010-12-12 properly translate haildb error code
in delete_all_rows
1977.3.8: Stewart Smith 2010-12-12 properly return errors from HailDB
doUpdateRecord and doDeleteRecord. we weren't using the proper translation
function before
1977.3.7: Stewart Smith 2010-12-12 return success/failure from HailDB
doStartTransaction
1992.10.1: Lee Bieber 2010-12-14 [merge] Merge Andrew - fix bug 690083:
Wrong results with regular expressions
1992.9.1: Andrew Hutchings 2010-12-14 Fix REGEXP which was using the
match against value for the regex as well
1992.5.2: Lee Bieber 2010-12-13 [merge] Merge Andrew - fix bug 686773:
TableFunction::Generator::push() needs assert
1992.7.3: Lee Bieber 2010-12-13 [merge] Merge Andrew - fix bug 686773:
TableFunction::Generator::push() needs assert
1992.8.2: Andrew Hutchings 2010-12-12 More test case fixes
1992.8.1: Andrew Hutchings 2010-12-12 Enforce
TableFunction::Generator::push() should only be used on a nullable field
1992.7.2: Lee Bieber 2010-12-13 [merge] Merge Stewart - ON DUPLICATE KEY
UPDATE support for HailDB
1977.3.6: Stewart Smith 2010-12-12 add basic ON DUPLICATE KEY UPDATE test
for HailDB
1977.3.5: Stewart Smith 2010-12-10 [merge] merge trunk
1977.3.4: Stewart Smith 2010-12-10 properly support INSERT ON DUPLICATE
KEY UPDATE for HailDB engine. Also needed to fix a bug where there was a
missing move_field_offset(-offset) call in read_row_from_haildb. This could
have caused all sorts of other bugs too
1977.3.3: Stewart Smith 2010-12-08 HailDB: make write_row_to_haildb_tuple
take a parameter for the row buffer to read from
1977.3.2: Stewart Smith 2010-12-08 basic support for returning index name
for duplicate key error for HailDB: use ib_get_duplicate_key() to find the
index name that was violated, then search for the errkey id and return to user.
1992.7.1: Lee Bieber 2010-12-13 [merge] Merge Monty - fix bug 688819:
drizzle fails to build from source in natty
1992.6.1: Monty Taylor 2010-12-12 Use LT version of lib instead in link
step
1992.5.1: Lee Bieber 2010-12-10 [merge] Merge Evan - Add some extra details
to the libdrizzle documentation
1992.2.3: Lee Bieber 2010-12-10 [merge] Merge Evan - Add some extra details
to the libdrizzle documentation
1992.4.1: Evan Jones 2010-12-10 libdrizzle: Add detail to API docs for
column and row *_read()
1992.2.2: Lee Bieber 2010-12-10 [merge] Merge Shrews - Fix compiler warning
about "comparison between signed and unsigned integer exp
1992.3.1: David Shrewsbury 2010-12-10 Fix compiler warning in
transaction_reader code regarding type comparison
1992.2.1: Lee Bieber 2010-12-10 [merge] Merge Monty - We were leaving
link-warning.h out of the tarball
1986.1.1: Monty Taylor 2010-12-09 Distribute link-warning.h and
distribute it with the right copyright header.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
