====================================================================================================
SYSBENCH BENCHMARK REPORT
====================================================================================================
MACHINE: r815-test1
RUN ID: 40
RUN DATE: 2011-03-18T04:18:41.276858
WORKLOAD: innodb_1000K_readonly
SERVER: drizzled
VERSION: staging
REVISION: 2242
COMMENT: 2242: Lee Bieber 2011-03-18 [merge] Merge Stewart - refactoring of
default values
====================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2191.17 +0.82% 17.73 2113.76 2241.55 2173.44
39.84
32 2316.71 -3.64% -87.45 2287.47 2543.96 2404.16
78.03
64 1705.61 -0.74% -12.68 1681.27 1758.75 1718.29
22.46
128 1446.96 +2.13% 30.20 1369.08 1455.17 1416.75
30.43
256 1108.28 -2.20% -24.92 1106.09 1166.08 1133.20
20.87
512 741.01 -0.29% -2.19 733.21 761.40 743.20
9.28
1024 478.04 -1.27% -6.15 473.65 493.64 484.19
5.71
====================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2191.17 +1.76% 37.97 2065.18 2256.68 2153.21
38.80
32 2316.71 -2.94% -70.08 2276.13 2566.42 2386.79
71.76
64 1705.61 -0.26% -4.52 1608.65 1783.76 1710.13
38.51
128 1446.96 +2.58% 36.43 1327.93 1498.50 1410.52
37.84
256 1108.28 -1.46% -16.42 1054.94 1182.96 1124.70
28.25
512 741.01 +0.43% 3.20 724.12 761.40 737.81
8.97
1024 478.04 -0.82% -3.97 471.20 494.29 482.01
5.64
====================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Min Max Avg
STD
====================================================================================================
16 2191.17 +1.76% 37.97 2065.18 2256.68 2153.20
34.76
32 2316.71 -2.67% -63.67 2262.47 2566.42 2380.39
59.74
64 1705.61 +0.26% 4.46 1608.65 1783.76 1701.15
37.96
128 1446.96 +2.81% 39.50 1327.93 1498.50 1407.46
35.13
256 1108.28 -0.71% -7.91 1030.78 1182.96 1116.19
29.92
512 741.01 +0.39% 2.90 715.51 761.40 738.11
9.56
1024 478.04 -0.76% -3.68 471.20 494.29 481.72
4.95
====================================================================================================
FULL REVISION COMMENTARY:
2241.1.2: Lee Bieber 2011-03-17 [merge] Merge Stewart - refactoring of
default values
2200.2.25: Stewart Smith 2011-03-17 [merge] Merge refactoring of default
values work
2200.2.24: Stewart Smith 2011-03-07 [merge] merge trunk
2200.2.23: Stewart Smith 2011-03-04 [merge] merge trunk
2200.2.22: Stewart Smith 2011-03-03 [merge] merge trunk
2200.2.21: Stewart Smith 2011-03-02 remove the now unused AlterDrop class,
header file and includes
2200.2.20: Stewart Smith 2011-03-02 remove drop_list from AlterInfo - is
now only in the message::AlterTable protobuf message
2200.2.19: Stewart Smith 2011-03-02 use the AlterTable protobuf message
list of colmuns, keys and foreign keys to drop inside the ALTER TABLE code
instead of the list in alter_info
2200.2.18: Stewart Smith 2011-03-02 add fields, indexes and foreign keys to
drop in ALTER TABLE DROP and DROP INDEX to the AlterTable protobuf message in
parser
2200.2.17: Stewart Smith 2011-03-02 add AlterTable operations for dropping
column, keys and foreign keys (by name) in the AlterTable protobuf message.
2200.2.16: Stewart Smith 2011-03-02 remove enum_enable_or_disable which was
only used for alter_info.keys_onoff. We can just use the message::AlterTable now
2200.2.15: Stewart Smith 2011-03-01 remove enum ha_build_method and instead
use the build method in message::AlterTable.
2200.2.14: Stewart Smith 2011-03-01 throw an error if ONLINE ALTER TABLE is
asked for that we cannot do without a copying alter table.
2200.2.13: Stewart Smith 2011-03-01 make ALTER TABLE RENAME and
DISABLE/ENABLE keys use the AlterTable protobuf message constructed in the
parser, with asserts for the old AlterInfo structure matching
2200.2.12: Stewart Smith 2011-03-01 set RenameTable and AlterKeysOnOff
protobuf messages inside the AlterTable protobuf message for ALTER TABLE in
parser
2200.2.11: Stewart Smith 2011-03-01 move the message::AlterTable header
include into sql_lex.cc so we can just have a forward declaration in sql_lex.h
- greatly speeding compile time
2200.2.10: Stewart Smith 2011-03-01 add RenameTable and AlterKeysOnOff
messages inside AlterTable protobuf message. We have these separate to the main
repeated AlterTableOperation message as multiple invocations of these parts of
ALTER TABLE have no effect (the last one in the ALTER TABLE statement is taken)
2200.2.9: Stewart Smith 2011-03-01 add a utterly insane test of combination
of renaming table and disable/enable keys to alter_table_rename_plus test
2200.2.8: Stewart Smith 2011-02-28 in test for ALTER TABLE including RENAME
and others, add a test for DISABLE KEYS, RENAME as there is a special RENAME
TABLE code path for this case.
2200.2.7: Stewart Smith 2011-02-28 add a test for ALTER TABLE with both
renaming the table and another operation.
2200.2.6: Stewart Smith 2011-02-28 switch DISCARD/IMPORT TABLESPACE to only
use the alter table protobuf message
2200.2.5: Stewart Smith 2011-02-28 properly reset alter_table in Lex
2200.2.4: Stewart Smith 2011-02-28 document the limitation on
DISCARD/IMPORT tablespace in teh AlterTableOperation protobuf message
2200.2.3: Stewart Smith 2011-02-28 add code to store IMPORT/DISCARD
TABLESPACE operation in the AlterTable protobuf message. assert that we get the
right thing in alter table code
2200.2.2: Stewart Smith 2011-02-28 add very basic ALTER TABLE protobuf
message and add the DEFAULT/OFFLINE/ONLINE build method member to it, assert
that we're doing the right thing.
2200.2.1: Stewart Smith 2011-02-28 rename old alter table proto to
AddedFields as it really has a dual purpose and isn't how we should structure
Alter Table.
2241.1.1: Lee Bieber 2011-03-17 [merge] Merge Olaf - more refactoring
2240.2.2: Olaf van der Spek 2011-03-17 Refactor
2240.2.1: Olaf van der Spek 2011-03-17 Refactor
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
