====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test2
RUN ID: 513
RUN DATE: 2011-01-15T04:46:39.596694
WORKLOAD: innodb_1000K_readonly
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 2190.13 +0.63% 13.68 2144.68 2205.36 2176.45
21.04
32 2457.66 -0.03% -0.72 2324.70 2555.05 2458.39
76.54
64 1768.15 -1.15% -20.59 1745.00 1831.35 1788.74
22.82
128 1438.62 -0.51% -7.31 1432.52 1462.21 1445.93
9.04
256 1148.95 -0.22% -2.50 1121.06 1186.66 1151.45
18.75
512 758.19 -0.16% -1.19 751.94 771.91 759.39
5.93
1024 497.11 +1.36% 6.67 485.19 498.18 490.43
4.20
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2190.13 +0.54% 11.67 2130.35 2231.89 2178.46
26.70
32 2457.66 -0.81% -20.17 2324.70 2593.75 2477.83
57.76
64 1768.15 +0.63% 11.02 1695.24 1831.35 1757.13
32.36
128 1438.62 +0.29% 4.21 1366.27 1520.58 1434.41
34.71
256 1148.95 +0.93% 10.64 1034.41 1195.76 1138.31
36.64
512 758.19 +0.59% 4.41 738.34 771.91 753.78
7.47
1024 497.11 +1.19% 5.86 483.90 498.18 491.25
3.35
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2190.13 +1.61% 34.64 1087.27 2406.76 2155.49
164.64
32 2457.66 -1.29% -32.15 1306.47 3117.60 2489.81
211.44
64 1768.15 +0.10% 1.79 1597.13 2113.34 1766.36
93.18
128 1438.62 -0.75% -10.89 741.08 1743.39 1449.51
98.37
256 1148.95 -0.49% -5.71 787.72 1429.83 1154.66
74.16
512 758.19 -0.65% -4.97 460.87 1042.59 763.16
63.07
1024 497.11 +0.28% 1.41 446.26 590.95 495.70
25.16
====================================================================================================
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
