=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 937
RUN DATE: 2011-03-02T22:15:50.227132
SERVER: drizzled
VERSION: staging
REVISION: 2216
COMMENT: 2216: Lee Bieber 2011-03-02 [merge] Merge Patrick - 727506: Can't run
dbqp on rhel 5.5
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 31.00 +4.91% 1.60
31.00 34.00 32.60 1.02
innodb alter_table_drop 26.00 -7.44% -1.80
23.00 26.00 24.20 1.17
innodb connect 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb connect+select_1_row 2.00 +28.57% 0.80
2.00 3.00 2.80 0.40
innodb connect+select_simple 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
innodb count 14.00 +13.58% 2.20
13.00 18.00 16.20 2.23
innodb count_distinct 6.00 +11.76% 0.80
6.00 8.00 6.80 0.75
innodb count_distinct_2 13.00 +7.14% 1.00
12.00 16.00 14.00 1.41
innodb count_distinct_big 20.00 +13.04% 3.00
20.00 25.00 23.00 2.10
innodb count_distinct_group 15.00 +1.32% 0.20
14.00 16.00 15.20 0.75
innodb count_distinct_group_on_key 10.00 -2.04% -0.20
8.00 11.00 9.80 1.17
innodb count_distinct_group_on_key_parts 13.00 +7.14% 1.00
13.00 15.00 14.00 0.63
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb count_group_on_key_parts 11.00 -1.85% -0.20
10.00 11.00 10.80 0.40
innodb count_on_key 90.00 +3.23% 3.00
90.00 95.00 93.00 1.90
innodb create+drop 33.00 +0.60% 0.20
32.00 34.00 33.20 0.75
innodb create_index 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb create_key+drop 32.00 -0.00% 0.00
31.00 33.00 32.00 0.63
innodb create_MANY_tables 21.00 -0.96% -0.20
20.00 22.00 20.80 0.75
innodb create_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 713.00 -5.82% -39.20
640.00 721.00 673.80 35.54
innodb delete_autocommit 4.00 -0.00% 0.00
3.00 5.00 4.00 0.63
innodb delete_big 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb delete_big_many_keys 712.00 -5.86% -39.40
639.00 719.00 672.60 35.27
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb delete_range 9.00 -0.00% 0.00
8.00 10.00 9.00 0.63
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb drop_table_when_MANY_tables 22.00 -14.58% -2.80
17.00 22.00 19.20 1.72
innodb insert 114.00 -0.35% -0.40
112.00 116.00 113.60 1.50
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 291.00 -2.75% -7.80
274.00 298.00 283.20 9.66
innodb insert_many_fields 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb insert_rollback 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
innodb insert_select_1_key 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb insert_select_2_keys 6.00 -3.45% -0.20
5.00 6.00 5.80 0.40
innodb min_max 7.00 +10.26% 0.80
7.00 9.00 7.80 0.98
innodb min_max_on_key 25.00 -0.81% -0.20
24.00 25.00 24.80 0.40
innodb multiple_value_insert 7.00 -2.94% -0.20
6.00 8.00 6.80 0.75
innodb once_prepared_select 29.00 +0.68% 0.20
29.00 30.00 29.20 0.40
innodb order_by_big 13.00 +13.33% 2.00
13.00 16.00 15.00 1.10
innodb order_by_big_key 12.00 +6.25% 0.80
12.00 13.00 12.80 0.40
innodb order_by_big_key2 12.00 +3.23% 0.40
11.00 15.00 12.40 1.36
innodb order_by_big_key_desc 14.00 -2.94% -0.40
13.00 14.00 13.60 0.49
innodb order_by_big_key_diff 11.00 +12.70% 1.60
11.00 14.00 12.60 1.20
innodb order_by_big_key_prefix 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb order_by_key2_diff 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
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 +13.46% 2.80
17.00 23.00 20.80 2.71
innodb outer_join_found 17.00 +14.14% 2.80
17.00 22.00 19.80 2.32
innodb outer_join_not_found 15.00 +14.77% 2.60
15.00 20.00 17.60 2.15
innodb outer_join_on_key 12.00 +13.04% 1.80
12.00 16.00 13.80 1.60
innodb prepared_select 37.00 +0.54% 0.20
36.00 38.00 37.20 0.75
innodb select_1_row 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb select_1_row_cache 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_2_rows 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_big 11.00 +8.33% 1.00
11.00 13.00 12.00 0.63
innodb select_big_str 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb select_cache 63.00 +0.63% 0.40
62.00 65.00 63.40 1.02
innodb select_cache2 65.00 -1.56% -1.00
60.00 65.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 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb select_distinct 4.00 +9.09% 0.40
4.00 5.00 4.40 0.49
innodb select_group 15.00 +5.06% 0.80
15.00 19.00 15.80 1.60
innodb select_group_when_MANY_tables 13.00 -4.84% -0.60
12.00 13.00 12.40 0.49
innodb select_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb select_key 64.00 -0.00% 0.00
63.00 66.00 64.00 1.10
innodb select_key2 70.00 +1.13% 0.80
69.00 73.00 70.80 1.47
innodb select_key2_return_key 68.00 +0.29% 0.20
67.00 70.00 68.20 0.98
innodb select_key2_return_prim 69.00 -0.00% 0.00
68.00 71.00 69.00 1.10
innodb select_key_prefix 70.00 +0.28% 0.20
69.00 72.00 70.20 0.98
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.64% -0.40
62.00 64.00 62.60 0.80
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 42.00 -0.48% -0.20
39.00 46.00 41.80 2.64
innodb select_range_key2 9.00 +6.25% 0.60
9.00 10.00 9.60 0.49
innodb select_range_prefix 8.00 +6.98% 0.60
8.00 9.00 8.60 0.49
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_cache 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
innodb select_simple_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb update_autocommit 3.00 +21.05% 0.80
3.00 5.00 3.80 0.75
innodb update_big 61.00 -4.10% -2.40
57.00 61.00 58.60 1.36
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 22.00 +1.79% 0.40
22.00 23.00 22.40 0.49
innodb update_of_key_big 37.00 -1.65% -0.60
34.00 39.00 36.40 1.62
innodb update_of_primary_key_many_keys 1430.00 -5.13% -69.80
1293.00 1465.00 1360.20 72.32
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 115.00 +3.85% 4.60
115.00 124.00 119.60 3.01
innodb update_with_key_prefix 47.00 -5.38% -2.40
41.00 47.00 44.60 2.06
innodb wisc_benchmark 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 31.00 +4.62% 1.50
30.00 34.00 32.50 1.16
innodb alter_table_drop 26.00 -8.79% -2.10
23.00 26.00 23.90 0.83
innodb connect 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb connect+select_1_row 2.00 +31.03% 0.90
2.00 3.00 2.90 0.30
innodb connect+select_simple 2.00 +27.27% 0.75
2.00 3.00 2.75 0.43
innodb count 14.00 +10.26% 1.60
13.00 19.00 15.60 2.11
innodb count_distinct 6.00 +12.41% 0.85
6.00 8.00 6.85 0.79
innodb count_distinct_2 13.00 +8.13% 1.15
11.00 16.00 14.15 1.19
innodb count_distinct_big 20.00 +11.11% 2.50
20.00 25.00 22.50 1.88
innodb count_distinct_group 15.00 -3.81% -0.55
12.00 16.00 14.45 1.07
innodb count_distinct_group_on_key 10.00 +1.96% 0.20
8.00 12.00 10.20 1.08
innodb count_distinct_group_on_key_parts 13.00 +3.70% 0.50
11.00 15.00 13.50 1.12
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb count_group_on_key_parts 11.00 +0.45% 0.05
10.00 12.00 11.05 0.50
innodb count_on_key 90.00 +3.43% 3.20
89.00 100.00 93.20 2.48
innodb create+drop 33.00 +1.64% 0.55
32.00 35.00 33.55 0.80
innodb create_index 3.00 +9.09% 0.30
3.00 4.00 3.30 0.46
innodb create_key+drop 32.00 -1.75% -0.55
29.00 37.00 31.45 1.60
innodb create_MANY_tables 21.00 -1.20% -0.25
20.00 22.00 20.75 0.62
innodb create_table 0.00 +100.00% 0.10
0.00 1.00 0.10 0.30
innodb delete_all_many_keys 713.00 -9.29% -60.60
580.00 721.00 652.40 34.40
innodb delete_autocommit 4.00 -5.26% -0.20
3.00 5.00 3.80 0.51
innodb delete_big 1.00 -53.85% -0.35
0.00 1.00 0.65 0.48
innodb delete_big_many_keys 712.00 -9.29% -60.55
580.00 719.00 651.45 34.08
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 9.00 -0.56% -0.05
8.00 11.00 8.95 0.67
innodb delete_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb drop_index 3.00 -0.00% 0.00
2.00 4.00 3.00 0.45
innodb drop_table 0.00 +100.00% 0.15
0.00 1.00 0.15 0.36
innodb drop_table_when_MANY_tables 22.00 -16.71% -3.15
17.00 22.00 18.85 1.15
innodb insert 114.00 -0.31% -0.35
112.00 116.00 113.65 1.15
innodb insert_autocommit 3.00 +1.64% 0.05
3.00 4.00 3.05 0.22
innodb insert_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb insert_duplicates 19.00 +0.78% 0.15
19.00 20.00 19.15 0.36
innodb insert_key 291.00 -3.12% -8.80
263.00 302.00 282.20 10.60
innodb insert_many_fields 6.00 -1.69% -0.10
5.00 7.00 5.90 0.44
innodb insert_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb insert_select_1_key 4.00 -5.26% -0.20
3.00 5.00 3.80 0.51
innodb insert_select_2_keys 6.00 +6.25% 0.40
5.00 7.00 6.40 0.58
innodb min_max 7.00 +11.95% 0.95
7.00 9.00 7.95 0.92
innodb min_max_on_key 25.00 -1.42% -0.35
24.00 26.00 24.65 0.57
innodb multiple_value_insert 7.00 -9.38% -0.60
5.00 8.00 6.40 0.73
innodb once_prepared_select 29.00 +0.68% 0.20
28.00 30.00 29.20 0.51
innodb order_by_big 13.00 +11.26% 1.65
13.00 16.00 14.65 1.11
innodb order_by_big_key 12.00 +15.19% 2.15
12.00 16.00 14.15 1.49
innodb order_by_big_key2 12.00 +10.11% 1.35
11.00 15.00 13.35 1.01
innodb order_by_big_key_desc 14.00 +6.35% 0.95
13.00 17.00 14.95 1.12
innodb order_by_big_key_diff 11.00 +16.03% 2.10
11.00 14.00 13.10 0.89
innodb order_by_big_key_prefix 13.00 +3.70% 0.50
12.00 15.00 13.50 0.67
innodb order_by_key2_diff 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
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 -11.11% -0.10
0.00 1.00 0.90 0.30
innodb outer_join 18.00 +13.04% 2.70
17.00 24.00 20.70 2.65
innodb outer_join_found 17.00 +15.00% 3.00
16.00 23.00 20.00 2.53
innodb outer_join_not_found 15.00 +17.58% 3.20
15.00 23.00 18.20 2.54
innodb outer_join_on_key 12.00 +13.98% 1.95
11.00 17.00 13.95 1.86
innodb prepared_select 37.00 +0.67% 0.25
36.00 38.00 37.25 0.54
innodb select_1_row 4.00 -19.40% -0.65
3.00 4.00 3.35 0.48
innodb select_1_row_cache 3.00 +18.92% 0.70
3.00 4.00 3.70 0.46
innodb select_2_rows 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb select_big 11.00 +14.73% 1.90
11.00 15.00 12.90 1.18
innodb select_big_str 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb select_cache 63.00 +1.25% 0.80
57.00 70.00 63.80 3.76
innodb select_cache2 65.00 -3.17% -2.00
57.00 68.00 63.00 2.90
innodb select_column+column 4.00 -8.11% -0.30
3.00 4.00 3.70 0.46
innodb select_diff_key 1.00 -185.71% -0.65
0.00 1.00 0.35 0.48
innodb select_distinct 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb select_group 15.00 +5.36% 0.85
15.00 19.00 15.85 1.19
innodb select_group_when_MANY_tables 13.00 -7.44% -0.90
11.00 14.00 12.10 0.77
innodb select_join 1.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.70
innodb select_key2 70.00 +1.34% 0.95
69.00 73.00 70.95 0.97
innodb select_key2_return_key 68.00 +0.44% 0.30
67.00 70.00 68.30 0.64
innodb select_key2_return_prim 69.00 +0.36% 0.25
68.00 71.00 69.25 0.83
innodb select_key_prefix 70.00 +0.57% 0.40
69.00 72.00 70.40 0.73
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 42.00 +0.83% 0.35
39.00 47.00 42.35 2.41
innodb select_range_key2 9.00 +5.76% 0.55
8.00 10.00 9.55 0.59
innodb select_range_prefix 8.00 +12.09% 1.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 3.00 -46.34% -0.95
2.00 3.00 2.05 0.22
innodb select_simple_join 1.00 -11.11% -0.10
0.00 1.00 0.90 0.30
innodb update_autocommit 3.00 +18.92% 0.70
3.00 5.00 3.70 0.56
innodb update_big 61.00 -3.48% -2.05
57.00 64.00 58.95 1.83
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 22.00 +2.00% 0.45
21.00 24.00 22.45 0.80
innodb update_of_key_big 37.00 -3.35% -1.20
29.00 41.00 35.80 2.82
innodb update_of_primary_key_many_keys 1430.00 -6.62% -88.75
1217.00 1470.00 1341.25 66.83
innodb update_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb update_with_key 115.00 +4.52% 5.45
115.00 124.00 120.45 2.16
innodb update_with_key_prefix 47.00 -4.91% -2.20
41.00 48.00 44.80 2.06
innodb wisc_benchmark 2.00 +18.37% 0.45
2.00 3.00 2.45 0.50
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 31.00 -46.55% -9.85
11.00 61.00 21.15 10.11
innodb alter_table_drop 26.00 -40.97% -7.56
10.00 57.00 18.44 6.95
innodb connect 2.00 +3.87% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 2.00 +25.98% 0.70
2.00 5.00 2.70 0.47
innodb connect+select_simple 2.00 +14.89% 0.35
1.00 3.00 2.35 0.48
innodb count 14.00 +11.08% 1.75
12.00 193.00 15.75 8.78
innodb count_distinct 6.00 +8.65% 0.57
5.00 50.00 6.57 2.26
innodb count_distinct_2 13.00 +1.48% 0.20
11.00 63.00 13.20 2.94
innodb count_distinct_big 20.00 +8.83% 1.94
5.00 67.00 21.94 3.01
innodb count_distinct_group 15.00 -13.96% -1.84
10.00 68.00 13.16 3.08
innodb count_distinct_group_on_key 10.00 -5.21% -0.50
7.00 69.00 9.50 3.01
innodb count_distinct_group_on_key_parts 13.00 -5.38% -0.66
9.00 72.00 12.34 3.14
innodb count_distinct_key_prefix 5.00 +2.45% 0.13
3.00 52.00 5.13 2.37
innodb count_group_on_key_parts 11.00 -10.10% -1.01
7.00 72.00 9.99 3.14
innodb count_on_key 90.00 -4.58% -3.94
68.00 107.00 86.06 7.38
innodb create+drop 33.00 -1.71% -0.55
18.00 75.00 32.45 11.83
innodb create_index 3.00 -3.70% -0.11
1.00 8.00 2.89 1.14
innodb create_key+drop 32.00 -13.38% -3.78
21.00 50.00 28.22 4.90
innodb create_MANY_tables 21.00 +38.12% 12.94
14.00 121.00 33.94 17.06
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.36
innodb delete_all_many_keys 713.00 -52.98% -246.94
212.00 1888.00 466.06 363.46
innodb delete_autocommit 4.00 -16.00% -0.55
2.00 14.00 3.45 0.75
innodb delete_big 1.00 -236.43% -0.70
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 712.00 -50.82% -239.91
212.00 2293.00 472.09 377.55
innodb delete_commit 2.00 -32.12% -0.49
1.00 5.00 1.51 0.53
innodb delete_key 3.00 +1.70% 0.05
2.00 35.00 3.05 1.49
innodb delete_range 9.00 -8.21% -0.68
5.00 23.00 8.32 3.22
innodb delete_rollback 2.00 -14.89% -0.26
1.00 12.00 1.74 0.91
innodb drop_index 3.00 -1.68% -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 22.00 -12.42% -2.43
11.00 90.00 19.57 7.50
innodb insert 114.00 -6.78% -7.24
3.00 343.00 106.76 14.54
innodb insert_autocommit 3.00 -0.00% 0.00
2.00 99.00 3.00 3.30
innodb insert_commit 2.00 -44.79% -0.62
1.00 3.00 1.38 0.50
innodb insert_duplicates 19.00 -22.65% -3.51
11.00 21.00 15.49 2.66
innodb insert_key 291.00 +3.95% 11.98
142.00 700.00 302.98 106.57
innodb insert_many_fields 6.00 -7.00% -0.39
3.00 17.00 5.61 1.77
innodb insert_rollback 2.00 -19.64% -0.33
1.00 3.00 1.67 0.54
innodb insert_select_1_key 4.00 -5.80% -0.22
2.00 10.00 3.78 0.88
innodb insert_select_2_keys 6.00 +1.22% 0.07
4.00 16.00 6.07 2.08
innodb min_max 7.00 +10.57% 0.83
6.00 110.00 7.83 4.53
innodb min_max_on_key 25.00 -21.51% -4.43
14.00 37.00 20.57 3.10
innodb multiple_value_insert 7.00 -28.12% -1.54
2.00 50.00 5.46 4.27
innodb once_prepared_select 29.00 -19.61% -4.75
18.00 32.00 24.25 3.58
innodb order_by_big 13.00 +9.19% 1.32
12.00 31.00 14.32 1.53
innodb order_by_big_key 12.00 +9.67% 1.28
11.00 32.00 13.28 1.64
innodb order_by_big_key2 12.00 +1.72% 0.21
10.00 33.00 12.21 1.55
innodb order_by_big_key_desc 14.00 -3.61% -0.49
11.00 32.00 13.51 1.69
innodb order_by_big_key_diff 11.00 +10.10% 1.24
10.00 31.00 12.24 1.50
innodb order_by_big_key_prefix 13.00 -4.76% -0.59
10.00 32.00 12.41 1.56
innodb order_by_key2_diff 1.00 +28.47% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -26.02% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -20.25% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 18.00 +6.96% 1.35
15.00 61.00 19.35 3.72
innodb outer_join_found 17.00 +9.43% 1.77
14.00 58.00 18.77 3.57
innodb outer_join_not_found 15.00 +8.93% 1.47
12.00 46.00 16.47 3.17
innodb outer_join_on_key 12.00 +7.07% 0.91
10.00 59.00 12.91 2.77
innodb prepared_select 37.00 -17.98% -5.64
22.00 40.00 31.36 4.52
innodb select_1_row 4.00 -40.16% -1.15
2.00 4.00 2.85 0.69
innodb select_1_row_cache 3.00 -11.60% -0.31
2.00 4.00 2.69 0.69
innodb select_2_rows 4.00 -38.87% -1.12
2.00 4.00 2.88 0.70
innodb select_big 11.00 +9.60% 1.17
0.00 31.00 12.17 1.55
innodb select_big_str 1.00 +14.29% 0.17
0.00 2.00 1.17 0.38
innodb select_cache 63.00 -5.61% -3.35
49.00 77.00 59.65 5.62
innodb select_cache2 65.00 -8.34% -5.00
49.00 75.00 60.00 6.26
innodb select_column+column 4.00 -36.64% -1.07
2.00 4.00 2.93 0.72
innodb select_diff_key 1.00 -351.56% -0.78
0.00 1.00 0.22 0.42
innodb select_distinct 4.00 +5.59% 0.24
3.00 8.00 4.24 0.54
innodb select_group 15.00 +7.76% 1.26
4.00 136.00 16.26 5.41
innodb select_group_when_MANY_tables 13.00 -37.07% -3.52
3.00 49.00 9.48 9.42
innodb select_join 1.00 -72.76% -0.42
0.00 1.00 0.58 0.49
innodb select_key 64.00 -21.16% -11.18
40.00 66.00 52.82 7.47
innodb select_key2 70.00 -17.62% -10.49
45.00 75.00 59.51 8.32
innodb select_key2_return_key 68.00 -19.63% -11.16
42.00 71.00 56.84 8.12
innodb select_key2_return_prim 69.00 -19.78% -11.40
42.00 72.00 57.60 8.26
innodb select_key_prefix 70.00 -19.11% -11.23
44.00 75.00 58.77 8.34
innodb select_key_prefix_join 5.00 -5.90% -0.28
3.00 10.00 4.72 0.65
innodb select_key_return_key 63.00 -21.51% -11.15
38.00 65.00 51.85 7.48
innodb select_many_fields 13.00 +12.93% 1.93
11.00 19.00 14.93 1.79
innodb select_range 42.00 +10.65% 5.01
38.00 76.00 47.01 4.03
innodb select_range_key2 9.00 -8.89% -0.73
6.00 11.00 8.27 1.05
innodb select_range_prefix 8.00 -1.97% -0.15
5.00 10.00 7.85 1.11
innodb select_simple 2.00 -21.28% -0.35
1.00 3.00 1.65 0.51
innodb select_simple_cache 3.00 -92.54% -1.44
1.00 3.00 1.56 0.51
innodb select_simple_join 1.00 -51.92% -0.34
0.00 3.00 0.66 0.48
innodb update_autocommit 3.00 +10.02% 0.33
2.00 16.00 3.33 1.01
innodb update_big 61.00 -19.51% -9.96
31.00 195.00 51.04 24.39
innodb update_commit 2.00 -27.74% -0.43
1.00 10.00 1.57 0.73
innodb update_of_key 22.00 +9.16% 2.22
18.00 100.00 24.22 6.15
innodb update_of_key_big 37.00 -34.55% -9.50
15.00 75.00 27.50 10.94
innodb update_of_primary_key_many_keys 1430.00 -15.19% -188.55
647.00 6065.00 1241.45 954.87
innodb update_rollback 2.00 -13.54% -0.24
1.00 31.00 1.76 1.89
innodb update_with_key 115.00 -4.62% -5.07
90.00 598.00 109.93 20.73
innodb update_with_key_prefix 47.00 -18.47% -7.33
33.00 202.00 39.67 6.82
innodb wisc_benchmark 2.00 +19.07% 0.47
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2215.1.3: Lee Bieber 2011-03-02 Fix distcheck issue with docs
2215.1.2: Lee Bieber 2011-03-02 [merge] Merge Patrick - 727506: Can't run
dbqp on rhel 5.5
2211.3.2: patrick crews 2011-03-02 Including uuid module so we can work
with red hat...grr. We could require packages and whatnot, but just inlcuding
the small file until such time as redhat moves to python 2.5 seems good
2215.1.1: Lee Bieber 2011-03-02 [merge] Merge Marisa - latest documentation
updates
1994.4.105: Marisa Plumb 2011-03-02 starting red hat fixes
1994.4.104: Marisa Plumb 2011-03-02 new doc with note about versioning
1994.4.103: Marisa Plumb 2011-03-02 [merge] more updates
1994.4.102: Marisa Plumb 2011-03-02 [merge] update
1994.4.101: Marisa Plumb 2011-03-01 [merge] updating
1994.4.100: Marisa Plumb 2011-02-28 addressing bug 723669
1994.4.99: Marisa Plumb 2011-02-28 adding drizzleadmin as manpage in
include.am
1994.4.98: Marisa Plumb 2011-02-27 [merge] updating
1994.4.97: Marisa Plumb 2011-02-24 [merge] updating
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
