=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 844
RUN DATE: 2011-01-24T18:47:52.175673
SERVER: drizzled
VERSION: staging
REVISION: 2110
COMMENT: 2110: Lee Bieber 2011-01-24 [merge] Need to add a "drop table a" in
execute.wait test
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -6.67% -2.00
26.00 32.00 30.00 2.35
innodb alter_table_drop 25.00 -3.09% -0.75
24.00 25.00 24.25 0.43
innodb connect 3.00 -33.33% -0.75
2.00 3.00 2.25 0.43
innodb connect+select_1_row 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb connect+select_simple 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb count 18.00 -7.46% -1.25
14.00 18.00 16.75 1.64
innodb count_distinct 7.00 -3.70% -0.25
6.00 7.00 6.75 0.43
innodb count_distinct_2 15.00 -7.14% -1.00
13.00 15.00 14.00 0.71
innodb count_distinct_big 22.00 +2.22% 0.50
20.00 25.00 22.50 1.80
innodb count_distinct_group 15.00 -1.69% -0.25
14.00 15.00 14.75 0.43
innodb count_distinct_group_on_key 9.00 +2.70% 0.25
8.00 11.00 9.25 1.09
innodb count_distinct_group_on_key_parts 11.00 +13.73% 1.75
10.00 15.00 12.75 2.28
innodb count_distinct_key_prefix 6.00 -9.09% -0.50
5.00 6.00 5.50 0.50
innodb count_group_on_key_parts 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb count_on_key 95.00 -0.00% 0.00
92.00 99.00 95.00 2.55
innodb create+drop 31.00 +1.59% 0.50
31.00 32.00 31.50 0.50
innodb create_index 3.00 +7.69% 0.25
3.00 4.00 3.25 0.43
innodb create_key+drop 29.00 -0.00% 0.00
28.00 30.00 29.00 0.71
innodb create_MANY_tables 20.00 +1.23% 0.25
20.00 21.00 20.25 0.43
innodb delete_all_many_keys 665.00 -2.43% -15.75
611.00 685.00 649.25 28.13
innodb delete_autocommit 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb delete_big 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb delete_big_many_keys 664.00 -2.43% -15.75
610.00 684.00 648.25 28.13
innodb delete_commit 2.00 -14.29% -0.25
1.00 2.00 1.75 0.43
innodb delete_key 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb delete_range 8.00 +3.03% 0.25
7.00 9.00 8.25 0.83
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
3.00 3.00 3.00 0.00
innodb drop_table_when_MANY_tables 15.00 +6.25% 1.00
15.00 17.00 16.00 0.71
innodb insert 116.00 -1.53% -1.75
112.00 116.00 114.25 1.48
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 -0.00% 0.00
19.00 19.00 19.00 0.00
innodb insert_key 282.00 -0.89% -2.50
272.00 290.00 279.50 7.12
innodb insert_many_fields 6.00 -9.09% -0.50
5.00 6.00 5.50 0.50
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 3.00 +20.00% 0.75
3.00 4.00 3.75 0.43
innodb insert_select_2_keys 7.00 -7.69% -0.50
6.00 7.00 6.50 0.50
innodb min_max 9.00 -2.86% -0.25
7.00 10.00 8.75 1.09
innodb min_max_on_key 26.00 -5.05% -1.25
24.00 26.00 24.75 0.83
innodb multiple_value_insert 6.00 +7.69% 0.50
6.00 8.00 6.50 0.87
innodb once_prepared_select 29.00 -0.00% 0.00
29.00 29.00 29.00 0.00
innodb order_by_big 16.00 -6.67% -1.00
13.00 16.00 15.00 1.22
innodb order_by_big_key 16.00 -6.67% -1.00
14.00 16.00 15.00 1.00
innodb order_by_big_key2 14.00 -5.66% -0.75
12.00 14.00 13.25 0.83
innodb order_by_big_key_desc 17.00 -3.03% -0.50
16.00 17.00 16.50 0.50
innodb order_by_big_key_diff 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb order_by_big_key_prefix 13.00 +1.89% 0.25
12.00 15.00 13.25 1.09
innodb order_by_key2_diff 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb order_by_key_prefix 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 24.00 -9.09% -2.00
19.00 24.00 22.00 1.87
innodb outer_join_found 22.00 -6.02% -1.25
18.00 22.00 20.75 1.64
innodb outer_join_not_found 20.00 -8.11% -1.50
15.00 20.00 18.50 2.06
innodb outer_join_on_key 16.00 -8.47% -1.25
12.00 16.00 14.75 1.64
innodb prepared_select 38.00 -2.01% -0.75
37.00 38.00 37.25 0.43
innodb select_1_row 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb select_1_row_cache 3.00 +7.69% 0.25
3.00 4.00 3.25 0.43
innodb select_2_rows 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_big 14.00 -7.69% -1.00
12.00 14.00 13.00 0.71
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 67.00 -3.47% -2.25
60.00 70.00 64.75 3.96
innodb select_cache2 64.00 -0.00% 0.00
63.00 65.00 64.00 0.71
innodb select_column+column 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb select_distinct 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb select_group 15.00 +13.04% 2.25
15.00 20.00 17.25 1.92
innodb select_group_when_MANY_tables 12.00 -2.13% -0.25
11.00 12.00 11.75 0.43
innodb select_join 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb select_key 65.00 -1.56% -1.00
63.00 65.00 64.00 0.71
innodb select_key2 72.00 -1.41% -1.00
70.00 72.00 71.00 1.00
innodb select_key2_return_key 69.00 -0.73% -0.50
68.00 69.00 68.50 0.50
innodb select_key2_return_prim 70.00 -1.45% -1.00
68.00 70.00 69.00 0.71
innodb select_key_prefix 72.00 -1.77% -1.25
70.00 72.00 70.75 0.83
innodb select_key_prefix_join 6.00 -14.29% -0.75
5.00 6.00 5.25 0.43
innodb select_key_return_key 63.00 -0.40% -0.25
62.00 63.00 62.75 0.43
innodb select_many_fields 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb select_range 46.00 -10.84% -4.50
39.00 46.00 41.50 2.87
innodb select_range_key2 10.00 -5.26% -0.50
9.00 10.00 9.50 0.50
innodb select_range_prefix 9.00 +5.26% 0.50
9.00 10.00 9.50 0.50
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 0.00 +100.00% 0.75
0.00 1.00 0.75 0.43
innodb update_autocommit 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb update_big 59.00 +1.26% 0.75
59.00 61.00 59.75 0.83
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 24.00 -2.13% -0.50
23.00 24.00 23.50 0.50
innodb update_of_key_big 30.00 +23.08% 9.00
30.00 47.00 39.00 6.82
innodb update_of_primary_key_many_keys 1347.00 -0.73% -9.75
1282.00 1413.00 1337.25 49.50
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 125.00 -2.25% -2.75
118.00 125.00 122.25 2.95
innodb update_with_key_prefix 45.00 -4.05% -1.75
41.00 45.00 43.25 1.48
innodb wisc_benchmark 2.00 +27.27% 0.75
2.00 3.00 2.75 0.43
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 +0.33% 0.11
26.00 34.00 32.11 1.86
innodb alter_table_drop 25.00 -2.37% -0.58
23.00 26.00 24.42 0.75
innodb connect 3.00 -39.02% -0.84
2.00 3.00 2.16 0.36
innodb connect+select_1_row 3.00 -3.64% -0.11
2.00 3.00 2.89 0.31
innodb connect+select_simple 2.00 +26.92% 0.74
2.00 3.00 2.74 0.44
innodb count 18.00 -12.13% -1.95
13.00 18.00 16.05 2.06
innodb count_distinct 7.00 +3.62% 0.26
6.00 8.00 7.26 0.64
innodb count_distinct_2 15.00 -4.78% -0.68
12.00 16.00 14.32 1.22
innodb count_distinct_big 22.00 +3.91% 0.89
20.00 25.00 22.89 1.83
innodb count_distinct_group 15.00 -1.42% -0.21
12.00 16.00 14.79 0.95
innodb count_distinct_group_on_key 9.00 +7.57% 0.74
8.00 11.00 9.74 1.07
innodb count_distinct_group_on_key_parts 11.00 +17.39% 2.32
10.00 15.00 13.32 1.45
innodb count_distinct_key_prefix 6.00 -4.59% -0.26
5.00 7.00 5.74 0.64
innodb count_group_on_key_parts 12.00 -6.05% -0.68
10.00 12.00 11.32 0.57
innodb count_on_key 95.00 +0.66% 0.63
92.00 103.00 95.63 2.78
innodb create+drop 31.00 +2.16% 0.68
31.00 33.00 31.68 0.57
innodb create_index 3.00 +3.39% 0.11
3.00 4.00 3.11 0.31
innodb create_key+drop 29.00 -0.00% 0.00
27.00 31.00 29.00 0.92
innodb create_MANY_tables 20.00 +1.30% 0.26
19.00 22.00 20.26 0.71
innodb create_table 0.00 +100.00% 0.11
0.00 1.00 0.11 0.31
innodb delete_all_many_keys 665.00 -0.66% -4.37
611.00 749.00 660.63 37.39
innodb delete_autocommit 4.00 -8.57% -0.32
3.00 4.00 3.68 0.46
innodb delete_big 1.00 -111.11% -0.53
0.00 1.00 0.47 0.50
innodb delete_big_many_keys 664.00 -0.66% -4.37
610.00 748.00 659.63 37.25
innodb delete_commit 2.00 -15.15% -0.26
1.00 2.00 1.74 0.44
innodb delete_key 3.00 -5.56% -0.16
2.00 3.00 2.84 0.36
innodb delete_range 8.00 +5.00% 0.42
7.00 10.00 8.42 0.75
innodb delete_rollback 2.00 +5.00% 0.11
2.00 3.00 2.11 0.31
innodb drop_index 3.00 +1.72% 0.05
3.00 4.00 3.05 0.22
innodb drop_table_when_MANY_tables 15.00 +6.25% 1.00
14.00 17.00 16.00 0.86
innodb insert 116.00 -2.04% -2.32
112.00 116.00 113.68 1.17
innodb insert_autocommit 3.00 +6.56% 0.21
3.00 4.00 3.21 0.41
innodb insert_commit 2.00 -11.76% -0.21
1.00 2.00 1.79 0.41
innodb insert_duplicates 19.00 +0.82% 0.16
19.00 20.00 19.16 0.36
innodb insert_key 282.00 +0.61% 1.74
272.00 306.00 283.74 10.69
innodb insert_many_fields 6.00 -4.59% -0.26
5.00 7.00 5.74 0.55
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 3.00 +19.72% 0.74
3.00 5.00 3.74 0.55
innodb insert_select_2_keys 7.00 -10.83% -0.68
5.00 7.00 6.32 0.57
innodb min_max 9.00 -12.50% -1.00
6.00 10.00 8.00 1.08
innodb min_max_on_key 26.00 -4.88% -1.21
24.00 26.00 24.79 0.69
innodb multiple_value_insert 6.00 +10.24% 0.68
6.00 8.00 6.68 0.57
innodb once_prepared_select 29.00 +0.72% 0.21
29.00 30.00 29.21 0.41
innodb order_by_big 16.00 -9.75% -1.42
13.00 16.00 14.58 1.14
innodb order_by_big_key 16.00 -13.01% -1.84
13.00 16.00 14.16 1.23
innodb order_by_big_key2 14.00 -9.92% -1.26
11.00 14.00 12.74 0.96
innodb order_by_big_key_desc 17.00 -11.76% -1.79
13.00 17.00 15.21 1.28
innodb order_by_big_key_diff 13.00 +1.98% 0.26
12.00 15.00 13.26 0.78
innodb order_by_big_key_prefix 13.00 +1.20% 0.16
12.00 15.00 13.16 0.93
innodb order_by_key2_diff 1.00 +24.00% 0.32
1.00 2.00 1.32 0.46
innodb order_by_key_prefix 1.00 -18.75% -0.16
0.00 1.00 0.84 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 -6.54% -1.47
18.00 25.00 22.53 1.79
innodb outer_join_found 22.00 -3.21% -0.68
17.00 23.00 21.32 2.05
innodb outer_join_not_found 20.00 -5.26% -1.00
15.00 22.00 19.00 2.03
innodb outer_join_on_key 16.00 -4.11% -0.63
12.00 17.00 15.37 1.42
innodb prepared_select 38.00 -2.56% -0.95
36.00 38.00 37.05 0.39
innodb select_1_row 4.00 -10.14% -0.37
3.00 4.00 3.63 0.48
innodb select_1_row_cache 3.00 +10.94% 0.37
3.00 4.00 3.37 0.48
innodb select_2_rows 4.00 -7.04% -0.26
3.00 4.00 3.74 0.44
innodb select_big 14.00 -7.69% -1.00
11.00 14.00 13.00 0.86
innodb select_big_str 1.00 +17.39% 0.21
1.00 2.00 1.21 0.41
innodb select_cache 67.00 -2.50% -1.63
60.00 76.00 65.37 4.20
innodb select_cache2 64.00 +0.41% 0.26
58.00 75.00 64.26 4.63
innodb select_column+column 4.00 -5.56% -0.21
3.00 4.00 3.79 0.41
innodb select_diff_key 0.00 +100.00% 0.32
0.00 1.00 0.32 0.46
innodb select_distinct 4.00 +14.61% 0.68
4.00 5.00 4.68 0.46
innodb select_group 15.00 +11.49% 1.95
15.00 20.00 16.95 1.61
innodb select_group_when_MANY_tables 12.00 +1.30% 0.16
11.00 13.00 12.16 0.67
innodb select_join 1.00 -35.71% -0.26
0.00 1.00 0.74 0.44
innodb select_key 65.00 -1.90% -1.21
63.00 65.00 63.79 0.61
innodb select_key2 72.00 -1.86% -1.32
69.00 72.00 70.68 0.92
innodb select_key2_return_key 69.00 -1.31% -0.89
67.00 69.00 68.11 0.64
innodb select_key2_return_prim 70.00 -1.53% -1.05
67.00 70.00 68.95 0.89
innodb select_key_prefix 72.00 -2.24% -1.58
69.00 72.00 70.42 0.82
innodb select_key_prefix_join 6.00 -17.53% -0.89
5.00 6.00 5.11 0.31
innodb select_key_return_key 63.00 -0.25% -0.16
62.00 64.00 62.84 0.59
innodb select_many_fields 13.00 +1.59% 0.21
13.00 14.00 13.21 0.41
innodb select_range 46.00 -8.98% -3.79
39.00 46.00 42.21 2.42
innodb select_range_key2 10.00 -6.74% -0.63
9.00 10.00 9.37 0.48
innodb select_range_prefix 9.00 +3.39% 0.32
8.00 10.00 9.32 0.57
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 0.00 +100.00% 0.63
0.00 1.00 0.63 0.48
innodb update_autocommit 4.00 -7.04% -0.26
3.00 4.00 3.74 0.44
innodb update_big 59.00 +0.71% 0.42
57.00 65.00 59.42 1.98
innodb update_commit 2.00 -8.57% -0.16
1.00 2.00 1.84 0.36
innodb update_of_key 24.00 -4.83% -1.11
21.00 24.00 22.89 0.97
innodb update_of_key_big 30.00 +16.67% 6.00
29.00 47.00 36.00 5.12
innodb update_of_primary_key_many_keys 1347.00 +1.15% 15.63
1282.00 1513.00 1362.63 64.26
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 125.00 -2.37% -2.89
118.00 125.00 122.11 2.05
innodb update_with_key_prefix 45.00 -1.66% -0.74
41.00 50.00 44.26 2.45
innodb wisc_benchmark 2.00 +20.83% 0.53
2.00 3.00 2.53 0.50
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -61.75% -12.22
11.00 61.00 19.78 9.83
innodb alter_table_drop 25.00 -40.53% -7.21
10.00 57.00 17.79 7.07
innodb connect 3.00 -44.87% -0.93
1.00 3.00 2.07 0.42
innodb connect+select_1_row 3.00 -12.03% -0.32
2.00 5.00 2.68 0.48
innodb connect+select_simple 2.00 +13.73% 0.32
1.00 3.00 2.32 0.47
innodb count 18.00 -14.35% -2.26
12.00 193.00 15.74 9.27
innodb count_distinct 7.00 -6.85% -0.45
5.00 50.00 6.55 2.38
innodb count_distinct_2 15.00 -14.36% -1.88
11.00 63.00 13.12 3.08
innodb count_distinct_big 22.00 -0.79% -0.17
5.00 67.00 21.83 3.11
innodb count_distinct_group 15.00 -15.36% -2.00
10.00 68.00 13.00 3.20
innodb count_distinct_group_on_key 9.00 +4.62% 0.44
7.00 69.00 9.44 3.14
innodb count_distinct_group_on_key_parts 11.00 +9.92% 1.21
9.00 72.00 12.21 3.28
innodb count_distinct_key_prefix 6.00 -17.48% -0.89
3.00 52.00 5.11 2.50
innodb count_group_on_key_parts 12.00 -21.74% -2.14
7.00 72.00 9.86 3.29
innodb count_on_key 95.00 -11.68% -9.94
68.00 107.00 85.06 7.15
innodb create+drop 31.00 +4.46% 1.45
18.00 75.00 32.45 12.52
innodb create_index 3.00 -5.20% -0.15
1.00 8.00 2.85 1.18
innodb create_key+drop 29.00 -3.48% -0.97
21.00 50.00 28.03 5.11
innodb create_MANY_tables 20.00 +43.74% 15.55
14.00 121.00 35.55 17.37
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.37
innodb delete_all_many_keys 665.00 -50.37% -222.75
212.00 1888.00 442.25 378.95
innodb delete_autocommit 4.00 -16.94% -0.58
2.00 14.00 3.42 0.76
innodb delete_big 1.00 -272.60% -0.73
0.00 3.00 0.27 0.46
innodb delete_big_many_keys 664.00 -47.80% -214.75
212.00 2293.00 449.25 394.56
innodb delete_commit 2.00 -35.61% -0.53
1.00 5.00 1.47 0.53
innodb delete_key 3.00 +2.76% 0.09
2.00 35.00 3.09 1.57
innodb delete_range 8.00 +3.19% 0.26
5.00 23.00 8.26 3.40
innodb delete_rollback 2.00 -17.87% -0.30
1.00 12.00 1.70 0.95
innodb drop_index 3.00 -2.19% -0.06
1.00 9.00 2.94 1.38
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.24
innodb drop_table_when_MANY_tables 15.00 +24.45% 4.85
11.00 90.00 19.85 7.87
innodb insert 116.00 -9.54% -10.10
3.00 343.00 105.90 15.16
innodb insert_autocommit 3.00 -1.00% -0.03
2.00 99.00 2.97 3.49
innodb insert_commit 2.00 -50.19% -0.67
1.00 3.00 1.33 0.48
innodb insert_duplicates 19.00 -26.20% -3.94
11.00 21.00 15.06 2.48
innodb insert_key 282.00 +7.79% 23.83
142.00 700.00 305.83 113.08
innodb insert_many_fields 6.00 -7.45% -0.42
3.00 17.00 5.58 1.85
innodb insert_rollback 2.00 -22.53% -0.37
1.00 3.00 1.63 0.54
innodb insert_select_1_key 3.00 +20.42% 0.77
2.00 10.00 3.77 0.92
innodb insert_select_2_keys 7.00 -15.62% -0.95
4.00 16.00 6.05 2.19
innodb min_max 9.00 -15.10% -1.18
6.00 110.00 7.82 4.78
innodb min_max_on_key 26.00 -29.39% -5.91
14.00 37.00 20.09 2.92
innodb multiple_value_insert 6.00 -12.36% -0.66
2.00 50.00 5.34 4.49
innodb once_prepared_select 29.00 -22.56% -5.34
18.00 32.00 23.66 3.34
innodb order_by_big 16.00 -12.03% -1.72
12.00 31.00 14.28 1.57
innodb order_by_big_key 16.00 -21.65% -2.85
11.00 32.00 13.15 1.63
innodb order_by_big_key2 14.00 -15.79% -1.91
10.00 33.00 12.09 1.57
innodb order_by_big_key_desc 17.00 -27.71% -3.69
11.00 32.00 13.31 1.64
innodb order_by_big_key_diff 13.00 -7.16% -0.87
10.00 31.00 12.13 1.53
innodb order_by_big_key_prefix 13.00 -5.79% -0.71
10.00 32.00 12.29 1.59
innodb order_by_key2_diff 1.00 +28.33% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -27.30% -0.21
0.00 2.00 0.79 0.42
innodb order_by_range 1.00 -22.08% -0.18
0.00 2.00 0.82 0.39
innodb outer_join 24.00 -25.74% -4.91
15.00 61.00 19.09 3.74
innodb outer_join_found 22.00 -18.70% -3.47
14.00 58.00 18.53 3.59
innodb outer_join_not_found 20.00 -23.39% -3.79
12.00 46.00 16.21 3.15
innodb outer_join_on_key 16.00 -25.71% -3.27
10.00 59.00 12.73 2.80
innodb prepared_select 38.00 -23.94% -7.34
22.00 40.00 30.66 4.27
innodb select_1_row 4.00 -44.17% -1.23
2.00 4.00 2.77 0.67
innodb select_1_row_cache 3.00 -15.88% -0.41
2.00 4.00 2.59 0.64
innodb select_2_rows 4.00 -43.17% -1.21
2.00 4.00 2.79 0.67
innodb select_big 14.00 -16.07% -1.94
0.00 31.00 12.06 1.56
innodb select_big_str 1.00 +12.32% 0.14
0.00 2.00 1.14 0.35
innodb select_cache 67.00 -13.13% -7.78
49.00 77.00 59.22 5.68
innodb select_cache2 64.00 -7.24% -4.32
49.00 75.00 59.68 6.48
innodb select_column+column 4.00 -41.28% -1.17
2.00 4.00 2.83 0.68
innodb select_diff_key 0.00 +100.00% 0.21
0.00 1.00 0.21 0.41
innodb select_distinct 4.00 +4.93% 0.21
3.00 8.00 4.21 0.54
innodb select_group 15.00 +7.27% 1.18
4.00 136.00 16.18 5.70
innodb select_group_when_MANY_tables 12.00 -30.77% -2.82
3.00 49.00 9.18 9.92
innodb select_join 1.00 -75.96% -0.43
0.00 1.00 0.57 0.50
innodb select_key 65.00 -26.15% -13.47
40.00 66.00 51.53 6.84
innodb select_key2 72.00 -23.80% -13.84
45.00 75.00 58.16 7.76
innodb select_key2_return_key 69.00 -24.37% -13.52
42.00 70.00 55.48 7.51
innodb select_key2_return_prim 70.00 -24.50% -13.77
42.00 72.00 56.23 7.66
innodb select_key_prefix 72.00 -25.50% -14.63
44.00 75.00 57.37 7.72
innodb select_key_prefix_join 6.00 -28.48% -1.33
3.00 10.00 4.67 0.66
innodb select_key_return_key 63.00 -24.64% -12.45
38.00 65.00 50.55 6.84
innodb select_many_fields 13.00 +14.12% 2.14
11.00 19.00 15.14 1.78
innodb select_range 46.00 +3.30% 1.57
39.00 76.00 47.57 3.80
innodb select_range_key2 10.00 -23.21% -1.88
6.00 10.00 8.12 0.99
innodb select_range_prefix 9.00 -17.15% -1.32
5.00 10.00 7.68 1.04
innodb select_simple 2.00 -24.66% -0.40
1.00 3.00 1.60 0.52
innodb select_simple_cache 2.00 -33.10% -0.50
1.00 3.00 1.50 0.52
innodb select_simple_join 0.00 +100.00% 0.64
0.00 3.00 0.64 0.49
innodb update_autocommit 4.00 -21.47% -0.71
2.00 16.00 3.29 1.05
innodb update_big 59.00 -17.79% -8.91
31.00 195.00 50.09 25.64
innodb update_commit 2.00 -31.58% -0.48
1.00 10.00 1.52 0.75
innodb update_of_key 24.00 +1.83% 0.45
18.00 100.00 24.45 6.46
innodb update_of_key_big 30.00 -13.24% -3.51
15.00 75.00 26.49 11.10
innodb update_of_primary_key_many_keys 1347.00 -10.04% -122.93
647.00 6065.00 1224.07 1,027.05
innodb update_rollback 2.00 -15.93% -0.27
1.00 31.00 1.73 2.00
innodb update_with_key 125.00 -15.21% -16.50
90.00 598.00 108.50 21.48
innodb update_with_key_prefix 45.00 -15.05% -5.89
33.00 202.00 39.11 6.96
innodb wisc_benchmark 2.00 +18.93% 0.47
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2109.1.4: Lee Bieber 2011-01-24 need to add a drop table a in execute.wait
test
2109.1.3: Lee Bieber 2011-01-24 Add execute test suite to regular test run
2109.1.2: Lee Bieber 2011-01-24 [merge] Merge Lee - fix second part of
705699, check for both client and server before building and testing rabbitmq
plugin
2100.2.3: Lee Bieber 2011-01-24 Fixes second part of the bug, don't build
the plugin unless you have both the client and the server
2109.1.1: Lee Bieber 2011-01-24 [merge] Merge Shrews - Changes
TransactionServices methods to use references to Session objects instead of
pointers.
2096.2.3: David Shrewsbury 2011-01-24 [merge] Merge with trunk and fix
conflicts
2096.2.2: David Shrewsbury 2011-01-20 [merge] Merge trunk
2096.2.1: David Shrewsbury 2011-01-20 Initial change to use references to
Session in TransactionServices methods rather than pointers.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : drizzle-benchmark@lists.launchpad.net
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
