=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 1002
RUN DATE: 2011-04-13T17:29:47.449331
SERVER: drizzled
VERSION: staging
REVISION: 2277
COMMENT: 2277: Lee Bieber 2011-04-13 [merge] Merge Olaf - Refactor Program
Options usage
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -0.63% -0.20
30.00 34.00 31.80 1.33
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 -6.25% -1.00
13.00 18.00 16.00 2.10
innodb count_distinct 6.00 +9.09% 0.60
6.00 8.00 6.60 0.80
innodb count_distinct_2 15.00 -15.38% -2.00
12.00 15.00 13.00 1.10
innodb count_distinct_big 25.00 -8.70% -2.00
20.00 25.00 23.00 2.10
innodb count_distinct_group 16.00 -11.11% -1.60
12.00 16.00 14.40 1.36
innodb count_distinct_group_on_key 11.00 -17.02% -1.60
8.00 11.00 9.40 1.02
innodb count_distinct_group_on_key_parts 14.00 -4.48% -0.60
11.00 15.00 13.40 1.36
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
4.00 6.00 5.20 0.75
innodb count_group_on_key_parts 11.00 -1.85% -0.20
10.00 11.00 10.80 0.40
innodb count_on_key 98.00 -1.66% -1.60
92.00 103.00 96.40 3.83
innodb create+drop 33.00 -1.23% -0.40
31.00 34.00 32.60 1.02
innodb create_index 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb create_key+drop 33.00 -3.13% -1.00
28.00 36.00 32.00 2.76
innodb create_MANY_tables 21.00 -0.96% -0.20
20.00 22.00 20.80 0.75
innodb delete_all_many_keys 756.00 +16.76% 152.20
756.00 1045.00 908.20 123.96
innodb delete_autocommit 3.00 +21.05% 0.80
3.00 4.00 3.80 0.40
innodb delete_big 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 756.00 +16.72% 151.80
756.00 1045.00 907.80 123.60
innodb delete_commit 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb delete_key 2.00 +28.57% 0.80
2.00 3.00 2.80 0.40
innodb delete_range 8.00 +2.44% 0.20
8.00 9.00 8.20 0.40
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 19.00 -0.00% 0.00
18.00 20.00 19.00 0.63
innodb insert 112.00 -0.00% 0.00
111.00 113.00 112.00 0.63
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_duplicates 19.00 +1.04% 0.20
19.00 20.00 19.20 0.40
innodb insert_key 274.00 +2.21% 6.20
264.00 307.00 280.20 14.40
innodb insert_many_fields 6.00 -0.00% 0.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 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb insert_select_2_keys 6.00 +3.23% 0.20
6.00 7.00 6.20 0.40
innodb min_max 8.00 -2.56% -0.20
6.00 9.00 7.80 1.17
innodb min_max_on_key 25.00 -1.63% -0.40
24.00 25.00 24.60 0.49
innodb multiple_value_insert 6.00 -0.00% 0.00
5.00 7.00 6.00 0.63
innodb once_prepared_select 29.00 -0.69% -0.20
28.00 29.00 28.80 0.40
innodb order_by_big 14.00 +4.11% 0.60
14.00 15.00 14.60 0.49
innodb order_by_big_key 15.00 +3.85% 0.60
15.00 16.00 15.60 0.49
innodb order_by_big_key2 12.00 +6.25% 0.80
11.00 14.00 12.80 1.17
innodb order_by_big_key_desc 16.00 -2.56% -0.40
14.00 16.00 15.60 0.80
innodb order_by_big_key_diff 12.00 +7.69% 1.00
12.00 14.00 13.00 0.63
innodb order_by_big_key_prefix 14.00 -9.38% -1.20
12.00 14.00 12.80 0.75
innodb order_by_key2_diff 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
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 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb outer_join 25.00 -8.70% -2.00
17.00 26.00 23.00 3.16
innodb outer_join_found 24.00 -10.09% -2.20
17.00 24.00 21.80 2.56
innodb outer_join_not_found 22.00 -13.40% -2.60
15.00 22.00 19.40 2.42
innodb outer_join_on_key 17.00 -11.84% -1.80
12.00 17.00 15.20 1.83
innodb prepared_select 36.00 +1.64% 0.60
36.00 37.00 36.60 0.49
innodb select_1_row 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_1_row_cache 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb select_2_rows 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_big 13.00 +2.99% 0.40
12.00 15.00 13.40 1.02
innodb select_big_str 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb select_cache 64.00 +0.31% 0.20
62.00 67.00 64.20 1.72
innodb select_cache2 66.00 -5.10% -3.20
61.00 66.00 62.80 1.72
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_distinct 4.00 +9.09% 0.40
4.00 5.00 4.40 0.49
innodb select_group 19.00 -13.10% -2.20
15.00 19.00 16.80 1.60
innodb select_group_when_MANY_tables 11.00 +5.17% 0.60
11.00 13.00 11.60 0.80
innodb select_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb select_key 63.00 +0.94% 0.60
63.00 64.00 63.60 0.49
innodb select_key2 71.00 -1.14% -0.80
69.00 71.00 70.20 0.75
innodb select_key2_return_key 67.00 +0.89% 0.60
67.00 68.00 67.60 0.49
innodb select_key2_return_prim 68.00 +0.29% 0.20
68.00 69.00 68.20 0.40
innodb select_key_prefix 70.00 -0.00% 0.00
69.00 71.00 70.00 0.63
innodb select_key_prefix_join 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb select_key_return_key 62.00 +0.32% 0.20
62.00 63.00 62.20 0.40
innodb select_many_fields 14.00 +1.41% 0.20
13.00 17.00 14.20 1.47
innodb select_range 49.00 -6.52% -3.00
41.00 50.00 46.00 3.74
innodb select_range_key2 9.00 +6.25% 0.60
9.00 10.00 9.60 0.49
innodb select_range_prefix 10.00 -6.38% -0.60
9.00 10.00 9.40 0.49
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_cache 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
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 60.00 -1.35% -0.80
58.00 61.00 59.20 1.17
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 23.00 -2.68% -0.60
22.00 23.00 22.40 0.49
innodb update_of_key_big 19.00 +3.06% 0.60
19.00 20.00 19.60 0.49
innodb update_of_primary_key_many_keys 1270.00 -0.27% -3.40
1123.00 1389.00 1266.60 84.84
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 118.00 +0.67% 0.80
118.00 121.00 118.80 1.17
innodb update_with_key_prefix 46.00 -4.07% -1.80
43.00 46.00 44.20 1.47
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 32.00 +1.08% 0.35
30.00 35.00 32.35 1.28
innodb alter_table_drop 23.00 +3.16% 0.75
22.00 26.00 23.75 1.04
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 -7.26% -1.15
13.00 18.00 15.85 1.88
innodb count_distinct 6.00 +11.76% 0.80
6.00 8.00 6.80 0.75
innodb count_distinct_2 15.00 -12.78% -1.70
11.00 16.00 13.30 1.38
innodb count_distinct_big 25.00 -7.53% -1.75
20.00 25.00 23.25 1.73
innodb count_distinct_group 16.00 -11.11% -1.60
11.00 16.00 14.40 1.39
innodb count_distinct_group_on_key 11.00 -14.58% -1.40
8.00 12.00 9.60 0.97
innodb count_distinct_group_on_key_parts 14.00 -7.28% -0.95
11.00 15.00 13.05 1.40
innodb count_distinct_key_prefix 5.00 +6.54% 0.35
4.00 7.00 5.35 0.73
innodb count_group_on_key_parts 11.00 +1.35% 0.15
10.00 12.00 11.15 0.48
innodb count_on_key 98.00 -2.03% -1.95
92.00 103.00 96.05 2.99
innodb create+drop 33.00 +0.30% 0.10
31.00 35.00 33.10 0.94
innodb create_index 3.00 +4.76% 0.15
3.00 4.00 3.15 0.36
innodb create_key+drop 33.00 -4.76% -1.50
28.00 36.00 31.50 1.50
innodb create_MANY_tables 21.00 -2.94% -0.60
19.00 22.00 20.40 0.66
innodb delete_all_many_keys 756.00 -4.91% -35.35
553.00 1045.00 720.65 148.85
innodb delete_autocommit 3.00 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb delete_big 0.00 +100.00% 0.40
0.00 1.00 0.40 0.49
innodb delete_big_many_keys 756.00 -5.01% -36.10
553.00 1045.00 719.90 148.90
innodb delete_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb delete_key 2.00 +29.82% 0.85
2.00 3.00 2.85 0.36
innodb delete_range 8.00 +5.33% 0.45
8.00 10.00 8.45 0.67
innodb delete_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb drop_index 3.00 -1.69% -0.05
2.00 4.00 2.95 0.50
innodb drop_table_when_MANY_tables 19.00 -2.43% -0.45
17.00 20.00 18.55 0.74
innodb insert 112.00 +1.23% 1.40
111.00 117.00 113.40 1.50
innodb insert_autocommit 3.00 +4.76% 0.15
3.00 4.00 3.15 0.36
innodb insert_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb insert_duplicates 19.00 +1.81% 0.35
19.00 20.00 19.35 0.48
innodb insert_key 274.00 +1.63% 4.55
260.00 307.00 278.55 11.28
innodb insert_many_fields 6.00 -6.19% -0.35
5.00 7.00 5.65 0.57
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 5.00 -17.65% -0.75
3.00 6.00 4.25 0.70
innodb insert_select_2_keys 6.00 +4.76% 0.30
5.00 7.00 6.30 0.56
innodb min_max 8.00 -4.58% -0.35
6.00 9.00 7.65 1.15
innodb min_max_on_key 25.00 -2.04% -0.50
24.00 25.00 24.50 0.50
innodb multiple_value_insert 6.00 +3.23% 0.20
5.00 8.00 6.20 0.75
innodb once_prepared_select 29.00 -0.69% -0.20
28.00 29.00 28.80 0.40
innodb order_by_big 14.00 +1.75% 0.25
12.00 15.00 14.25 0.94
innodb order_by_big_key 15.00 -5.26% -0.75
12.00 16.00 14.25 1.37
innodb order_by_big_key2 12.00 +6.98% 0.90
11.00 14.00 12.90 1.14
innodb order_by_big_key_desc 16.00 -7.02% -1.05
13.00 16.00 14.95 0.97
innodb order_by_big_key_diff 12.00 +6.98% 0.90
12.00 14.00 12.90 0.62
innodb order_by_big_key_prefix 14.00 -8.95% -1.15
12.00 14.00 12.85 0.73
innodb order_by_key2_diff 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
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 -11.11% -0.10
0.00 1.00 0.90 0.30
innodb outer_join 25.00 -11.11% -2.50
17.00 26.00 22.50 2.62
innodb outer_join_found 24.00 -11.11% -2.40
17.00 24.00 21.60 2.33
innodb outer_join_not_found 22.00 -11.39% -2.25
15.00 25.00 19.75 2.43
innodb outer_join_on_key 17.00 -14.09% -2.10
12.00 17.00 14.90 1.61
innodb prepared_select 36.00 +1.64% 0.60
36.00 37.00 36.60 0.49
innodb select_1_row 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_1_row_cache 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb select_2_rows 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb select_big 13.00 -2.77% -0.35
11.00 15.00 12.65 1.19
innodb select_big_str 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb select_cache 64.00 +1.01% 0.65
61.00 72.00 64.65 2.37
innodb select_cache2 66.00 -2.25% -1.45
61.00 73.00 64.55 3.25
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.15
0.00 1.00 0.15 0.36
innodb select_distinct 4.00 +12.09% 0.55
4.00 5.00 4.55 0.50
innodb select_group 19.00 -11.44% -1.95
15.00 19.00 17.05 1.50
innodb select_group_when_MANY_tables 11.00 +7.56% 0.90
11.00 13.00 11.90 0.54
innodb select_join 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb select_key 63.00 +1.18% 0.75
63.00 65.00 63.75 0.62
innodb select_key2 71.00 -1.00% -0.70
69.00 71.00 70.30 0.71
innodb select_key2_return_key 67.00 +1.18% 0.80
67.00 69.00 67.80 0.60
innodb select_key2_return_prim 68.00 +0.66% 0.45
67.00 70.00 68.45 0.67
innodb select_key_prefix 70.00 -0.29% -0.20
68.00 71.00 69.80 0.68
innodb select_key_prefix_join 5.00 +2.91% 0.15
5.00 6.00 5.15 0.36
innodb select_key_return_key 62.00 +0.64% 0.40
61.00 64.00 62.40 0.73
innodb select_many_fields 14.00 -2.94% -0.40
13.00 17.00 13.60 0.92
innodb select_range 49.00 -7.22% -3.30
41.00 50.00 45.70 2.92
innodb select_range_key2 9.00 +5.26% 0.50
9.00 10.00 9.50 0.50
innodb select_range_prefix 10.00 -8.11% -0.75
8.00 10.00 9.25 0.54
innodb select_simple 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb select_simple_cache 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb select_simple_join 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb update_autocommit 4.00 -14.29% -0.50
3.00 5.00 3.50 0.59
innodb update_big 60.00 -1.44% -0.85
56.00 65.00 59.15 2.08
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 23.00 -3.84% -0.85
21.00 24.00 22.15 0.91
innodb update_of_key_big 19.00 +38.41% 11.85
18.00 46.00 30.85 8.18
innodb update_of_primary_key_many_keys 1270.00 +2.79% 36.50
1123.00 1435.00 1306.50 75.86
innodb update_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb update_with_key 118.00 +1.67% 2.00
115.00 125.00 120.00 2.72
innodb update_with_key_prefix 46.00 -3.95% -1.75
41.00 47.00 44.25 1.81
innodb wisc_benchmark 3.00 -11.11% -0.30
2.00 3.00 2.70 0.46
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -46.27% -10.12
11.00 61.00 21.88 10.17
innodb alter_table_drop 23.00 -22.47% -4.22
10.00 57.00 18.78 6.85
innodb connect 2.00 +4.28% 0.09
1.00 3.00 2.09 0.42
innodb connect+select_1_row 3.00 -10.29% -0.28
2.00 5.00 2.72 0.46
innodb connect+select_simple 3.00 -26.68% -0.63
1.00 3.00 2.37 0.49
innodb count 17.00 -7.95% -1.25
12.00 193.00 15.75 8.51
innodb count_distinct 6.00 +8.87% 0.58
5.00 50.00 6.58 2.20
innodb count_distinct_2 15.00 -13.43% -1.78
11.00 63.00 13.22 2.87
innodb count_distinct_big 25.00 -13.60% -2.99
5.00 67.00 22.01 2.96
innodb count_distinct_group 16.00 -20.75% -2.75
10.00 68.00 13.25 3.01
innodb count_distinct_group_on_key 11.00 -15.72% -1.49
7.00 69.00 9.51 2.92
innodb count_distinct_group_on_key_parts 14.00 -13.04% -1.62
9.00 72.00 12.38 3.06
innodb count_distinct_key_prefix 5.00 +2.85% 0.15
3.00 52.00 5.15 2.30
innodb count_group_on_key_parts 11.00 -9.43% -0.95
7.00 72.00 10.05 3.05
innodb count_on_key 98.00 -13.18% -11.41
68.00 107.00 86.59 7.45
innodb create+drop 33.00 -1.57% -0.51
18.00 75.00 32.49 11.45
innodb create_index 3.00 -3.22% -0.09
1.00 8.00 2.91 1.11
innodb create_key+drop 33.00 -16.09% -4.57
21.00 50.00 28.43 4.81
innodb create_MANY_tables 21.00 +36.53% 12.08
14.00 121.00 33.08 16.82
innodb create_table 0.00 +100.00% 0.10
0.00 3.00 0.10 0.35
innodb delete_all_many_keys 756.00 -57.64% -276.43
212.00 1888.00 479.57 355.41
innodb delete_autocommit 3.00 +13.22% 0.46
2.00 14.00 3.46 0.74
innodb delete_big 0.00 +100.00% 0.30
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 756.00 -55.84% -270.90
212.00 2293.00 485.10 368.65
innodb delete_commit 2.00 -30.15% -0.46
1.00 5.00 1.54 0.53
innodb delete_key 2.00 +34.12% 1.04
2.00 35.00 3.04 1.45
innodb delete_range 8.00 +3.94% 0.33
5.00 23.00 8.33 3.12
innodb delete_rollback 2.00 -13.17% -0.23
1.00 12.00 1.77 0.89
innodb drop_index 3.00 -1.57% -0.05
1.00 9.00 2.95 1.28
innodb drop_table 0.00 +100.00% 0.04
0.00 2.00 0.04 0.23
innodb drop_table_when_MANY_tables 19.00 +2.58% 0.50
11.00 90.00 19.50 7.26
innodb insert 112.00 -4.48% -4.80
3.00 343.00 107.20 14.17
innodb insert_autocommit 3.00 +0.36% 0.01
2.00 99.00 3.01 3.19
innodb insert_commit 2.00 -41.57% -0.59
1.00 3.00 1.41 0.50
innodb insert_duplicates 19.00 -20.77% -3.27
11.00 21.00 15.73 2.73
innodb insert_key 274.00 +9.04% 27.24
142.00 700.00 301.24 102.95
innodb insert_many_fields 6.00 -6.76% -0.38
3.00 17.00 5.62 1.71
innodb insert_rollback 2.00 -18.22% -0.31
1.00 3.00 1.69 0.53
innodb insert_select_1_key 5.00 -31.64% -1.20
2.00 10.00 3.80 0.87
innodb insert_select_2_keys 6.00 +1.31% 0.08
4.00 16.00 6.08 2.02
innodb min_max 8.00 -2.32% -0.18
6.00 110.00 7.82 4.38
innodb min_max_on_key 25.00 -20.04% -4.17
14.00 37.00 20.83 3.15
innodb multiple_value_insert 6.00 -8.59% -0.47
2.00 50.00 5.53 4.14
innodb once_prepared_select 29.00 -18.12% -4.45
18.00 32.00 24.55 3.66
innodb order_by_big 14.00 +2.13% 0.31
12.00 31.00 14.31 1.50
innodb order_by_big_key 15.00 -12.45% -1.66
11.00 32.00 13.34 1.64
innodb order_by_big_key2 12.00 +1.99% 0.24
10.00 33.00 12.24 1.52
innodb order_by_big_key_desc 16.00 -17.67% -2.40
11.00 32.00 13.60 1.69
innodb order_by_big_key_diff 12.00 +2.29% 0.28
10.00 31.00 12.28 1.48
innodb order_by_big_key_prefix 14.00 -12.53% -1.56
10.00 32.00 12.44 1.53
innodb order_by_key2_diff 2.00 -42.84% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 0.00 +100.00% 0.80
0.00 2.00 0.80 0.41
innodb order_by_range 1.00 -19.61% -0.16
0.00 2.00 0.84 0.38
innodb outer_join 25.00 -27.97% -5.46
15.00 61.00 19.54 3.72
innodb outer_join_found 24.00 -26.71% -5.06
14.00 58.00 18.94 3.57
innodb outer_join_not_found 22.00 -32.02% -5.34
12.00 46.00 16.66 3.20
innodb outer_join_on_key 17.00 -30.39% -3.96
10.00 59.00 13.04 2.76
innodb prepared_select 36.00 -13.49% -4.28
22.00 40.00 31.72 4.58
innodb select_1_row 4.00 -37.94% -1.10
2.00 4.00 2.90 0.70
innodb select_1_row_cache 3.00 -9.64% -0.26
2.00 4.00 2.74 0.70
innodb select_2_rows 4.00 -36.52% -1.07
2.00 4.00 2.93 0.71
innodb select_big 13.00 -6.65% -0.81
0.00 31.00 12.19 1.53
innodb select_big_str 1.00 +15.17% 0.18
0.00 2.00 1.18 0.39
innodb select_cache 64.00 -6.84% -4.10
49.00 77.00 59.90 5.57
innodb select_cache2 66.00 -9.52% -5.73
49.00 75.00 60.27 6.19
innodb select_column+column 4.00 -34.05% -1.02
2.00 4.00 2.98 0.73
innodb select_diff_key 0.00 +100.00% 0.22
0.00 1.00 0.22 0.42
innodb select_distinct 4.00 +6.07% 0.26
3.00 8.00 4.26 0.55
innodb select_group 19.00 -16.59% -2.70
4.00 136.00 16.30 5.25
innodb select_group_when_MANY_tables 11.00 -14.13% -1.36
3.00 49.00 9.64 9.13
innodb select_join 1.00 -72.36% -0.42
0.00 1.00 0.58 0.49
innodb select_key 63.00 -17.67% -9.46
40.00 66.00 53.54 7.72
innodb select_key2 71.00 -17.87% -10.76
45.00 75.00 60.24 8.50
innodb select_key2_return_key 67.00 -16.38% -9.43
42.00 71.00 57.57 8.33
innodb select_key2_return_prim 68.00 -16.57% -9.66
42.00 72.00 58.34 8.46
innodb select_key_prefix 70.00 -17.61% -10.48
44.00 75.00 59.52 8.55
innodb select_key_prefix_join 5.00 -5.28% -0.25
3.00 10.00 4.75 0.65
innodb select_key_return_key 62.00 -17.98% -9.45
38.00 65.00 52.55 7.72
innodb select_many_fields 14.00 +5.58% 0.83
11.00 19.00 14.83 1.79
innodb select_range 49.00 -4.72% -2.21
38.00 76.00 46.79 4.06
innodb select_range_key2 9.00 -7.82% -0.65
6.00 11.00 8.35 1.07
innodb select_range_prefix 10.00 -26.02% -2.06
5.00 10.00 7.94 1.14
innodb select_simple 2.00 -19.41% -0.33
1.00 3.00 1.67 0.51
innodb select_simple_cache 2.00 -25.97% -0.41
1.00 3.00 1.59 0.51
innodb select_simple_join 1.00 -49.60% -0.33
0.00 3.00 0.67 0.48
innodb update_autocommit 4.00 -19.40% -0.65
2.00 16.00 3.35 0.99
innodb update_big 60.00 -16.38% -8.44
31.00 195.00 51.56 23.67
innodb update_commit 2.00 -25.83% -0.41
1.00 10.00 1.59 0.71
innodb update_of_key 23.00 +4.51% 1.09
18.00 100.00 24.09 5.98
innodb update_of_key_big 19.00 +32.06% 8.96
15.00 75.00 27.96 10.85
innodb update_of_primary_key_many_keys 1270.00 -1.77% -22.04
647.00 6065.00 1247.96 915.42
innodb update_rollback 2.00 -12.08% -0.22
1.00 31.00 1.78 1.84
innodb update_with_key 118.00 -6.66% -7.36
90.00 598.00 110.64 20.24
innodb update_with_key_prefix 46.00 -15.14% -6.05
33.00 202.00 39.95 6.70
innodb wisc_benchmark 3.00 -20.83% -0.52
2.00 5.00 2.48 0.52
=========================================================================================================================
FULL REVISION COMMENTARY:
2276.1.2: Lee Bieber 2011-04-13 [merge] Merge Olaf - Refactor Program Options
usage
2252.1.29: Olaf van der Spek 2011-04-05 Avoid silly ICC warning
2252.1.28: Olaf van der Spek 2011-03-29 Refactor Program Options usage
2252.1.27: Olaf van der Spek 2011-03-29 [merge] Merge trunk
2276.1.1: Lee Bieber 2011-04-13 [merge] Merge Andrew - 748064: Xtrabackup
breaks trunk in GCC 4.6
2260.2.1: Andrew Hutchings 2011-04-02 Fix xtrabackup to work with GCC 4.6
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
