=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 949
RUN DATE: 2011-03-09T19:21:53.067096
SERVER: drizzled
VERSION: staging
REVISION: 2227
COMMENT: 2227: Monty Taylor 2011-03-09 [merge] Merged Dave - Filtered
Replication docs
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 35.00 -10.06% -3.20
25.00 35.00 31.80 3.54
innodb alter_table_drop 23.00 +1.71% 0.40
22.00 25.00 23.40 1.02
innodb connect 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb connect+select_1_row 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb connect+select_simple 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb count 17.00 +1.16% 0.20
16.00 18.00 17.20 0.75
innodb count_distinct 6.00 +9.09% 0.60
6.00 8.00 6.60 0.80
innodb count_distinct_2 14.00 -0.00% 0.00
13.00 16.00 14.00 1.10
innodb count_distinct_big 25.00 -5.93% -1.40
20.00 25.00 23.60 1.85
innodb count_distinct_group 15.00 -4.17% -0.60
13.00 15.00 14.40 0.80
innodb count_distinct_group_on_key 9.00 +2.17% 0.20
8.00 11.00 9.20 0.98
innodb count_distinct_group_on_key_parts 14.00 -0.00% 0.00
14.00 14.00 14.00 0.00
innodb count_distinct_key_prefix 6.00 -7.14% -0.40
5.00 6.00 5.60 0.49
innodb count_group_on_key_parts 11.00 -1.85% -0.20
10.00 11.00 10.80 0.40
innodb count_on_key 96.00 -3.67% -3.40
91.00 96.00 92.60 1.74
innodb create+drop 32.00 +2.44% 0.80
32.00 34.00 32.80 0.75
innodb create_index 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb create_key+drop 31.00 +1.27% 0.40
30.00 33.00 31.40 1.02
innodb create_MANY_tables 22.00 -4.76% -1.00
20.00 22.00 21.00 0.89
innodb delete_all_many_keys 624.00 +4.00% 26.00
624.00 692.00 650.00 25.67
innodb delete_autocommit 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb delete_big 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 623.00 +4.01% 26.00
623.00 691.00 649.00 25.67
innodb delete_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb delete_key 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb delete_range 9.00 -0.00% 0.00
8.00 10.00 9.00 0.63
innodb delete_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb drop_index 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb drop_table_when_MANY_tables 20.00 -6.38% -1.20
18.00 20.00 18.80 0.98
innodb insert 114.00 -0.53% -0.60
111.00 116.00 113.40 1.62
innodb insert_autocommit 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb insert_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb insert_duplicates 19.00 -0.00% 0.00
18.00 20.00 19.00 0.63
innodb insert_key 275.00 +1.79% 5.00
273.00 299.00 280.00 9.63
innodb insert_many_fields 5.00 +16.67% 1.00
5.00 7.00 6.00 0.63
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb insert_select_2_keys 7.00 -12.90% -0.80
5.00 7.00 6.20 0.75
innodb min_max 9.00 -7.14% -0.60
7.00 9.00 8.40 0.80
innodb min_max_on_key 25.00 -2.46% -0.60
23.00 25.00 24.40 0.80
innodb multiple_value_insert 7.00 -9.38% -0.60
5.00 7.00 6.40 0.80
innodb once_prepared_select 29.00 -1.40% -0.40
28.00 29.00 28.60 0.49
innodb order_by_big 12.00 +14.29% 2.00
12.00 15.00 14.00 1.26
innodb order_by_big_key 12.00 +13.04% 1.80
12.00 15.00 13.80 1.17
innodb order_by_big_key2 11.00 +15.38% 2.00
11.00 14.00 13.00 1.10
innodb order_by_big_key_desc 14.00 +7.89% 1.20
13.00 17.00 15.20 1.47
innodb order_by_big_key_diff 12.00 +6.25% 0.80
12.00 13.00 12.80 0.40
innodb order_by_big_key_prefix 12.00 +9.09% 1.20
12.00 14.00 13.20 0.75
innodb order_by_key2_diff 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb order_by_key_prefix 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 24.00 -7.14% -1.60
18.00 24.00 22.40 2.24
innodb outer_join_found 22.00 -1.85% -0.40
17.00 23.00 21.60 2.33
innodb outer_join_not_found 21.00 -5.00% -1.00
16.00 22.00 20.00 2.10
innodb outer_join_on_key 16.00 -11.11% -1.60
12.00 16.00 14.40 1.62
innodb prepared_select 37.00 -0.54% -0.20
36.00 37.00 36.80 0.40
innodb select_1_row 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb select_1_row_cache 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_2_rows 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_big 12.00 -0.00% 0.00
11.00 13.00 12.00 0.89
innodb select_big_str 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb select_cache 67.00 -6.01% -3.80
57.00 67.00 63.20 4.02
innodb select_cache2 64.00 -0.00% 0.00
61.00 67.00 64.00 2.00
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_diff_key 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_distinct 5.00 -4.17% -0.20
4.00 5.00 4.80 0.40
innodb select_group 18.00 -8.43% -1.40
15.00 18.00 16.60 1.36
innodb select_group_when_MANY_tables 12.00 +3.23% 0.40
12.00 14.00 12.40 0.80
innodb select_join 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_key 64.00 -0.31% -0.20
63.00 64.00 63.80 0.40
innodb select_key2 71.00 -0.85% -0.60
70.00 71.00 70.40 0.49
innodb select_key2_return_key 68.00 -0.59% -0.40
67.00 68.00 67.60 0.49
innodb select_key2_return_prim 69.00 -0.29% -0.20
68.00 69.00 68.80 0.40
innodb select_key_prefix 71.00 -1.14% -0.80
69.00 71.00 70.20 0.75
innodb select_key_prefix_join 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb select_key_return_key 63.00 -0.32% -0.20
62.00 63.00 62.80 0.40
innodb select_many_fields 14.00 -6.06% -0.80
13.00 14.00 13.20 0.40
innodb select_range 41.00 +0.97% 0.40
39.00 44.00 41.40 2.24
innodb select_range_key2 10.00 -0.00% 0.00
10.00 10.00 10.00 0.00
innodb select_range_prefix 9.00 -2.27% -0.20
8.00 9.00 8.80 0.40
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_cache 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb update_autocommit 3.00 +21.05% 0.80
3.00 4.00 3.80 0.40
innodb update_big 61.00 +0.33% 0.20
59.00 63.00 61.20 1.33
innodb update_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb update_of_key 21.00 +8.70% 2.00
21.00 24.00 23.00 1.10
innodb update_of_key_big 33.00 +5.17% 1.80
31.00 38.00 34.80 2.48
innodb update_of_primary_key_many_keys 1336.00 +1.71% 23.20
1315.00 1464.00 1359.20 53.36
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 119.00 +2.78% 3.40
118.00 127.00 122.40 3.44
innodb update_with_key_prefix 47.00 -5.86% -2.60
41.00 47.00 44.40 2.15
innodb wisc_benchmark 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 35.00 -7.53% -2.45
25.00 35.00 32.55 2.04
innodb alter_table_drop 23.00 +3.56% 0.85
22.00 26.00 23.85 0.96
innodb connect 2.00 +13.04% 0.30
2.00 3.00 2.30 0.46
innodb connect+select_1_row 3.00 -3.45% -0.10
2.00 3.00 2.90 0.30
innodb connect+select_simple 3.00 -17.65% -0.45
2.00 3.00 2.55 0.50
innodb count 17.00 -2.10% -0.35
13.00 19.00 16.65 1.77
innodb count_distinct 6.00 +12.41% 0.85
6.00 8.00 6.85 0.79
innodb count_distinct_2 14.00 -1.08% -0.15
11.00 16.00 13.85 1.42
innodb count_distinct_big 25.00 -8.70% -2.00
20.00 25.00 23.00 1.90
innodb count_distinct_group 15.00 -1.69% -0.25
13.00 16.00 14.75 0.77
innodb count_distinct_group_on_key 9.00 +5.26% 0.50
8.00 11.00 9.50 0.97
innodb count_distinct_group_on_key_parts 14.00 -4.87% -0.65
11.00 15.00 13.35 1.06
innodb count_distinct_key_prefix 6.00 -12.15% -0.65
5.00 6.00 5.35 0.48
innodb count_group_on_key_parts 11.00 -2.33% -0.25
10.00 11.00 10.75 0.43
innodb count_on_key 96.00 -4.23% -3.90
89.00 96.00 92.10 1.70
innodb create+drop 32.00 +3.47% 1.15
32.00 34.00 33.15 0.65
innodb create_index 3.00 +3.23% 0.10
3.00 4.00 3.10 0.30
innodb create_key+drop 31.00 +1.27% 0.40
30.00 33.00 31.40 0.86
innodb create_MANY_tables 22.00 -5.52% -1.15
20.00 22.00 20.85 0.73
innodb create_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb delete_all_many_keys 624.00 +2.98% 19.15
580.00 721.00 643.15 32.91
innodb delete_autocommit 3.00 +18.92% 0.70
3.00 5.00 3.70 0.56
innodb delete_big 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb delete_big_many_keys 623.00 +3.00% 19.25
580.00 719.00 642.25 32.65
innodb delete_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb delete_key 3.00 -13.21% -0.35
2.00 3.00 2.65 0.48
innodb delete_range 9.00 -2.86% -0.25
8.00 10.00 8.75 0.62
innodb delete_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb drop_index 3.00 -1.69% -0.05
2.00 4.00 2.95 0.50
innodb drop_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb drop_table_when_MANY_tables 20.00 -6.67% -1.25
17.00 22.00 18.75 1.13
innodb insert 114.00 -0.26% -0.30
111.00 116.00 113.70 1.38
innodb insert_autocommit 4.00 -29.03% -0.90
3.00 4.00 3.10 0.30
innodb insert_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb insert_duplicates 19.00 +0.52% 0.10
18.00 20.00 19.10 0.44
innodb insert_key 275.00 +1.03% 2.85
263.00 299.00 277.85 8.82
innodb insert_many_fields 5.00 +15.97% 0.95
5.00 7.00 5.95 0.38
innodb insert_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb insert_select_1_key 4.00 -3.90% -0.15
3.00 5.00 3.85 0.48
innodb insert_select_2_keys 7.00 -13.82% -0.85
5.00 8.00 6.15 0.73
innodb min_max 9.00 -13.92% -1.10
7.00 9.00 7.90 0.94
innodb min_max_on_key 25.00 -2.25% -0.55
23.00 25.00 24.45 0.59
innodb multiple_value_insert 7.00 -10.24% -0.65
5.00 8.00 6.35 0.73
innodb once_prepared_select 29.00 +0.17% 0.05
28.00 30.00 29.05 0.50
innodb order_by_big 12.00 +17.53% 2.55
12.00 16.00 14.55 1.07
innodb order_by_big_key 12.00 +14.59% 2.05
12.00 16.00 14.05 1.32
innodb order_by_big_key2 11.00 +14.06% 1.80
11.00 15.00 12.80 0.98
innodb order_by_big_key_desc 14.00 +5.08% 0.75
13.00 17.00 14.75 1.26
innodb order_by_big_key_diff 12.00 +6.61% 0.85
11.00 14.00 12.85 0.79
innodb order_by_big_key_prefix 12.00 +8.75% 1.15
12.00 14.00 13.15 0.65
innodb order_by_key2_diff 2.00 -53.85% -0.70
1.00 2.00 1.30 0.46
innodb order_by_key_prefix 1.00 -17.65% -0.15
0.00 1.00 0.85 0.36
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 24.00 -11.11% -2.40
17.00 24.00 21.60 2.46
innodb outer_join_found 22.00 -6.54% -1.35
16.00 23.00 20.65 2.50
innodb outer_join_not_found 21.00 -10.82% -2.05
15.00 23.00 18.95 2.38
innodb outer_join_on_key 16.00 -11.11% -1.60
11.00 17.00 14.40 1.66
innodb prepared_select 37.00 -0.00% 0.00
36.00 38.00 37.00 0.55
innodb select_1_row 3.00 +14.29% 0.50
3.00 4.00 3.50 0.50
innodb select_1_row_cache 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb select_2_rows 3.00 +18.92% 0.70
3.00 4.00 3.70 0.46
innodb select_big 12.00 +2.44% 0.30
11.00 15.00 12.30 1.00
innodb select_big_str 1.00 +23.08% 0.30
1.00 2.00 1.30 0.46
innodb select_cache 67.00 -5.10% -3.25
57.00 67.00 63.75 2.34
innodb select_cache2 64.00 -0.47% -0.30
59.00 68.00 63.70 2.57
innodb select_column+column 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb select_diff_key 0.00 +100.00% 0.30
0.00 1.00 0.30 0.46
innodb select_distinct 5.00 -9.89% -0.45
4.00 5.00 4.55 0.50
innodb select_group 18.00 -9.09% -1.50
15.00 19.00 16.50 1.53
innodb select_group_when_MANY_tables 12.00 -0.84% -0.10
11.00 14.00 11.90 0.77
innodb select_join 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb select_key 64.00 -0.16% -0.10
63.00 66.00 63.90 0.62
innodb select_key2 71.00 -0.42% -0.30
69.00 73.00 70.70 1.00
innodb select_key2_return_key 68.00 +0.15% 0.10
67.00 70.00 68.10 0.77
innodb select_key2_return_prim 69.00 -0.00% 0.00
67.00 71.00 69.00 0.89
innodb select_key_prefix 71.00 -0.85% -0.60
69.00 72.00 70.40 1.02
innodb select_key_prefix_join 5.00 +0.99% 0.05
5.00 6.00 5.05 0.22
innodb select_key_return_key 63.00 -0.32% -0.20
62.00 64.00 62.80 0.68
innodb select_many_fields 14.00 -5.66% -0.75
13.00 14.00 13.25 0.43
innodb select_range 41.00 +3.30% 1.40
39.00 46.00 42.40 2.60
innodb select_range_key2 10.00 -4.17% -0.40
8.00 10.00 9.60 0.58
innodb select_range_prefix 9.00 -0.56% -0.05
8.00 10.00 8.95 0.59
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_cache 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb select_simple_join 1.00 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb update_autocommit 3.00 +20.00% 0.75
3.00 5.00 3.75 0.54
innodb update_big 61.00 -3.65% -2.15
55.00 63.00 58.85 1.85
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 21.00 +6.25% 1.40
21.00 25.00 22.40 1.20
innodb update_of_key_big 33.00 +9.47% 3.45
31.00 45.00 36.45 3.32
innodb update_of_primary_key_many_keys 1336.00 -0.57% -7.55
1217.00 1465.00 1328.45 58.87
innodb update_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb update_with_key 119.00 +1.57% 1.90
115.00 127.00 120.90 2.90
innodb update_with_key_prefix 47.00 -6.46% -2.85
41.00 48.00 44.15 2.06
innodb wisc_benchmark 3.00 -17.65% -0.45
2.00 3.00 2.55 0.50
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 35.00 -64.26% -13.69
11.00 61.00 21.31 10.13
innodb alter_table_drop 23.00 -24.22% -4.48
10.00 57.00 18.52 6.93
innodb connect 2.00 +4.03% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -10.91% -0.30
2.00 5.00 2.70 0.47
innodb connect+select_simple 3.00 -27.56% -0.65
1.00 3.00 2.35 0.48
innodb count 17.00 -7.88% -1.24
12.00 193.00 15.76 8.73
innodb count_distinct 6.00 +8.71% 0.57
5.00 50.00 6.57 2.25
innodb count_distinct_2 14.00 -6.01% -0.79
11.00 63.00 13.21 2.93
innodb count_distinct_big 25.00 -13.88% -3.05
5.00 67.00 21.95 3.00
innodb count_distinct_group 15.00 -13.80% -1.82
10.00 68.00 13.18 3.06
innodb count_distinct_group_on_key 9.00 +5.27% 0.50
7.00 69.00 9.50 2.99
innodb count_distinct_group_on_key_parts 14.00 -13.39% -1.65
9.00 72.00 12.35 3.12
innodb count_distinct_key_prefix 6.00 -16.94% -0.87
3.00 52.00 5.13 2.36
innodb count_group_on_key_parts 11.00 -10.00% -1.00
7.00 72.00 10.00 3.12
innodb count_on_key 96.00 -11.45% -9.86
68.00 107.00 86.14 7.36
innodb create+drop 32.00 +1.40% 0.45
18.00 75.00 32.45 11.75
innodb create_index 3.00 -3.61% -0.10
1.00 8.00 2.90 1.13
innodb create_key+drop 31.00 -9.67% -2.73
21.00 50.00 28.27 4.88
innodb create_MANY_tables 22.00 +34.83% 11.76
14.00 121.00 33.76 17.01
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.36
innodb delete_all_many_keys 624.00 -33.19% -155.49
212.00 1888.00 468.51 361.43
innodb delete_autocommit 3.00 +13.01% 0.45
2.00 14.00 3.45 0.75
innodb delete_big 0.00 +100.00% 0.30
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 623.00 -31.31% -148.56
212.00 2293.00 474.44 375.36
innodb delete_commit 2.00 -31.64% -0.48
1.00 5.00 1.52 0.53
innodb delete_key 3.00 +1.53% 0.05
2.00 35.00 3.05 1.48
innodb delete_range 9.00 -8.16% -0.68
5.00 23.00 8.32 3.20
innodb delete_rollback 2.00 -14.58% -0.25
1.00 12.00 1.75 0.91
innodb drop_index 3.00 -1.65% -0.05
1.00 9.00 2.95 1.31
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.23
innodb drop_table_when_MANY_tables 20.00 -2.28% -0.44
11.00 90.00 19.56 7.45
innodb insert 114.00 -6.68% -7.14
3.00 343.00 106.86 14.47
innodb insert_autocommit 4.00 -33.23% -1.00
2.00 99.00 3.00 3.28
innodb insert_commit 2.00 -44.03% -0.61
1.00 3.00 1.39 0.50
innodb insert_duplicates 19.00 -22.26% -3.46
11.00 21.00 15.54 2.68
innodb insert_key 275.00 +9.12% 27.60
142.00 700.00 302.60 105.81
innodb insert_many_fields 5.00 +10.90% 0.61
3.00 17.00 5.61 1.75
innodb insert_rollback 2.00 -19.32% -0.32
1.00 3.00 1.68 0.53
innodb insert_select_1_key 4.00 -5.71% -0.22
2.00 10.00 3.78 0.88
innodb insert_select_2_keys 7.00 -15.22% -0.92
4.00 16.00 6.08 2.07
innodb min_max 9.00 -14.95% -1.17
6.00 110.00 7.83 4.50
innodb min_max_on_key 25.00 -21.20% -4.37
14.00 37.00 20.63 3.11
innodb multiple_value_insert 7.00 -27.84% -1.52
2.00 50.00 5.48 4.24
innodb once_prepared_select 29.00 -19.29% -4.69
18.00 32.00 24.31 3.60
innodb order_by_big 12.00 +16.19% 2.32
12.00 31.00 14.32 1.52
innodb order_by_big_key 12.00 +9.77% 1.30
11.00 32.00 13.30 1.64
innodb order_by_big_key2 11.00 +9.97% 1.22
10.00 33.00 12.22 1.54
innodb order_by_big_key_desc 14.00 -3.46% -0.47
11.00 32.00 13.53 1.69
innodb order_by_big_key_diff 12.00 +2.00% 0.24
10.00 31.00 12.24 1.50
innodb order_by_big_key_prefix 12.00 +3.37% 0.42
10.00 32.00 12.42 1.55
innodb order_by_key2_diff 2.00 -43.16% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -26.11% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -19.92% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 24.00 -23.79% -4.61
15.00 61.00 19.39 3.71
innodb outer_join_found 22.00 -16.97% -3.19
14.00 58.00 18.81 3.57
innodb outer_join_not_found 21.00 -27.15% -4.48
12.00 46.00 16.52 3.18
innodb outer_join_on_key 16.00 -23.67% -3.06
10.00 59.00 12.94 2.76
innodb prepared_select 37.00 -17.69% -5.56
22.00 40.00 31.44 4.54
innodb select_1_row 3.00 -4.76% -0.14
2.00 4.00 2.86 0.69
innodb select_1_row_cache 4.00 -48.25% -1.30
2.00 4.00 2.70 0.69
innodb select_2_rows 3.00 -3.73% -0.11
2.00 4.00 2.89 0.70
innodb select_big 12.00 +1.40% 0.17
0.00 31.00 12.17 1.54
innodb select_big_str 1.00 +14.37% 0.17
0.00 2.00 1.17 0.38
innodb select_cache 67.00 -12.20% -7.29
49.00 77.00 59.71 5.62
innodb select_cache2 64.00 -6.57% -3.95
49.00 75.00 60.05 6.25
innodb select_column+column 4.00 -36.06% -1.06
2.00 4.00 2.94 0.72
innodb select_diff_key 0.00 +100.00% 0.22
0.00 1.00 0.22 0.41
innodb select_distinct 5.00 -17.84% -0.76
3.00 8.00 4.24 0.55
innodb select_group 18.00 -10.64% -1.73
4.00 136.00 16.27 5.38
innodb select_group_when_MANY_tables 12.00 -26.08% -2.48
3.00 49.00 9.52 9.36
innodb select_join 0.00 +100.00% 0.58
0.00 1.00 0.58 0.49
innodb select_key 64.00 -20.81% -11.03
40.00 66.00 52.97 7.53
innodb select_key2 71.00 -18.99% -11.33
45.00 75.00 59.67 8.36
innodb select_key2_return_key 68.00 -19.31% -11.00
42.00 71.00 57.00 8.17
innodb select_key2_return_prim 69.00 -19.46% -11.24
42.00 72.00 57.76 8.31
innodb select_key_prefix 71.00 -20.48% -12.07
44.00 75.00 58.93 8.39
innodb select_key_prefix_join 5.00 -5.79% -0.27
3.00 10.00 4.73 0.65
innodb select_key_return_key 63.00 -21.16% -11.00
38.00 65.00 52.00 7.54
innodb select_many_fields 14.00 +6.09% 0.91
11.00 19.00 14.91 1.79
innodb select_range 41.00 +12.67% 5.95
38.00 76.00 46.95 4.04
innodb select_range_key2 10.00 -20.69% -1.71
6.00 11.00 8.29 1.05
innodb select_range_prefix 9.00 -14.47% -1.14
5.00 10.00 7.86 1.12
innodb select_simple 2.00 -20.93% -0.35
1.00 3.00 1.65 0.51
innodb select_simple_cache 2.00 -27.87% -0.44
1.00 3.00 1.56 0.51
innodb select_simple_join 1.00 -50.86% -0.34
0.00 3.00 0.66 0.48
innodb update_autocommit 3.00 +10.17% 0.34
2.00 16.00 3.34 1.01
innodb update_big 61.00 -19.25% -9.85
31.00 195.00 51.15 24.24
innodb update_commit 2.00 -27.35% -0.43
1.00 10.00 1.57 0.72
innodb update_of_key 21.00 +13.21% 3.20
18.00 100.00 24.20 6.11
innodb update_of_key_big 33.00 -19.47% -5.38
15.00 75.00 27.62 10.93
innodb update_of_primary_key_many_keys 1336.00 -7.48% -92.99
647.00 6065.00 1243.01 946.57
innodb update_rollback 2.00 -13.26% -0.23
1.00 31.00 1.77 1.88
innodb update_with_key 119.00 -8.10% -8.91
90.00 598.00 110.09 20.64
innodb update_with_key_prefix 47.00 -18.30% -7.27
33.00 202.00 39.73 6.79
innodb wisc_benchmark 3.00 -21.32% -0.53
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2226.1.14: Monty Taylor 2011-03-09 Removed unused file.
2226.1.13: Monty Taylor 2011-03-09 Removed blackhole.
2226.1.12: Monty Taylor 2011-03-09 Removed the last archive test.
2226.1.11: Monty Taylor 2011-03-09 And a couple of files in potfiles...
2226.1.10: Monty Taylor 2011-03-08 Got rid of archive engine.
2226.1.9: Monty Taylor 2011-03-08 Replaced a needed file.
2226.1.8: Monty Taylor 2011-03-08 Shoved archive back in- killed filesystem
engine.
2226.1.7: Monty Taylor 2011-03-08 Removed some plugins that we're just really
not using anymore.
2226.1.6: Monty Taylor 2011-03-08 Moved drizzle/drizzle.h to
libdrizzle/libdrizzle.h - we don't have a drizzle
2226.1.5: Monty Taylor 2011-03-08 [merge] Merged David - Filtered Replication
Docs.
2224.3.3: David Shrewsbury 2011-03-08 Fix option name.
2224.3.2: David Shrewsbury 2011-03-08 Add filtered replicator plugin docs.
2224.3.1: David Shrewsbury 2011-03-08 Add documentation about replication
streams.
2226.1.4: Monty Taylor 2011-03-08 [merge] Merged Olaf - Statement refactor.
2224.2.9: Olaf van der Spek 2011-03-08 Statement::set_command
2224.2.8: Olaf van der Spek 2011-03-08 Statement::lex()
2224.2.7: Olaf van der Spek 2011-03-08 Statement::set_command
2224.2.6: Olaf van der Spek 2011-03-08 Statement::set_command
2224.2.5: Olaf van der Spek 2011-03-08 Undo partial commit
2224.2.4: Olaf van der Spek 2011-03-08 Undo partial commit
2224.2.3: Olaf van der Spek 2011-03-08 Refactor
2224.2.2: Olaf van der Spek 2011-03-08 Refactor
2224.2.1: Olaf van der Spek 2011-03-08 Refactor
2226.1.3: Monty Taylor 2011-03-08 [merge] Merge Olaf - XID refactor.
2224.1.1: Olaf van der Spek 2011-03-08 Finish removing XID cache
2226.1.2: Monty Taylor 2011-03-08 [merge] Merged Olaf - refactor
Session::getLex
2221.11.1: Olaf van der Spek 2011-03-08 Session::getLex()
2226.1.1: Monty Taylor 2011-03-08 [merge] Merged drizzle/drizzle.h from Olaf.
2221.10.1: Olaf van der Spek 2011-03-06 Provide drizzle/drizzle.h
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
