====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: drizzle-build-n01.wc1.dfw1.stabletransit.com
RUN ID: 835
RUN DATE: 2011-01-14T23:35:55.085417
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 1858.36 -0.72% -13.45 1845.56 1916.62 1871.82
18.45
32 2505.39 +0.47% 11.75 2441.87 2531.62 2493.65
26.21
64 2594.19 +0.87% 22.31 2512.59 2610.93 2571.88
29.66
128 2555.35 -0.10% -2.65 2535.48 2586.61 2558.00
14.97
256 2571.29 -0.12% -3.09 2558.06 2595.66 2574.38
10.45
512 2333.88 +0.59% 13.65 2286.08 2343.13 2320.24
19.30
1024 1403.38 -0.05% -0.71 1335.40 1516.12 1404.09
50.66
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1858.36 -0.21% -3.97 1743.79 1916.62 1862.34
30.68
32 2505.39 +1.06% 26.16 2340.95 2552.57 2479.23
44.78
64 2594.19 +3.01% 75.74 2359.89 2610.93 2518.44
64.14
128 2555.35 +1.54% 38.78 2395.20 2597.38 2516.57
51.57
256 2571.29 +1.92% 48.41 2433.81 2595.66 2522.88
44.73
512 2333.88 +1.36% 31.22 2249.91 2343.13 2302.66
20.59
1024 1403.38 -0.10% -1.43 1335.40 1543.02 1404.81
47.89
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 1858.36 -7.13% -142.67 1721.68 2233.42 2001.03
117.59
32 2505.39 -4.57% -119.94 2010.47 2909.92 2625.34
154.17
64 2594.19 -2.89% -77.10 2191.91 2998.80 2671.28
170.13
128 2555.35 -3.48% -92.24 2107.33 2911.98 2647.59
126.74
256 2571.29 +1.83% 46.25 2174.91 2691.02 2525.04
85.14
512 2333.88 +18.43% 363.16 1301.49 2470.12 1970.72
461.14
1024 1403.38 -8.93% -137.53 1251.35 1866.15 1540.91
175.84
====================================================================================================
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
