====================================================================================================
SYSBENCH BENCHMARK REPORT compared to staging historical data
====================================================================================================
MACHINE: drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID: 1254
RUN DATE: 2012-02-20T18:34:48.758901
WORKLOAD: innodb_1000K_readwrite
SERVER: drizzled
VERSION: lp:~patrick-crews/drizzle/qp-merge2/
REVISION: 2495
COMMENT: 2495: Patrick Crews 2012-02-20 [merge] Merge trunk
====================================================================================================
TRENDING OVER LAST 5 runs compared to staging historical data
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1204.75 -5.41% -68.95 1197.66 1329.01 1273.70
41.00
32 1495.54 -0.38% -5.77 1399.72 1618.30 1501.30
70.38
64 1537.65 -5.71% -93.16 1587.96 1665.31 1630.81
25.78
128 1638.25 -3.09% -52.22 1647.14 1731.34 1690.47
26.21
256 1597.86 -3.55% -58.85 1610.53 1683.21 1656.71
25.36
512 1368.42 -4.75% -68.28 1350.01 1486.74 1436.70
48.70
1024 744.68 -15.68% -138.51 741.37 960.14 883.20
81.44
====================================================================================================
TRENDING OVER Last 20 runs compared to staging historical data
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1204.75 -6.46% -83.15 1197.66 1329.01 1287.90
30.49
32 1495.54 -0.34% -5.14 1350.89 1618.30 1500.68
57.70
64 1537.65 -4.78% -77.13 1471.04 1689.36 1614.78
49.23
128 1638.25 -2.86% -48.29 1640.77 1731.34 1686.54
25.30
256 1597.86 -3.78% -62.77 1610.53 1719.14 1660.63
22.72
512 1368.42 -6.48% -94.86 1350.01 1500.26 1463.28
28.29
1024 744.68 -19.04% -175.10 741.37 965.44 919.79
44.65
====================================================================================================
TRENDING OVER ALL runs compared to staging historical data
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1204.75 -7.66% -100.00 345.67 1503.03 1304.75
71.00
32 1495.54 -5.58% -88.31 616.39 1870.18 1583.85
115.67
64 1537.65 -10.15% -173.72 683.67 2059.46 1711.37
134.37
128 1638.25 -7.22% -127.47 1289.29 2051.37 1765.72
105.84
256 1597.86 -6.04% -102.66 1223.81 1824.49 1700.52
60.68
512 1368.42 -1.94% -27.03 661.33 1554.29 1395.46
161.06
1024 744.68 -27.47% -282.11 513.17 1143.07 1026.79
74.63
====================================================================================================
FULL REVISION COMMENTARY:
2483.1.30: Mark Atwood 2012-02-15 [merge] merge
lp:~laurynas-biveinis/drizzle/bug911948
2483.18.1: Laurynas Biveinis 2012-02-02 Fix bug 911948: a typo in assertion
causing false positive failure
2483.1.29: Mark Atwood 2012-02-15 [merge] merge
lp:~vjsamuel/drizzle/translations-and-rc-tag
2483.17.2: Vijay Samuel 2012-02-15 Merge tag for release candidate
2483.17.1: Vijay Samuel 2012-02-15 [merge] Merge translations
1099.4.252: Launchpad Transla... 2012-01-31 Launchpad automatic
translations update.
1099.4.251: Launchpad Transla... 2012-01-30 Launchpad automatic
translations update.
2483.1.28: Mark Atwood 2012-02-13 update and sort po/POTFILES.in
2483.1.27: Mark Atwood 2012-02-13 [merge] merge lp:~stewart/drizzle/bug709506
2483.16.1: Stewart Smith 2012-02-12 Port fix for MySQL bug 37830: In some
cases ORDER BY DESC doesn't work
2483.1.26: Mark Atwood 2012-02-13 [merge] merge lp:~stewart/drizzle/bug621851
2483.15.23: Stewart Smith 2012-02-12 remove binlog references in
sql_update.cc
2483.15.22: Stewart Smith 2012-02-12 remove binlog references in
statement/alter_table.cc
2483.15.21: Stewart Smith 2012-02-12 remove binlog references in
sql_delete.cc
2483.15.20: Stewart Smith 2012-02-12 remove binlog from information about
OPTION_ flags in common.h
2483.15.19: Stewart Smith 2012-02-12 remove reference to binlog that was in
common.h
2483.15.18: Stewart Smith 2012-02-12 remove a long comment in sql_insert.cc
that was about binlog interaction.
2483.15.17: Stewart Smith 2012-02-12 binlog doesn't exist, therefor cannot
have an influence on user variables
2483.15.16: Stewart Smith 2012-02-12 yet another old useless old binlog
comment - remove it. there is no binlog to coordinate writing DDL o.
2483.15.15: Stewart Smith 2012-02-12 another old useless old binlog comment
- remove it.
2483.15.14: Stewart Smith 2012-02-12 useless old binlog comment - remove it.
2483.15.13: Stewart Smith 2012-02-12 remove binlog reference in
xa_resource_manager error message, which also exposed the fact that
opt_tc_log_file was completely unused, so remove it too.
2483.15.12: Stewart Smith 2012-02-12 A giant comment about auto_inc and
mysql binlogs was taking up space lying to people.
2483.15.11: Stewart Smith 2012-02-12 yet another very out of date binlog
reference regarding auto_inc and mysql binlog
2483.15.10: Stewart Smith 2012-02-12 another very out of date binlog
reference in cursor.cc regarding log_row_for_replication()
2483.15.9: Stewart Smith 2012-02-12 remove very out of date binlog
references in AUTO_INC 'documentation' in cursor.cc
2483.15.8: Stewart Smith 2012-02-12 remove ancient comment about binlog
row_based_if_mixed from Create_func
2483.15.7: Stewart Smith 2012-02-12 remove ancient comment about RBR and
flushing of old mysql binlog events
2483.15.6: Stewart Smith 2012-02-12 remove ancient commented out #error
referring to binlog getting XA
2483.15.5: Stewart Smith 2012-02-12 remove a comment that's irrelevant now
that statement based binlogging is gone - flush::reloadCache doesn't need to
think about statement based binlogging.
2483.15.4: Stewart Smith 2012-02-12 remove a comment that's irrelevant now
that statement based binlogging is gone.
2483.15.3: Stewart Smith 2012-02-12 rename HA_ERR_RBR_LOGGING_FAILED to
HA_ERR_LOG_ROW_FOR_REPLICATION_FAILED and move error string over to
drizzled/ha_commands.cc rather than plugin/myisam/my_handler_errors.cc as it
has nothing to do with MyISAM.
2483.15.2: Stewart Smith 2012-02-12 rename ER_BINLOG_ROW_LOGGING_FAILED to
ER_LOG_ROW_FOR_REPLICATION_FAILED as this is a better name for the Drizzle
error as 'binlog' is not a Drizzle term.
2483.15.1: Stewart Smith 2012-02-12 remove references to binlog in
client/drizzletest.cc - which involves getting rid of the old sync_master foo
that was never used in Drizzle anyway.
2483.1.25: Mark Atwood 2012-02-13 [merge] merge lp:~stewart/drizzle/bug744206
2483.14.1: Stewart Smith 2012-02-12 update MySQl Differences documentation
as to the current state of Drizzle Storage Engines
2483.1.24: Mark Atwood 2012-02-13 [merge] merge lp:~stewart/drizzle/bug920900
2483.13.1: Stewart Smith 2012-02-12 add option to simple_user_policy to
remap a . to another character/string. This helps people with users with a . in
the name map it to an _ so that schema names don't have to always be quoted
2483.1.23: Mark Atwood 2012-02-13 [merge] merge
lp:~stewart/drizzle/myisam-and-console-docs
2483.12.3: Stewart Smith 2012-02-11 document console plugin options
2483.12.2: Stewart Smith 2012-02-11 add some docs for console plugin
2483.12.1: Stewart Smith 2012-02-11 modify MyISAM description in
DRIZZLE_PLUGIN definition to match description in plugin.ini and be more
representative of what MyISAM is in Drizzle
2483.1.22: Mark Atwood 2012-02-13 [merge] merge
lp:~hingo/drizzle/fix-make-html
2483.11.2: Henrik Ingo 2012-02-12 Include generation of docs into make
test, so it is actually routinely
2483.11.1: Henrik Ingo 2012-02-10 * A lot of the docs were missing from the
source tarball.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp