====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID: 856
RUN DATE: 2011-01-14T23:35:54.391799
WORKLOAD: innodb_1000K_readwrite
SERVER: drizzled
VERSION: staging
REVISION: 2087
COMMENT: 2087: Lee Bieber 2011-01-14 [merge] Merge Stewart - some
documentation clean up
====================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1357.12 +0.63% 8.53 1312.02 1384.04 1348.59
20.86
32 1535.94 -1.56% -24.28 1497.93 1617.12 1560.22
31.62
64 1594.16 -1.64% -26.65 1570.38 1676.75 1620.81
30.50
128 1695.15 +0.21% 3.47 1662.39 1717.01 1691.67
16.28
256 1644.68 -0.56% -9.21 1628.41 1677.36 1653.89
15.25
512 1484.99 -0.34% -5.13 1468.32 1518.49 1490.12
15.82
1024 1098.28 +0.20% 2.17 1064.17 1123.68 1096.12
16.42
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1357.12 +0.44% 6.00 1280.98 1405.84 1351.12
27.78
32 1535.94 +0.04% 0.67 1384.22 1629.84 1535.27
59.71
64 1594.16 -1.57% -25.42 1493.73 1697.33 1619.57
44.98
128 1695.15 +0.77% 12.96 1608.12 1732.93 1682.18
25.12
256 1644.68 -1.42% -23.72 1612.84 1724.58 1668.40
25.19
512 1484.99 -0.53% -7.91 1451.88 1518.49 1492.90
16.00
1024 1098.28 +0.04% 0.45 1031.91 1128.25 1097.83
23.20
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1357.12 +4.64% 60.13 1111.61 1503.03 1296.99
69.64
32 1535.94 -4.56% -73.41 1144.74 1870.18 1609.34
117.43
64 1594.16 -8.78% -153.40 1392.69 2059.46 1747.56
138.82
128 1695.15 -5.63% -101.15 1472.01 2051.37 1796.29
109.10
256 1644.68 -3.83% -65.53 1340.97 1824.49 1710.21
60.50
512 1484.99 +9.43% 127.96 1004.97 1554.29 1357.03
177.48
1024 1098.28 +3.05% 32.55 1000.02 1132.65 1065.73
28.41
====================================================================================================
FULL REVISION COMMENTARY:
2086.1.3: Lee Bieber 2011-01-14 [merge] Merge Stewart - some documentation
clean up
1994.5.38: Stewart Smith 2011-01-14 \r, like the Daleks, just keeps coming
back
1994.5.37: Stewart Smith 2011-01-14 add FIXME that we should document
current implementation of ALTER TABLE
1994.5.36: Stewart Smith 2011-01-14 add some FIXME to analyze docs.
1994.5.35: Stewart Smith 2011-01-14 \r again :(
1994.5.34: Stewart Smith 2011-01-14 add note that text/varchar is valid utf8
1994.5.33: Stewart Smith 2011-01-14 add FIXME for CREATE INDEX
implementation should be documented
1994.5.32: Stewart Smith 2011-01-14 few notes on DATA_DICTIONARY
documentation.
1994.5.31: Stewart Smith 2011-01-14 just a syntax fix
1994.5.30: Stewart Smith 2011-01-14 add explanation as to why 0000-00-00 is
an invalid date. add fixmes about some of the TIME type restrictions
1994.5.29: Stewart Smith 2011-01-14 add FIXME for EXECUTE doing things
inside explicit txn
1994.5.28: Stewart Smith 2011-01-14 add a small note about isolation of
DROP SCHEMA from other txns.
1994.5.27: Stewart Smith 2011-01-14 add note that impl of DROP INDEX should
be documented
1994.5.26: Stewart Smith 2011-01-14 add FIXME that LOAD DATA INFILE should
come under DML.
1994.5.25: Stewart Smith 2011-01-14 \r and trailing whitespace removed.
1994.5.24: Stewart Smith 2011-01-14 \r and trailing whitespace removed.
1994.5.23: Stewart Smith 2011-01-14 add a FIXME to flesh out insert docs
1994.5.22: Stewart Smith 2011-01-14 fix up some joins docs. remove \r to
prevent injuries to puppies and add a FIXME about documenting our join
implementation.
1994.5.21: Stewart Smith 2011-01-14 logging is done by plugins, so imply in
docs that new plugins can implement new logging.
1994.5.20: Stewart Smith 2011-01-14 add some FIXME for clarifications
needed in locks doc
1994.5.19: Stewart Smith 2011-01-14 rearrange explanation of absence of old
weird types in numeric data types doc to be after explanation of what we do
have. I think it reads better that way
1994.5.18: Stewart Smith 2011-01-14 add some FIXMEs to ORDER BY docs about
what should be added.
1994.5.17: Stewart Smith 2011-01-14 remove \r at end of line as they cause
kitten injuries.
1994.5.16: Stewart Smith 2011-01-14 remove \r at end of line as they cause
kitten injuries.
1994.5.15: Stewart Smith 2011-01-14 fix tpyo
1994.5.14: Stewart Smith 2011-01-14 talk about statement rollback (briefly)
in replication docs
1994.5.13: Stewart Smith 2011-01-14 add savepoint example
1994.5.12: Stewart Smith 2011-01-14 clear up explanation on what SHOw
commands are. that the tablesa re implemented as table functions is'nt really
relevant ot end user
1994.5.11: Stewart Smith 2011-01-14 remove \r newlines from scalar functions
1994.5.10: Stewart Smith 2011-01-14 add BEGIN to start_transaction docs.
also about near future of having error on BEGIn; BEGIN;
1994.5.9: Stewart Smith 2011-01-14 storage engine docs. add bit about some
temp table only engines.
1994.5.8: Stewart Smith 2011-01-14 fix up spinx syntax
1994.5.7: Stewart Smith 2011-01-14 small note on utf8 and collations for
string dataa types - should be expanded into real sentences.
1994.5.6: Stewart Smith 2011-01-14 notes on transaction docs. statements
can be rolled back, celan up some language around definition
1994.5.5: Stewart Smith 2011-01-14 add some notes on TRUNCATE, including
things that should be expanded on
1994.5.4: Stewart Smith 2011-01-14 UPDATE has a condition
1994.5.3: Stewart Smith 2011-01-14 add note about what uuid lib we use
1994.5.2: Stewart Smith 2011-01-14 add a bit of a note on how variables
docs should be expanded
1994.5.1: Stewart Smith 2011-01-14 WHERE clause example is just a simple one
2086.1.2: Lee Bieber 2011-01-14 [merge] Merge Patrick - fix bug 693130: Tests
depending on archive engine should be skipped if archive isn't enabled
2081.3.1: Patrick Crews 2011-01-14 Fix for bug693130. Moved
drizzledump-max to the archive suite - more logical place. Can't *really* fix
this issue as test-run.pl is too dumb to handle it
2086.1.1: Lee Bieber 2011-01-14 [merge] Merge Patrick - fix bug 697292: The
have_valgrind include file in the test has the opposite effect
2081.2.1: Patrick Crews 2011-01-14 Made include/have_valgrind do what the
name implies altered not_valgrind to do the job of skipping tests that are in a
valgrind run. Updates to tests and whatnot to accomodate this
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
