=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 946
RUN DATE: 2011-03-08T01:20:18.376121
SERVER: drizzled
VERSION: staging
REVISION: 2224
COMMENT: 2224: Monty Taylor 2011-03-07 [merge] Merge Olaf - XID and
Dynamic_array refactoring
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -0.00% 0.00
32.00 34.00 33.00 0.63
innodb alter_table_drop 25.00 -5.04% -1.20
22.00 25.00 23.80 1.17
innodb connect 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb connect+select_1_row 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb connect+select_simple 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb count 18.00 -7.14% -1.20
14.00 18.00 16.80 1.47
innodb count_distinct 6.00 +11.76% 0.80
6.00 8.00 6.80 0.75
innodb count_distinct_2 13.00 +4.41% 0.60
13.00 15.00 13.60 0.80
innodb count_distinct_big 24.00 -10.09% -2.20
20.00 24.00 21.80 1.83
innodb count_distinct_group 13.00 +9.72% 1.40
13.00 15.00 14.40 0.80
innodb count_distinct_group_on_key 9.00 -0.00% 0.00
8.00 10.00 9.00 0.63
innodb count_distinct_group_on_key_parts 14.00 -9.38% -1.20
11.00 14.00 12.80 1.47
innodb count_distinct_key_prefix 5.00 +7.41% 0.40
5.00 6.00 5.40 0.49
innodb count_group_on_key_parts 11.00 -3.77% -0.40
10.00 11.00 10.60 0.49
innodb count_on_key 92.00 -0.66% -0.60
90.00 92.00 91.40 0.80
innodb create+drop 33.00 -0.00% 0.00
32.00 34.00 33.00 0.63
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
31.00 32.00 31.40 0.49
innodb create_MANY_tables 20.00 +0.99% 0.20
20.00 21.00 20.20 0.40
innodb delete_all_many_keys 624.00 +0.54% 3.40
608.00 663.00 627.40 18.74
innodb delete_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb delete_big 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb delete_big_many_keys 623.00 +0.57% 3.60
608.00 662.00 626.60 18.53
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb delete_range 10.00 -13.64% -1.20
8.00 10.00 8.80 0.75
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 3.00 -0.00% 0.00
2.00 4.00 3.00 0.63
innodb drop_table_when_MANY_tables 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb insert 111.00 +1.77% 2.00
111.00 114.00 113.00 1.10
innodb insert_autocommit 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb insert_commit 1.00 +44.44% 0.80
1.00 2.00 1.80 0.40
innodb insert_duplicates 20.00 -5.26% -1.00
18.00 20.00 19.00 0.63
innodb insert_key 273.00 +0.36% 1.00
268.00 278.00 274.00 3.41
innodb insert_many_fields 7.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 +4.76% 0.20
4.00 5.00 4.20 0.40
innodb insert_select_2_keys 7.00 -16.67% -1.00
5.00 7.00 6.00 0.63
innodb min_max 9.00 -7.14% -0.60
7.00 9.00 8.40 0.80
innodb min_max_on_key 24.00 +1.64% 0.40
24.00 25.00 24.40 0.49
innodb multiple_value_insert 6.00 -3.45% -0.20
5.00 6.00 5.80 0.40
innodb once_prepared_select 29.00 +0.68% 0.20
29.00 30.00 29.20 0.40
innodb order_by_big 15.00 -5.63% -0.80
13.00 15.00 14.20 0.98
innodb order_by_big_key 13.00 +12.16% 1.80
13.00 16.00 14.80 1.17
innodb order_by_big_key2 14.00 -6.06% -0.80
13.00 14.00 13.20 0.40
innodb order_by_big_key_desc 13.00 +14.47% 2.20
13.00 17.00 15.20 1.33
innodb order_by_big_key_diff 13.00 -1.56% -0.20
12.00 13.00 12.80 0.40
innodb order_by_big_key_prefix 14.00 -4.48% -0.60
13.00 14.00 13.40 0.49
innodb order_by_key2_diff 2.00 -66.67% -0.80
1.00 2.00 1.20 0.40
innodb order_by_key_prefix 0.00 +100.00% 0.80
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 18.00 +18.18% 4.00
18.00 24.00 22.00 2.19
innodb outer_join_found 17.00 +19.81% 4.20
17.00 23.00 21.20 2.23
innodb outer_join_not_found 16.00 +18.37% 3.60
16.00 22.00 19.60 2.06
innodb outer_join_on_key 12.00 +17.81% 2.60
12.00 16.00 14.60 1.50
innodb prepared_select 36.00 +2.70% 1.00
36.00 38.00 37.00 0.63
innodb select_1_row 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_1_row_cache 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb select_2_rows 3.00 +21.05% 0.80
3.00 4.00 3.80 0.40
innodb select_big 11.00 +9.84% 1.20
11.00 15.00 12.20 1.60
innodb select_big_str 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb select_cache 60.00 +6.54% 4.20
60.00 67.00 64.20 2.48
innodb select_cache2 63.00 +2.78% 1.80
63.00 67.00 64.80 1.60
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_distinct 5.00 -4.17% -0.20
4.00 5.00 4.80 0.40
innodb select_group 15.00 +8.54% 1.40
15.00 19.00 16.40 1.74
innodb select_group_when_MANY_tables 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb select_join 0.00 +100.00% 0.40
0.00 1.00 0.40 0.49
innodb select_key 63.00 +1.25% 0.80
63.00 64.00 63.80 0.40
innodb select_key2 70.00 +1.41% 1.00
70.00 72.00 71.00 0.89
innodb select_key2_return_key 67.00 +1.76% 1.20
67.00 69.00 68.20 0.98
innodb select_key2_return_prim 69.00 +0.86% 0.60
69.00 70.00 69.60 0.49
innodb select_key_prefix 70.00 +1.41% 1.00
70.00 72.00 71.00 0.89
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.00% 0.00
63.00 63.00 63.00 0.00
innodb select_many_fields 13.00 +2.99% 0.40
13.00 14.00 13.40 0.49
innodb select_range 39.00 +8.88% 3.80
39.00 46.00 42.80 2.48
innodb select_range_key2 10.00 -0.00% 0.00
10.00 10.00 10.00 0.00
innodb select_range_prefix 9.00 -0.00% 0.00
9.00 9.00 9.00 0.00
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 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb update_big 61.00 -3.39% -2.00
58.00 61.00 59.00 1.10
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 24.00 -1.69% -0.40
21.00 25.00 23.60 1.36
innodb update_of_key_big 38.00 -1.06% -0.40
31.00 45.00 37.60 4.45
innodb update_of_primary_key_many_keys 1315.00 +0.24% 3.20
1284.00 1346.00 1318.20 20.48
innodb update_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb update_with_key 125.00 -2.12% -2.60
119.00 126.00 122.40 2.94
innodb update_with_key_prefix 46.00 -5.99% -2.60
41.00 46.00 43.40 1.85
innodb wisc_benchmark 3.00 -25.00% -0.60
2.00 3.00 2.40 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -0.76% -0.25
31.00 34.00 32.75 1.04
innodb alter_table_drop 25.00 -4.38% -1.05
22.00 26.00 23.95 0.97
innodb connect 2.00 +11.11% 0.25
2.00 3.00 2.25 0.43
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 18.00 -10.09% -1.65
13.00 19.00 16.35 2.01
innodb count_distinct 6.00 +11.76% 0.80
6.00 8.00 6.80 0.75
innodb count_distinct_2 13.00 +5.45% 0.75
11.00 16.00 13.75 1.37
innodb count_distinct_big 24.00 -5.96% -1.35
20.00 25.00 22.65 1.82
innodb count_distinct_group 13.00 +11.56% 1.70
13.00 16.00 14.70 0.84
innodb count_distinct_group_on_key 9.00 +7.22% 0.70
8.00 12.00 9.70 1.05
innodb count_distinct_group_on_key_parts 14.00 -6.06% -0.80
11.00 15.00 13.20 1.08
innodb count_distinct_key_prefix 5.00 +4.76% 0.25
5.00 6.00 5.25 0.43
innodb count_group_on_key_parts 11.00 -2.33% -0.25
10.00 11.00 10.75 0.43
innodb count_on_key 92.00 +0.05% 0.05
89.00 95.00 92.05 1.66
innodb create+drop 33.00 +0.45% 0.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.43% 0.45
30.00 33.00 31.45 0.74
innodb create_MANY_tables 20.00 +3.38% 0.70
20.00 22.00 20.70 0.64
innodb create_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb delete_all_many_keys 624.00 +3.33% 21.50
580.00 721.00 645.50 33.86
innodb delete_autocommit 4.00 -8.11% -0.30
3.00 5.00 3.70 0.56
innodb delete_big 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb delete_big_many_keys 623.00 +3.35% 21.60
580.00 719.00 644.60 33.60
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 10.00 -13.64% -1.20
8.00 10.00 8.80 0.60
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
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.10
0.00 1.00 0.10 0.30
innodb drop_table_when_MANY_tables 18.00 +3.49% 0.65
17.00 22.00 18.65 1.06
innodb insert 111.00 +2.25% 2.55
111.00 116.00 113.55 1.28
innodb insert_autocommit 4.00 -29.03% -0.90
3.00 4.00 3.10 0.30
innodb insert_commit 1.00 +47.37% 0.90
1.00 2.00 1.90 0.30
innodb insert_duplicates 20.00 -4.71% -0.90
18.00 20.00 19.10 0.44
innodb insert_key 273.00 +1.78% 4.95
263.00 300.00 277.95 8.94
innodb insert_many_fields 7.00 -16.67% -1.00
5.00 7.00 6.00 0.32
innodb insert_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb insert_select_1_key 4.00 -2.56% -0.10
3.00 5.00 3.90 0.54
innodb insert_select_2_keys 7.00 -12.00% -0.75
5.00 8.00 6.25 0.70
innodb min_max 9.00 -12.50% -1.00
7.00 9.00 8.00 0.95
innodb min_max_on_key 24.00 +2.24% 0.55
24.00 26.00 24.55 0.59
innodb multiple_value_insert 6.00 +4.76% 0.30
5.00 8.00 6.30 0.71
innodb once_prepared_select 29.00 +0.51% 0.15
28.00 30.00 29.15 0.48
innodb order_by_big 15.00 -1.69% -0.25
13.00 16.00 14.75 0.94
innodb order_by_big_key 13.00 +7.80% 1.10
12.00 16.00 14.10 1.30
innodb order_by_big_key2 14.00 -8.11% -1.05
11.00 15.00 12.95 0.92
innodb order_by_big_key_desc 13.00 +11.86% 1.75
13.00 17.00 14.75 1.26
innodb order_by_big_key_diff 13.00 -0.00% 0.00
11.00 14.00 13.00 0.84
innodb order_by_big_key_prefix 14.00 -5.66% -0.75
12.00 14.00 13.25 0.62
innodb order_by_key2_diff 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb order_by_key_prefix 0.00 +100.00% 0.85
0.00 1.00 0.85 0.36
innodb order_by_range 1.00 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 18.00 +16.67% 3.60
17.00 24.00 21.60 2.48
innodb outer_join_found 17.00 +17.68% 3.65
16.00 23.00 20.65 2.50
innodb outer_join_not_found 16.00 +15.79% 3.00
15.00 23.00 19.00 2.47
innodb outer_join_on_key 12.00 +17.53% 2.55
11.00 17.00 14.55 1.66
innodb prepared_select 36.00 +2.83% 1.05
36.00 38.00 37.05 0.59
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 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb select_big 11.00 +12.00% 1.50
11.00 15.00 12.50 1.20
innodb select_big_str 2.00 -53.85% -0.70
1.00 2.00 1.30 0.46
innodb select_cache 60.00 +4.91% 3.10
57.00 67.00 63.10 2.51
innodb select_cache2 63.00 +0.32% 0.20
57.00 68.00 63.20 2.94
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.25
0.00 1.00 0.25 0.43
innodb select_distinct 5.00 -9.89% -0.45
4.00 5.00 4.55 0.50
innodb select_group 15.00 +7.12% 1.15
15.00 19.00 16.15 1.49
innodb select_group_when_MANY_tables 12.00 -1.27% -0.15
11.00 13.00 11.85 0.65
innodb select_join 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb select_key 63.00 +1.33% 0.85
63.00 66.00 63.85 0.65
innodb select_key2 70.00 +1.06% 0.75
69.00 73.00 70.75 1.04
innodb select_key2_return_key 67.00 +1.76% 1.20
67.00 70.00 68.20 0.81
innodb select_key2_return_prim 69.00 +0.07% 0.05
67.00 71.00 69.05 0.92
innodb select_key_prefix 70.00 +0.50% 0.35
69.00 72.00 70.35 1.01
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 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 39.00 +8.02% 3.40
39.00 46.00 42.40 2.48
innodb select_range_key2 10.00 -5.26% -0.50
8.00 10.00 9.50 0.59
innodb select_range_prefix 9.00 +1.10% 0.10
8.00 10.00 9.10 0.62
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 4.00 -5.26% -0.20
3.00 5.00 3.80 0.51
innodb update_big 61.00 -4.27% -2.50
55.00 62.00 58.50 1.50
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 24.00 -6.67% -1.50
21.00 25.00 22.50 1.20
innodb update_of_key_big 38.00 -3.83% -1.40
31.00 45.00 36.60 3.34
innodb update_of_primary_key_many_keys 1315.00 +0.92% 12.20
1217.00 1465.00 1327.20 58.99
innodb update_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb update_with_key 125.00 -3.52% -4.25
115.00 126.00 120.75 2.53
innodb update_with_key_prefix 46.00 -4.19% -1.85
41.00 48.00 44.15 1.96
innodb wisc_benchmark 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -55.12% -11.73
11.00 61.00 21.27 10.13
innodb alter_table_drop 25.00 -35.14% -6.50
10.00 57.00 18.50 6.94
innodb connect 2.00 +3.99% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -10.95% -0.30
2.00 5.00 2.70 0.47
innodb connect+select_simple 3.00 -27.62% -0.65
1.00 3.00 2.35 0.48
innodb count 18.00 -14.26% -2.25
12.00 193.00 15.75 8.74
innodb count_distinct 6.00 +8.71% 0.57
5.00 50.00 6.57 2.25
innodb count_distinct_2 13.00 +1.52% 0.20
11.00 63.00 13.20 2.93
innodb count_distinct_big 24.00 -9.37% -2.06
5.00 67.00 21.94 3.00
innodb count_distinct_group 13.00 +1.33% 0.18
10.00 68.00 13.18 3.07
innodb count_distinct_group_on_key 9.00 +5.28% 0.50
7.00 69.00 9.50 2.99
innodb count_distinct_group_on_key_parts 14.00 -13.44% -1.66
9.00 72.00 12.34 3.13
innodb count_distinct_key_prefix 5.00 +2.49% 0.13
3.00 52.00 5.13 2.36
innodb count_group_on_key_parts 11.00 -10.03% -1.00
7.00 72.00 10.00 3.12
innodb count_on_key 92.00 -6.84% -5.89
68.00 107.00 86.11 7.36
innodb create+drop 33.00 -1.69% -0.55
18.00 75.00 32.45 11.77
innodb create_index 3.00 -3.62% -0.10
1.00 8.00 2.90 1.13
innodb create_key+drop 31.00 -9.71% -2.74
21.00 50.00 28.26 4.89
innodb create_MANY_tables 20.00 +40.83% 13.80
14.00 121.00 33.80 17.03
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.38% -156.15
212.00 1888.00 467.85 361.91
innodb delete_autocommit 4.00 -15.97% -0.55
2.00 14.00 3.45 0.75
innodb delete_big 1.00 -232.20% -0.70
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 623.00 -31.49% -149.20
212.00 2293.00 473.80 375.88
innodb delete_commit 2.00 -31.78% -0.48
1.00 5.00 1.52 0.53
innodb delete_key 3.00 +1.57% 0.05
2.00 35.00 3.05 1.48
innodb delete_range 10.00 -20.20% -1.68
5.00 23.00 8.32 3.21
innodb delete_rollback 2.00 -14.72% -0.26
1.00 12.00 1.74 0.91
innodb drop_index 3.00 -1.70% -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 18.00 +7.96% 1.56
11.00 90.00 19.56 7.46
innodb insert 111.00 -3.90% -4.17
3.00 343.00 106.83 14.48
innodb insert_autocommit 4.00 -33.28% -1.00
2.00 99.00 3.00 3.28
innodb insert_commit 1.00 +27.88% 0.39
1.00 3.00 1.39 0.50
innodb insert_duplicates 20.00 -28.80% -4.47
11.00 21.00 15.53 2.67
innodb insert_key 273.00 +9.80% 29.67
142.00 700.00 302.67 106.00
innodb insert_many_fields 7.00 -24.74% -1.39
3.00 17.00 5.61 1.76
innodb insert_rollback 2.00 -19.40% -0.32
1.00 3.00 1.68 0.53
innodb insert_select_1_key 4.00 -5.73% -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.96% -1.17
6.00 110.00 7.83 4.50
innodb min_max_on_key 24.00 -16.42% -3.39
14.00 37.00 20.61 3.10
innodb multiple_value_insert 6.00 -9.68% -0.53
2.00 50.00 5.47 4.25
innodb once_prepared_select 29.00 -19.36% -4.70
18.00 32.00 24.30 3.60
innodb order_by_big 15.00 -4.76% -0.68
12.00 31.00 14.32 1.52
innodb order_by_big_key 13.00 +2.23% 0.30
11.00 32.00 13.30 1.64
innodb order_by_big_key2 14.00 -14.60% -1.78
10.00 33.00 12.22 1.54
innodb order_by_big_key_desc 13.00 +3.88% 0.53
11.00 32.00 13.53 1.69
innodb order_by_big_key_diff 13.00 -6.18% -0.76
10.00 31.00 12.24 1.50
innodb order_by_big_key_prefix 14.00 -12.75% -1.58
10.00 32.00 12.42 1.55
innodb order_by_key2_diff 2.00 -43.14% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 0.00 +100.00% 0.79
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -20.00% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 18.00 +7.09% 1.37
15.00 61.00 19.37 3.71
innodb outer_join_found 17.00 +9.55% 1.79
14.00 58.00 18.79 3.57
innodb outer_join_not_found 16.00 +3.04% 0.50
12.00 46.00 16.50 3.18
innodb outer_join_on_key 12.00 +7.20% 0.93
10.00 59.00 12.93 2.77
innodb prepared_select 36.00 -14.58% -4.58
22.00 40.00 31.42 4.53
innodb select_1_row 3.00 -4.81% -0.14
2.00 4.00 2.86 0.69
innodb select_1_row_cache 4.00 -48.44% -1.31
2.00 4.00 2.69 0.69
innodb select_2_rows 3.00 -3.82% -0.11
2.00 4.00 2.89 0.70
innodb select_big 11.00 +9.60% 1.17
0.00 31.00 12.17 1.54
innodb select_big_str 2.00 -71.34% -0.83
0.00 2.00 1.17 0.38
innodb select_cache 60.00 -0.50% -0.30
49.00 77.00 59.70 5.62
innodb select_cache2 63.00 -4.93% -2.96
49.00 75.00 60.04 6.25
innodb select_column+column 4.00 -36.18% -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.88% -0.76
3.00 8.00 4.24 0.55
innodb select_group 15.00 +7.77% 1.26
4.00 136.00 16.26 5.39
innodb select_group_when_MANY_tables 12.00 -26.22% -2.49
3.00 49.00 9.51 9.38
innodb select_join 0.00 +100.00% 0.58
0.00 1.00 0.58 0.49
innodb select_key 63.00 -19.01% -10.06
40.00 66.00 52.94 7.52
innodb select_key2 70.00 -17.39% -10.37
45.00 75.00 59.63 8.35
innodb select_key2_return_key 67.00 -17.63% -10.04
42.00 71.00 56.96 8.15
innodb select_key2_return_prim 69.00 -19.54% -11.28
42.00 72.00 57.72 8.30
innodb select_key_prefix 70.00 -18.86% -11.11
44.00 75.00 58.89 8.38
innodb select_key_prefix_join 5.00 -5.81% -0.27
3.00 10.00 4.73 0.65
innodb select_key_return_key 63.00 -21.24% -11.04
38.00 65.00 51.96 7.53
innodb select_many_fields 13.00 +12.83% 1.91
11.00 19.00 14.91 1.79
innodb select_range 39.00 +16.97% 7.97
38.00 76.00 46.97 4.03
innodb select_range_key2 10.00 -20.78% -1.72
6.00 11.00 8.28 1.05
innodb select_range_prefix 9.00 -14.51% -1.14
5.00 10.00 7.86 1.12
innodb select_simple 2.00 -21.02% -0.35
1.00 3.00 1.65 0.51
innodb select_simple_cache 2.00 -27.99% -0.44
1.00 3.00 1.56 0.51
innodb select_simple_join 1.00 -51.12% -0.34
0.00 3.00 0.66 0.48
innodb update_autocommit 4.00 -19.81% -0.66
2.00 16.00 3.34 1.01
innodb update_big 61.00 -19.34% -9.88
31.00 195.00 51.12 24.28
innodb update_commit 2.00 -27.38% -0.43
1.00 10.00 1.57 0.72
innodb update_of_key 24.00 +0.84% 0.20
18.00 100.00 24.20 6.12
innodb update_of_key_big 38.00 -37.70% -10.40
15.00 75.00 27.60 10.94
innodb update_of_primary_key_many_keys 1315.00 -5.84% -72.59
647.00 6065.00 1242.41 948.59
innodb update_rollback 2.00 -13.31% -0.23
1.00 31.00 1.77 1.88
innodb update_with_key 125.00 -13.59% -14.95
90.00 598.00 110.05 20.66
innodb update_with_key_prefix 46.00 -15.84% -6.29
33.00 202.00 39.71 6.80
innodb wisc_benchmark 3.00 -21.41% -0.53
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2223.1.3: Monty Taylor 2011-03-07 [merge] Merge Olaf - Refactor DYNAMIC_ARRAY
2221.7.6: Olaf van der Spek 2011-03-07 Remove unused includes
2221.7.5: Olaf van der Spek 2011-03-07 Refactor
2221.7.4: Olaf van der Spek 2011-03-06 Refactor
2221.7.3: Olaf van der Spek 2011-03-06 Refactor
2221.7.2: Olaf van der Spek 2011-03-06 Refactor
2221.7.1: Olaf van der Spek 2011-03-06 DYNAMIC_ARRAY::size()
2223.1.2: Monty Taylor 2011-03-07 [merge] Merged Andrew- Optimizer bugfixes
2131.13.2: Andrew Hutchings 2011-03-07 [merge] Merge trunk into branch
2131.13.1: Andrew Hutchings 2011-01-31 Backport fix from
http://bugs.mysql.com/bug.php?id=58818
2223.1.1: Monty Taylor 2011-03-07 [merge] Merged Olaf - Refactor XID cache.
2221.6.3: Olaf van der Spek 2011-03-07 Remove (apparently) unused XID cache
2221.6.2: Olaf van der Spek 2011-03-07 Refactor
2221.6.1: Olaf van der Spek 2011-03-07 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
