=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 971
RUN DATE: 2011-03-23T18:56:33.881404
SERVER: drizzled
VERSION: elliott-staging
REVISION: 2239
COMMENT: 2239: patrick crews 2011-03-15 {2011.03.13} Updated translations
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -65.52% -12.67
13.00 32.00 19.33 8.96
innodb alter_table_drop 24.00 -33.33% -6.00
15.00 24.00 18.00 4.24
innodb connect 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb connect+select_1_row 2.00 +14.29% 0.33
2.00 3.00 2.33 0.47
innodb connect+select_simple 2.00 +14.29% 0.33
2.00 3.00 2.33 0.47
innodb count 17.00 -6.25% -1.00
13.00 18.00 16.00 2.16
innodb count_distinct 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb count_distinct_2 12.00 -5.88% -0.67
11.00 12.00 11.33 0.47
innodb count_distinct_big 25.00 -10.29% -2.33
20.00 25.00 22.67 2.05
innodb count_distinct_group 15.00 -21.62% -2.67
11.00 15.00 12.33 1.89
innodb count_distinct_group_on_key 9.00 -3.85% -0.33
8.00 9.00 8.67 0.47
innodb count_distinct_group_on_key_parts 11.00 -3.12% -0.33
10.00 11.00 10.67 0.47
innodb count_distinct_key_prefix 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb count_group_on_key_parts 12.00 -12.50% -1.33
10.00 12.00 10.67 0.94
innodb count_on_key 96.00 -8.27% -7.33
85.00 96.00 88.67 5.19
innodb create+drop 33.00 -12.50% -3.67
24.00 33.00 29.33 3.86
innodb create_index 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb create_key+drop 31.00 -10.71% -3.00
26.00 31.00 28.00 2.16
innodb create_MANY_tables 21.00 +11.27% 2.67
21.00 28.00 23.67 3.09
innodb delete_all_many_keys 640.00 -71.58% -267.00
220.00 640.00 373.00 189.47
innodb delete_autocommit 4.00 -9.09% -0.33
3.00 4.00 3.67 0.47
innodb delete_big 1.00 -200.00% -0.67
0.00 1.00 0.33 0.47
innodb delete_big_many_keys 639.00 -71.62% -266.67
220.00 639.00 372.33 189.20
innodb delete_commit 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 8.00 -20.00% -1.33
6.00 8.00 6.67 0.94
innodb delete_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb drop_index 3.00 -28.57% -0.67
2.00 3.00 2.33 0.47
innodb drop_table_when_MANY_tables 19.00 -16.33% -2.67
14.00 19.00 16.33 2.05
innodb insert 116.00 -4.82% -5.33
106.00 116.00 110.67 4.11
innodb insert_autocommit 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb insert_commit 2.00 -50.00% -0.67
1.00 2.00 1.33 0.47
innodb insert_duplicates 19.00 -23.91% -3.67
13.00 19.00 15.33 2.62
innodb insert_key 276.00 -33.55% -69.33
162.00 276.00 206.67 49.70
innodb insert_many_fields 6.00 -5.88% -0.33
5.00 6.00 5.67 0.47
innodb insert_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb insert_select_1_key 5.00 -36.36% -1.33
3.00 5.00 3.67 0.94
innodb insert_select_2_keys 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb min_max 8.00 -0.00% 0.00
7.00 9.00 8.00 0.82
innodb min_max_on_key 25.00 -17.19% -3.67
19.00 25.00 21.33 2.62
innodb multiple_value_insert 5.00 -36.36% -1.33
3.00 5.00 3.67 0.94
innodb once_prepared_select 28.00 -10.53% -2.67
22.00 28.00 25.33 2.49
innodb order_by_big 13.00 -2.63% -0.33
12.00 13.00 12.67 0.47
innodb order_by_big_key 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb order_by_big_key2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb order_by_big_key_desc 14.00 -7.69% -1.00
12.00 14.00 13.00 0.82
innodb order_by_big_key_diff 12.00 -9.09% -1.00
10.00 12.00 11.00 0.82
innodb order_by_big_key_prefix 12.00 -2.86% -0.33
11.00 12.00 11.67 0.47
innodb order_by_key2_diff 1.00 +25.00% 0.33
1.00 2.00 1.33 0.47
innodb order_by_key_prefix 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 18.00 -3.85% -0.67
15.00 19.00 17.33 1.70
innodb outer_join_found 18.00 -1.89% -0.33
16.00 19.00 17.67 1.25
innodb outer_join_not_found 17.00 -8.51% -1.33
14.00 17.00 15.67 1.25
innodb outer_join_on_key 13.00 -2.63% -0.33
12.00 13.00 12.67 0.47
innodb prepared_select 37.00 -14.43% -4.67
27.00 37.00 32.33 4.11
innodb select_1_row 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb select_1_row_cache 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb select_2_rows 3.00 -12.50% -0.33
2.00 3.00 2.67 0.47
innodb select_big 14.00 -16.67% -2.00
11.00 14.00 12.00 1.41
innodb select_big_str 2.00 -50.00% -0.67
1.00 2.00 1.33 0.47
innodb select_cache 66.00 -15.12% -8.67
53.00 66.00 57.33 6.13
innodb select_cache2 71.00 -20.34% -12.00
52.00 71.00 59.00 8.52
innodb select_column+column 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb select_distinct 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb select_group 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb select_group_when_MANY_tables 11.00 -65.00% -4.33
4.00 11.00 6.67 3.09
innodb select_join 0.00 +100.00% 0.33
0.00 1.00 0.33 0.47
innodb select_key 64.00 -15.66% -8.67
51.00 64.00 55.33 6.13
innodb select_key2 71.00 -10.94% -7.00
55.00 71.00 64.00 6.68
innodb select_key2_return_key 68.00 -12.09% -7.33
54.00 68.00 60.67 5.73
innodb select_key2_return_prim 69.00 -10.70% -6.67
55.00 69.00 62.33 5.73
innodb select_key_prefix 70.00 -16.02% -9.67
55.00 70.00 60.33 6.85
innodb select_key_prefix_join 5.00 -15.38% -0.67
4.00 5.00 4.33 0.47
innodb select_key_return_key 62.00 -15.53% -8.33
49.00 62.00 53.67 5.91
innodb select_many_fields 13.00 +13.33% 2.00
13.00 17.00 15.00 1.63
innodb select_range 45.00 -0.00% 0.00
45.00 45.00 45.00 0.00
innodb select_range_key2 10.00 -15.38% -1.33
8.00 10.00 8.67 0.94
innodb select_range_prefix 9.00 -12.50% -1.00
7.00 9.00 8.00 0.82
innodb select_simple 3.00 -50.00% -1.00
1.00 3.00 2.00 0.82
innodb select_simple_cache 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb select_simple_join 1.00 -50.00% -0.33
0.00 1.00 0.67 0.47
innodb update_autocommit 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb update_big 60.00 -37.40% -16.33
35.00 60.00 43.67 11.56
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 23.00 -1.47% -0.33
21.00 24.00 22.67 1.25
innodb update_of_key_big 30.00 -32.35% -7.33
18.00 30.00 22.67 5.25
innodb update_of_primary_key_many_keys 1319.00 -39.63% -374.33
699.00 1319.00 944.67 268.97
innodb update_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb update_with_key 120.00 -7.46% -8.33
107.00 120.00 111.67 5.91
innodb update_with_key_prefix 45.00 -12.50% -5.00
36.00 45.00 40.00 3.74
innodb wisc_benchmark 3.00 -28.57% -0.67
2.00 3.00 2.33 0.47
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -65.52% -12.67
13.00 32.00 19.33 8.96
innodb alter_table_drop 24.00 -33.33% -6.00
15.00 24.00 18.00 4.24
innodb connect 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb connect+select_1_row 2.00 +14.29% 0.33
2.00 3.00 2.33 0.47
innodb connect+select_simple 2.00 +14.29% 0.33
2.00 3.00 2.33 0.47
innodb count 17.00 -6.25% -1.00
13.00 18.00 16.00 2.16
innodb count_distinct 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb count_distinct_2 12.00 -5.88% -0.67
11.00 12.00 11.33 0.47
innodb count_distinct_big 25.00 -10.29% -2.33
20.00 25.00 22.67 2.05
innodb count_distinct_group 15.00 -21.62% -2.67
11.00 15.00 12.33 1.89
innodb count_distinct_group_on_key 9.00 -3.85% -0.33
8.00 9.00 8.67 0.47
innodb count_distinct_group_on_key_parts 11.00 -3.12% -0.33
10.00 11.00 10.67 0.47
innodb count_distinct_key_prefix 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb count_group_on_key_parts 12.00 -12.50% -1.33
10.00 12.00 10.67 0.94
innodb count_on_key 96.00 -8.27% -7.33
85.00 96.00 88.67 5.19
innodb create+drop 33.00 -12.50% -3.67
24.00 33.00 29.33 3.86
innodb create_index 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb create_key+drop 31.00 -10.71% -3.00
26.00 31.00 28.00 2.16
innodb create_MANY_tables 21.00 +11.27% 2.67
21.00 28.00 23.67 3.09
innodb delete_all_many_keys 640.00 -71.58% -267.00
220.00 640.00 373.00 189.47
innodb delete_autocommit 4.00 -9.09% -0.33
3.00 4.00 3.67 0.47
innodb delete_big 1.00 -200.00% -0.67
0.00 1.00 0.33 0.47
innodb delete_big_many_keys 639.00 -71.62% -266.67
220.00 639.00 372.33 189.20
innodb delete_commit 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 8.00 -20.00% -1.33
6.00 8.00 6.67 0.94
innodb delete_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb drop_index 3.00 -28.57% -0.67
2.00 3.00 2.33 0.47
innodb drop_table_when_MANY_tables 19.00 -16.33% -2.67
14.00 19.00 16.33 2.05
innodb insert 116.00 -4.82% -5.33
106.00 116.00 110.67 4.11
innodb insert_autocommit 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb insert_commit 2.00 -50.00% -0.67
1.00 2.00 1.33 0.47
innodb insert_duplicates 19.00 -23.91% -3.67
13.00 19.00 15.33 2.62
innodb insert_key 276.00 -33.55% -69.33
162.00 276.00 206.67 49.70
innodb insert_many_fields 6.00 -5.88% -0.33
5.00 6.00 5.67 0.47
innodb insert_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb insert_select_1_key 5.00 -36.36% -1.33
3.00 5.00 3.67 0.94
innodb insert_select_2_keys 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb min_max 8.00 -0.00% 0.00
7.00 9.00 8.00 0.82
innodb min_max_on_key 25.00 -17.19% -3.67
19.00 25.00 21.33 2.62
innodb multiple_value_insert 5.00 -36.36% -1.33
3.00 5.00 3.67 0.94
innodb once_prepared_select 28.00 -10.53% -2.67
22.00 28.00 25.33 2.49
innodb order_by_big 13.00 -2.63% -0.33
12.00 13.00 12.67 0.47
innodb order_by_big_key 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb order_by_big_key2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb order_by_big_key_desc 14.00 -7.69% -1.00
12.00 14.00 13.00 0.82
innodb order_by_big_key_diff 12.00 -9.09% -1.00
10.00 12.00 11.00 0.82
innodb order_by_big_key_prefix 12.00 -2.86% -0.33
11.00 12.00 11.67 0.47
innodb order_by_key2_diff 1.00 +25.00% 0.33
1.00 2.00 1.33 0.47
innodb order_by_key_prefix 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 18.00 -3.85% -0.67
15.00 19.00 17.33 1.70
innodb outer_join_found 18.00 -1.89% -0.33
16.00 19.00 17.67 1.25
innodb outer_join_not_found 17.00 -8.51% -1.33
14.00 17.00 15.67 1.25
innodb outer_join_on_key 13.00 -2.63% -0.33
12.00 13.00 12.67 0.47
innodb prepared_select 37.00 -14.43% -4.67
27.00 37.00 32.33 4.11
innodb select_1_row 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb select_1_row_cache 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb select_2_rows 3.00 -12.50% -0.33
2.00 3.00 2.67 0.47
innodb select_big 14.00 -16.67% -2.00
11.00 14.00 12.00 1.41
innodb select_big_str 2.00 -50.00% -0.67
1.00 2.00 1.33 0.47
innodb select_cache 66.00 -15.12% -8.67
53.00 66.00 57.33 6.13
innodb select_cache2 71.00 -20.34% -12.00
52.00 71.00 59.00 8.52
innodb select_column+column 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb select_distinct 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb select_group 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb select_group_when_MANY_tables 11.00 -65.00% -4.33
4.00 11.00 6.67 3.09
innodb select_join 0.00 +100.00% 0.33
0.00 1.00 0.33 0.47
innodb select_key 64.00 -15.66% -8.67
51.00 64.00 55.33 6.13
innodb select_key2 71.00 -10.94% -7.00
55.00 71.00 64.00 6.68
innodb select_key2_return_key 68.00 -12.09% -7.33
54.00 68.00 60.67 5.73
innodb select_key2_return_prim 69.00 -10.70% -6.67
55.00 69.00 62.33 5.73
innodb select_key_prefix 70.00 -16.02% -9.67
55.00 70.00 60.33 6.85
innodb select_key_prefix_join 5.00 -15.38% -0.67
4.00 5.00 4.33 0.47
innodb select_key_return_key 62.00 -15.53% -8.33
49.00 62.00 53.67 5.91
innodb select_many_fields 13.00 +13.33% 2.00
13.00 17.00 15.00 1.63
innodb select_range 45.00 -0.00% 0.00
45.00 45.00 45.00 0.00
innodb select_range_key2 10.00 -15.38% -1.33
8.00 10.00 8.67 0.94
innodb select_range_prefix 9.00 -12.50% -1.00
7.00 9.00 8.00 0.82
innodb select_simple 3.00 -50.00% -1.00
1.00 3.00 2.00 0.82
innodb select_simple_cache 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb select_simple_join 1.00 -50.00% -0.33
0.00 1.00 0.67 0.47
innodb update_autocommit 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb update_big 60.00 -37.40% -16.33
35.00 60.00 43.67 11.56
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 23.00 -1.47% -0.33
21.00 24.00 22.67 1.25
innodb update_of_key_big 30.00 -32.35% -7.33
18.00 30.00 22.67 5.25
innodb update_of_primary_key_many_keys 1319.00 -39.63% -374.33
699.00 1319.00 944.67 268.97
innodb update_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb update_with_key 120.00 -7.46% -8.33
107.00 120.00 111.67 5.91
innodb update_with_key_prefix 45.00 -12.50% -5.00
36.00 45.00 40.00 3.74
innodb wisc_benchmark 3.00 -28.57% -0.67
2.00 3.00 2.33 0.47
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -65.52% -12.67
13.00 32.00 19.33 8.96
innodb alter_table_drop 24.00 -33.33% -6.00
15.00 24.00 18.00 4.24
innodb connect 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb connect+select_1_row 2.00 +14.29% 0.33
2.00 3.00 2.33 0.47
innodb connect+select_simple 2.00 +14.29% 0.33
2.00 3.00 2.33 0.47
innodb count 17.00 -6.25% -1.00
13.00 18.00 16.00 2.16
innodb count_distinct 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb count_distinct_2 12.00 -5.88% -0.67
11.00 12.00 11.33 0.47
innodb count_distinct_big 25.00 -10.29% -2.33
20.00 25.00 22.67 2.05
innodb count_distinct_group 15.00 -21.62% -2.67
11.00 15.00 12.33 1.89
innodb count_distinct_group_on_key 9.00 -3.85% -0.33
8.00 9.00 8.67 0.47
innodb count_distinct_group_on_key_parts 11.00 -3.12% -0.33
10.00 11.00 10.67 0.47
innodb count_distinct_key_prefix 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb count_group_on_key_parts 12.00 -12.50% -1.33
10.00 12.00 10.67 0.94
innodb count_on_key 96.00 -8.27% -7.33
85.00 96.00 88.67 5.19
innodb create+drop 33.00 -12.50% -3.67
24.00 33.00 29.33 3.86
innodb create_index 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb create_key+drop 31.00 -10.71% -3.00
26.00 31.00 28.00 2.16
innodb create_MANY_tables 21.00 +11.27% 2.67
21.00 28.00 23.67 3.09
innodb delete_all_many_keys 640.00 -71.58% -267.00
220.00 640.00 373.00 189.47
innodb delete_autocommit 4.00 -9.09% -0.33
3.00 4.00 3.67 0.47
innodb delete_big 1.00 -200.00% -0.67
0.00 1.00 0.33 0.47
innodb delete_big_many_keys 639.00 -71.62% -266.67
220.00 639.00 372.33 189.20
innodb delete_commit 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 8.00 -20.00% -1.33
6.00 8.00 6.67 0.94
innodb delete_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb drop_index 3.00 -28.57% -0.67
2.00 3.00 2.33 0.47
innodb drop_table_when_MANY_tables 19.00 -16.33% -2.67
14.00 19.00 16.33 2.05
innodb insert 116.00 -4.82% -5.33
106.00 116.00 110.67 4.11
innodb insert_autocommit 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb insert_commit 2.00 -50.00% -0.67
1.00 2.00 1.33 0.47
innodb insert_duplicates 19.00 -23.91% -3.67
13.00 19.00 15.33 2.62
innodb insert_key 276.00 -33.55% -69.33
162.00 276.00 206.67 49.70
innodb insert_many_fields 6.00 -5.88% -0.33
5.00 6.00 5.67 0.47
innodb insert_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb insert_select_1_key 5.00 -36.36% -1.33
3.00 5.00 3.67 0.94
innodb insert_select_2_keys 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb min_max 8.00 -0.00% 0.00
7.00 9.00 8.00 0.82
innodb min_max_on_key 25.00 -17.19% -3.67
19.00 25.00 21.33 2.62
innodb multiple_value_insert 5.00 -36.36% -1.33
3.00 5.00 3.67 0.94
innodb once_prepared_select 28.00 -10.53% -2.67
22.00 28.00 25.33 2.49
innodb order_by_big 13.00 -2.63% -0.33
12.00 13.00 12.67 0.47
innodb order_by_big_key 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb order_by_big_key2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb order_by_big_key_desc 14.00 -7.69% -1.00
12.00 14.00 13.00 0.82
innodb order_by_big_key_diff 12.00 -9.09% -1.00
10.00 12.00 11.00 0.82
innodb order_by_big_key_prefix 12.00 -2.86% -0.33
11.00 12.00 11.67 0.47
innodb order_by_key2_diff 1.00 +25.00% 0.33
1.00 2.00 1.33 0.47
innodb order_by_key_prefix 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 18.00 -3.85% -0.67
15.00 19.00 17.33 1.70
innodb outer_join_found 18.00 -1.89% -0.33
16.00 19.00 17.67 1.25
innodb outer_join_not_found 17.00 -8.51% -1.33
14.00 17.00 15.67 1.25
innodb outer_join_on_key 13.00 -2.63% -0.33
12.00 13.00 12.67 0.47
innodb prepared_select 37.00 -14.43% -4.67
27.00 37.00 32.33 4.11
innodb select_1_row 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb select_1_row_cache 4.00 -33.33% -1.00
2.00 4.00 3.00 0.82
innodb select_2_rows 3.00 -12.50% -0.33
2.00 3.00 2.67 0.47
innodb select_big 14.00 -16.67% -2.00
11.00 14.00 12.00 1.41
innodb select_big_str 2.00 -50.00% -0.67
1.00 2.00 1.33 0.47
innodb select_cache 66.00 -15.12% -8.67
53.00 66.00 57.33 6.13
innodb select_cache2 71.00 -20.34% -12.00
52.00 71.00 59.00 8.52
innodb select_column+column 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb select_distinct 5.00 -7.14% -0.33
4.00 5.00 4.67 0.47
innodb select_group 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb select_group_when_MANY_tables 11.00 -65.00% -4.33
4.00 11.00 6.67 3.09
innodb select_join 0.00 +100.00% 0.33
0.00 1.00 0.33 0.47
innodb select_key 64.00 -15.66% -8.67
51.00 64.00 55.33 6.13
innodb select_key2 71.00 -10.94% -7.00
55.00 71.00 64.00 6.68
innodb select_key2_return_key 68.00 -12.09% -7.33
54.00 68.00 60.67 5.73
innodb select_key2_return_prim 69.00 -10.70% -6.67
55.00 69.00 62.33 5.73
innodb select_key_prefix 70.00 -16.02% -9.67
55.00 70.00 60.33 6.85
innodb select_key_prefix_join 5.00 -15.38% -0.67
4.00 5.00 4.33 0.47
innodb select_key_return_key 62.00 -15.53% -8.33
49.00 62.00 53.67 5.91
innodb select_many_fields 13.00 +13.33% 2.00
13.00 17.00 15.00 1.63
innodb select_range 45.00 -0.00% 0.00
45.00 45.00 45.00 0.00
innodb select_range_key2 10.00 -15.38% -1.33
8.00 10.00 8.67 0.94
innodb select_range_prefix 9.00 -12.50% -1.00
7.00 9.00 8.00 0.82
innodb select_simple 3.00 -50.00% -1.00
1.00 3.00 2.00 0.82
innodb select_simple_cache 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb select_simple_join 1.00 -50.00% -0.33
0.00 1.00 0.67 0.47
innodb update_autocommit 4.00 -20.00% -0.67
3.00 4.00 3.33 0.47
innodb update_big 60.00 -37.40% -16.33
35.00 60.00 43.67 11.56
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 23.00 -1.47% -0.33
21.00 24.00 22.67 1.25
innodb update_of_key_big 30.00 -32.35% -7.33
18.00 30.00 22.67 5.25
innodb update_of_primary_key_many_keys 1319.00 -39.63% -374.33
699.00 1319.00 944.67 268.97
innodb update_rollback 2.00 -20.00% -0.33
1.00 2.00 1.67 0.47
innodb update_with_key 120.00 -7.46% -8.33
107.00 120.00 111.67 5.91
innodb update_with_key_prefix 45.00 -12.50% -5.00
36.00 45.00 40.00 3.74
innodb wisc_benchmark 3.00 -28.57% -0.67
2.00 3.00 2.33 0.47
=========================================================================================================================
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
