=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 897
RUN DATE: 2011-02-14T21:04:23.548663
SERVER: drizzled
VERSION: staging
REVISION: 2169
COMMENT: 2169: Monty Taylor 2011-02-14 [merge] Merge Haildb fixes from Stewart
and various small build cleanups from Monty.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -0.00% 0.00
32.00 32.00 32.00 0.00
innodb alter_table_drop 23.00 +3.36% 0.80
23.00 25.00 23.80 0.75
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 17.00 -10.39% -1.60
14.00 18.00 15.40 1.74
innodb count_distinct 7.00 -0.00% 0.00
7.00 7.00 7.00 0.00
innodb count_distinct_2 15.00 -5.63% -0.80
12.00 16.00 14.20 1.47
innodb count_distinct_big 21.00 +5.41% 1.20
21.00 24.00 22.20 1.17
innodb count_distinct_group 14.00 -4.48% -0.60
11.00 15.00 13.40 1.62
innodb count_distinct_group_on_key 11.00 +14.06% 1.80
9.00 17.00 12.80 3.12
innodb count_distinct_group_on_key_parts 15.00 -17.19% -2.20
11.00 15.00 12.80 1.60
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 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_on_key 93.00 +0.64% 0.60
91.00 96.00 93.60 2.06
innodb create+drop 32.00 -2.56% -0.80
30.00 32.00 31.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 -5.96% -1.80
29.00 32.00 30.20 0.98
innodb create_MANY_tables 20.00 -0.00% 0.00
19.00 21.00 20.00 0.63
innodb create_table 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 636.00 -0.76% -4.80
624.00 640.00 631.20 6.40
innodb delete_autocommit 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb delete_big 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb delete_big_many_keys 636.00 -0.92% -5.80
623.00 639.00 630.20 6.55
innodb delete_commit 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
innodb delete_key 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb delete_range 9.00 -7.14% -0.60
7.00 9.00 8.40 0.80
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb drop_table_when_MANY_tables 16.00 -1.27% -0.20
15.00 16.00 15.80 0.40
innodb insert 115.00 -0.52% -0.60
114.00 115.00 114.40 0.49
innodb insert_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb insert_commit 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb insert_duplicates 19.00 -0.00% 0.00
18.00 20.00 19.00 0.63
innodb insert_key 274.00 -0.29% -0.80
269.00 276.00 273.20 2.48
innodb insert_many_fields 6.00 -7.14% -0.40
5.00 6.00 5.60 0.49
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 3.00 +21.05% 0.80
3.00 5.00 3.80 0.75
innodb insert_select_2_keys 6.00 -0.00% 0.00
4.00 7.00 6.00 1.10
innodb min_max 9.00 -15.38% -1.20
7.00 9.00 7.80 0.98
innodb min_max_on_key 26.00 -6.56% -1.60
24.00 26.00 24.40 0.80
innodb multiple_value_insert 6.00 +11.76% 0.80
6.00 8.00 6.80 0.75
innodb once_prepared_select 30.00 -2.04% -0.60
29.00 30.00 29.40 0.49
innodb order_by_big 16.00 -11.11% -1.60
13.00 16.00 14.40 1.20
innodb order_by_big_key 16.00 -11.11% -1.60
12.00 16.00 14.40 1.50
innodb order_by_big_key2 12.00 +7.69% 1.00
12.00 14.00 13.00 0.63
innodb order_by_big_key_desc 15.00 +1.32% 0.20
14.00 16.00 15.20 0.75
innodb order_by_big_key_diff 13.00 -1.56% -0.20
12.00 14.00 12.80 0.75
innodb order_by_big_key_prefix 12.00 +11.76% 1.60
12.00 14.00 13.60 0.80
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.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 24.00 -3.45% -0.80
17.00 26.00 23.20 3.19
innodb outer_join_found 23.00 -1.77% -0.40
17.00 25.00 22.60 2.94
innodb outer_join_not_found 21.00 -5.00% -1.00
14.00 22.00 20.00 3.03
innodb outer_join_on_key 16.00 -3.90% -0.60
11.00 17.00 15.40 2.24
innodb prepared_select 38.00 -1.60% -0.60
37.00 38.00 37.40 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 +4.41% 0.60
12.00 15.00 13.60 1.02
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 67.00 -2.13% -1.40
63.00 70.00 65.60 2.58
innodb select_cache2 64.00 -1.27% -0.80
62.00 65.00 63.20 1.17
innodb select_column+column 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_diff_key 0.00 +100.00% 0.40
0.00 1.00 0.40 0.49
innodb select_distinct 4.00 +13.04% 0.60
4.00 5.00 4.60 0.49
innodb select_group 15.00 +10.71% 1.80
15.00 18.00 16.80 1.47
innodb select_group_when_MANY_tables 11.00 +5.17% 0.60
11.00 12.00 11.60 0.49
innodb select_join 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb select_key 66.00 -2.80% -1.80
63.00 66.00 64.20 0.98
innodb select_key2 73.00 -2.24% -1.60
70.00 73.00 71.40 1.02
innodb select_key2_return_key 71.00 -3.50% -2.40
68.00 71.00 68.60 1.20
innodb select_key2_return_prim 71.00 -1.72% -1.20
69.00 71.00 69.80 0.75
innodb select_key_prefix 73.00 -2.53% -1.80
70.00 73.00 71.20 0.98
innodb select_key_prefix_join 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb select_key_return_key 64.00 -1.27% -0.80
63.00 64.00 63.20 0.40
innodb select_many_fields 13.00 +2.99% 0.40
13.00 14.00 13.40 0.49
innodb select_range 45.00 -4.17% -1.80
39.00 49.00 43.20 3.49
innodb select_range_key2 10.00 -0.00% 0.00
10.00 10.00 10.00 0.00
innodb select_range_prefix 9.00 -4.65% -0.40
8.00 9.00 8.60 0.49
innodb select_simple 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb select_simple_cache 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb update_autocommit 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb update_big 59.00 -0.68% -0.40
57.00 59.00 58.60 0.80
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 22.00 +3.51% 0.80
21.00 24.00 22.80 1.17
innodb update_of_key_big 37.00 -3.93% -1.40
29.00 38.00 35.60 3.38
innodb update_of_primary_key_many_keys 1317.00 -0.26% -3.40
1297.00 1334.00 1313.60 13.35
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 122.00 +0.97% 1.20
122.00 124.00 123.20 0.98
innodb update_with_key_prefix 43.00 -0.00% 0.00
41.00 45.00 43.00 1.26
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.39% 0.45
32.00 34.00 32.45 0.59
innodb alter_table_drop 23.00 +4.37% 1.05
23.00 25.00 24.05 0.74
innodb connect 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
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 -11.11% -0.30
2.00 3.00 2.70 0.46
innodb count 17.00 -10.75% -1.65
13.00 18.00 15.35 1.82
innodb count_distinct 7.00 -5.26% -0.35
6.00 8.00 6.65 0.65
innodb count_distinct_2 15.00 -8.70% -1.20
12.00 16.00 13.80 1.25
innodb count_distinct_big 21.00 +6.87% 1.55
20.00 25.00 22.55 1.60
innodb count_distinct_group 14.00 +2.10% 0.30
11.00 16.00 14.30 1.23
innodb count_distinct_group_on_key 11.00 -4.76% -0.50
8.00 17.00 10.50 2.18
innodb count_distinct_group_on_key_parts 15.00 -12.78% -1.70
11.00 15.00 13.30 1.05
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
4.00 6.00 5.20 0.60
innodb count_group_on_key_parts 11.00 -0.46% -0.05
10.00 12.00 10.95 0.38
innodb count_on_key 93.00 +0.80% 0.75
91.00 97.00 93.75 1.73
innodb create+drop 32.00 -0.63% -0.20
30.00 34.00 31.80 1.25
innodb create_index 3.00 +3.23% 0.10
2.00 4.00 3.10 0.44
innodb create_key+drop 32.00 -9.22% -2.70
28.00 32.00 29.30 0.95
innodb create_MANY_tables 20.00 +2.44% 0.50
19.00 22.00 20.50 0.74
innodb create_table 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 636.00 +3.54% 23.35
569.00 738.00 659.35 46.14
innodb delete_autocommit 3.00 +14.29% 0.50
3.00 4.00 3.50 0.50
innodb delete_big 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb delete_big_many_keys 636.00 +3.40% 22.40
569.00 737.00 658.40 46.01
innodb delete_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb delete_key 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb delete_range 9.00 -4.65% -0.40
7.00 10.00 8.60 0.73
innodb delete_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb drop_index 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb drop_table_when_MANY_tables 16.00 +0.62% 0.10
15.00 17.00 16.10 0.62
innodb insert 115.00 -0.70% -0.80
112.00 116.00 114.20 1.03
innodb insert_autocommit 4.00 -23.08% -0.75
3.00 4.00 3.25 0.43
innodb insert_commit 1.00 +42.86% 0.75
1.00 2.00 1.75 0.43
innodb insert_duplicates 19.00 +0.52% 0.10
18.00 20.00 19.10 0.54
innodb insert_key 274.00 +3.35% 9.50
266.00 304.00 283.50 12.51
innodb insert_many_fields 6.00 -4.35% -0.25
5.00 6.00 5.75 0.43
innodb insert_rollback 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb insert_select_1_key 3.00 +24.05% 0.95
3.00 5.00 3.95 0.59
innodb insert_select_2_keys 6.00 +5.51% 0.35
4.00 8.00 6.35 0.85
innodb min_max 9.00 -15.38% -1.20
6.00 9.00 7.80 0.98
innodb min_max_on_key 26.00 -6.34% -1.55
24.00 26.00 24.45 0.59
innodb multiple_value_insert 6.00 +9.09% 0.60
5.00 8.00 6.60 0.80
innodb once_prepared_select 30.00 -2.56% -0.75
29.00 30.00 29.25 0.43
innodb order_by_big 16.00 -12.28% -1.75
13.00 16.00 14.25 1.13
innodb order_by_big_key 16.00 -9.97% -1.45
12.00 17.00 14.55 1.24
innodb order_by_big_key2 12.00 +7.69% 1.00
12.00 14.00 13.00 0.63
innodb order_by_big_key_desc 15.00 +1.32% 0.20
14.00 16.00 15.20 0.68
innodb order_by_big_key_diff 13.00 +0.38% 0.05
12.00 14.00 13.05 0.80
innodb order_by_big_key_prefix 12.00 +11.11% 1.50
12.00 15.00 13.50 0.81
innodb order_by_key2_diff 2.00 -29.03% -0.45
1.00 2.00 1.55 0.50
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 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 24.00 -7.87% -1.75
17.00 26.00 22.25 3.14
innodb outer_join_found 23.00 -6.73% -1.45
16.00 25.00 21.55 3.17
innodb outer_join_not_found 21.00 -12.00% -2.25
14.00 22.00 18.75 2.91
innodb outer_join_on_key 16.00 -8.11% -1.20
11.00 18.00 14.80 2.23
innodb prepared_select 38.00 -2.15% -0.80
37.00 38.00 37.20 0.40
innodb select_1_row 4.00 -12.68% -0.45
3.00 4.00 3.55 0.50
innodb select_1_row_cache 3.00 +13.04% 0.45
3.00 4.00 3.45 0.50
innodb select_2_rows 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_big 13.00 +0.76% 0.10
12.00 15.00 13.10 0.89
innodb select_big_str 1.00 +20.00% 0.25
1.00 2.00 1.25 0.43
innodb select_cache 67.00 -6.10% -3.85
57.00 71.00 63.15 3.68
innodb select_cache2 64.00 -1.99% -1.25
60.00 67.00 62.75 1.92
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.30
0.00 1.00 0.30 0.46
innodb select_distinct 4.00 +13.04% 0.60
4.00 5.00 4.60 0.49
innodb select_group 15.00 +12.02% 2.05
15.00 19.00 17.05 1.47
innodb select_group_when_MANY_tables 11.00 +9.47% 1.15
11.00 14.00 12.15 0.85
innodb select_join 1.00 -42.86% -0.30
0.00 1.00 0.70 0.46
innodb select_key 66.00 -3.69% -2.35
63.00 66.00 63.65 0.73
innodb select_key2 73.00 -2.74% -1.95
70.00 73.00 71.05 1.02
innodb select_key2_return_key 71.00 -3.80% -2.60
67.00 71.00 68.40 0.92
innodb select_key2_return_prim 71.00 -2.45% -1.70
68.00 71.00 69.30 0.90
innodb select_key_prefix 73.00 -3.25% -2.30
69.00 73.00 70.70 0.84
innodb select_key_prefix_join 5.00 +2.91% 0.15
5.00 6.00 5.15 0.36
innodb select_key_return_key 64.00 -1.67% -1.05
62.00 64.00 62.95 0.59
innodb select_many_fields 13.00 +1.89% 0.25
13.00 14.00 13.25 0.43
innodb select_range 45.00 -6.76% -2.85
39.00 49.00 42.15 2.39
innodb select_range_key2 10.00 -4.71% -0.45
9.00 10.00 9.55 0.50
innodb select_range_prefix 9.00 +2.17% 0.20
8.00 10.00 9.20 0.68
innodb select_simple 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb select_simple_cache 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -42.86% -0.30
0.00 1.00 0.70 0.46
innodb update_autocommit 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb update_big 59.00 +0.59% 0.35
56.00 64.00 59.35 2.13
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 22.00 +1.35% 0.30
21.00 25.00 22.30 1.23
innodb update_of_key_big 37.00 -3.50% -1.25
29.00 47.00 35.75 3.79
innodb update_of_primary_key_many_keys 1317.00 +2.94% 39.85
1203.00 1482.00 1356.85 80.18
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 122.00 +0.16% 0.20
117.00 127.00 122.20 2.56
innodb update_with_key_prefix 43.00 +2.16% 0.95
40.00 50.00 43.95 2.33
innodb wisc_benchmark 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -55.40% -11.41
11.00 61.00 20.59 10.01
innodb alter_table_drop 23.00 -26.52% -4.82
10.00 57.00 18.18 7.00
innodb connect 2.00 +3.77% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -11.42% -0.31
2.00 5.00 2.69 0.48
innodb connect+select_simple 3.00 -28.59% -0.67
1.00 3.00 2.33 0.48
innodb count 17.00 -7.91% -1.25
12.00 193.00 15.75 8.98
innodb count_distinct 7.00 -6.64% -0.44
5.00 50.00 6.56 2.31
innodb count_distinct_2 15.00 -14.00% -1.84
11.00 63.00 13.16 2.99
innodb count_distinct_big 21.00 +4.13% 0.91
5.00 67.00 21.91 3.05
innodb count_distinct_group 14.00 -6.90% -0.90
10.00 68.00 13.10 3.13
innodb count_distinct_group_on_key 11.00 -16.07% -1.52
7.00 69.00 9.48 3.07
innodb count_distinct_group_on_key_parts 15.00 -22.15% -2.72
9.00 72.00 12.28 3.20
innodb count_distinct_key_prefix 5.00 +2.31% 0.12
3.00 52.00 5.12 2.43
innodb count_group_on_key_parts 11.00 -10.65% -1.06
7.00 72.00 9.94 3.20
innodb count_on_key 93.00 -8.56% -7.33
68.00 107.00 85.67 7.31
innodb create+drop 32.00 +1.26% 0.41
18.00 75.00 32.41 12.11
innodb create_index 3.00 -4.45% -0.13
1.00 8.00 2.87 1.15
innodb create_key+drop 32.00 -13.98% -3.93
21.00 50.00 28.07 4.96
innodb create_MANY_tables 20.00 +42.15% 14.57
14.00 121.00 34.57 17.22
innodb create_table 1.00 -810.99% -0.89
0.00 3.00 0.11 0.37
innodb delete_all_many_keys 636.00 -39.31% -179.48
212.00 1888.00 456.52 369.95
innodb delete_autocommit 3.00 +12.63% 0.43
2.00 14.00 3.43 0.75
innodb delete_big 1.00 -255.36% -0.72
0.00 3.00 0.28 0.46
innodb delete_big_many_keys 636.00 -37.38% -173.06
212.00 2293.00 462.94 384.64
innodb delete_commit 2.00 -33.44% -0.50
1.00 5.00 1.50 0.53
innodb delete_key 3.00 +2.25% 0.07
2.00 35.00 3.07 1.52
innodb delete_range 9.00 -8.64% -0.72
5.00 23.00 8.28 3.29
innodb delete_rollback 2.00 -16.05% -0.28
1.00 12.00 1.72 0.93
innodb drop_index 4.00 -35.68% -1.05
1.00 9.00 2.95 1.34
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.23
innodb drop_table_when_MANY_tables 16.00 +18.44% 3.62
11.00 90.00 19.62 7.67
innodb insert 115.00 -8.06% -8.58
3.00 343.00 106.42 14.80
innodb insert_autocommit 4.00 -33.71% -1.01
2.00 99.00 2.99 3.38
innodb insert_commit 1.00 +26.33% 0.36
1.00 3.00 1.36 0.49
innodb insert_duplicates 19.00 -24.06% -3.68
11.00 21.00 15.32 2.60
innodb insert_key 274.00 +9.90% 30.10
142.00 700.00 304.10 109.23
innodb insert_many_fields 6.00 -7.22% -0.40
3.00 17.00 5.60 1.80
innodb insert_rollback 2.00 -21.14% -0.35
1.00 3.00 1.65 0.53
innodb insert_select_1_key 3.00 +20.61% 0.78
2.00 10.00 3.78 0.90
innodb insert_select_2_keys 6.00 +1.16% 0.07
4.00 16.00 6.07 2.13
innodb min_max 9.00 -15.06% -1.18
6.00 110.00 7.82 4.63
innodb min_max_on_key 26.00 -27.59% -5.62
14.00 37.00 20.38 3.03
innodb multiple_value_insert 6.00 -10.81% -0.59
2.00 50.00 5.41 4.36
innodb once_prepared_select 30.00 -24.97% -5.99
18.00 32.00 24.01 3.49
innodb order_by_big 16.00 -11.89% -1.70
12.00 31.00 14.30 1.54
innodb order_by_big_key 16.00 -20.96% -2.77
11.00 32.00 13.23 1.63
innodb order_by_big_key2 12.00 +1.29% 0.16
10.00 33.00 12.16 1.55
innodb order_by_big_key_desc 15.00 -11.65% -1.56
11.00 32.00 13.44 1.67
innodb order_by_big_key_diff 13.00 -6.61% -0.81
10.00 31.00 12.19 1.51
innodb order_by_big_key_prefix 12.00 +2.96% 0.37
10.00 32.00 12.37 1.58
innodb order_by_key2_diff 2.00 -43.08% -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.42
innodb order_by_range 1.00 -20.91% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 24.00 -24.73% -4.76
15.00 61.00 19.24 3.73
innodb outer_join_found 23.00 -23.15% -4.32
14.00 58.00 18.68 3.59
innodb outer_join_not_found 21.00 -28.39% -4.64
12.00 46.00 16.36 3.17
innodb outer_join_on_key 16.00 -24.63% -3.16
10.00 59.00 12.84 2.79
innodb prepared_select 38.00 -22.29% -6.93
22.00 40.00 31.07 4.43
innodb select_1_row 4.00 -41.47% -1.17
2.00 4.00 2.83 0.69
innodb select_1_row_cache 3.00 -13.51% -0.36
2.00 4.00 2.64 0.67
innodb select_2_rows 4.00 -40.51% -1.15
2.00 4.00 2.85 0.69
innodb select_big 13.00 -7.16% -0.87
0.00 31.00 12.13 1.56
innodb select_big_str 1.00 +13.14% 0.15
0.00 2.00 1.15 0.36
innodb select_cache 67.00 -12.64% -7.52
49.00 77.00 59.48 5.64
innodb select_cache2 64.00 -6.88% -4.12
49.00 75.00 59.88 6.36
innodb select_column+column 4.00 -38.28% -1.11
2.00 4.00 2.89 0.71
innodb select_diff_key 0.00 +100.00% 0.22
0.00 1.00 0.22 0.41
innodb select_distinct 4.00 +5.37% 0.23
3.00 8.00 4.23 0.54
innodb select_group 15.00 +7.64% 1.24
4.00 136.00 16.24 5.53
innodb select_group_when_MANY_tables 11.00 -17.60% -1.65
3.00 49.00 9.35 9.63
innodb select_join 1.00 -73.07% -0.42
0.00 1.00 0.58 0.49
innodb select_key 66.00 -26.22% -13.71
40.00 66.00 52.29 7.23
innodb select_key2 73.00 -23.81% -14.04
45.00 75.00 58.96 8.11
innodb select_key2_return_key 71.00 -26.14% -14.71
42.00 71.00 56.29 7.89
innodb select_key2_return_prim 71.00 -24.46% -13.95
42.00 72.00 57.05 8.05
innodb select_key_prefix 73.00 -25.43% -14.80
44.00 75.00 58.20 8.12
innodb select_key_prefix_join 5.00 -6.28% -0.30
3.00 10.00 4.70 0.66
innodb select_key_return_key 64.00 -24.72% -12.68
38.00 65.00 51.32 7.25
innodb select_many_fields 13.00 +13.42% 2.02
11.00 19.00 15.02 1.79
innodb select_range 45.00 +4.79% 2.26
39.00 76.00 47.26 3.91
innodb select_range_key2 10.00 -21.81% -1.79
6.00 11.00 8.21 1.03
innodb select_range_prefix 9.00 -15.74% -1.22
5.00 10.00 7.78 1.08
innodb select_simple 2.00 -22.63% -0.37
1.00 3.00 1.63 0.51
innodb select_simple_cache 2.00 -30.24% -0.46
1.00 3.00 1.54 0.52
innodb select_simple_join 1.00 -54.09% -0.35
0.00 3.00 0.65 0.48
innodb update_autocommit 4.00 -20.61% -0.68
2.00 16.00 3.32 1.02
innodb update_big 59.00 -16.48% -8.35
31.00 195.00 50.65 24.90
innodb update_commit 2.00 -29.37% -0.45
1.00 10.00 1.55 0.74
innodb update_of_key 22.00 +9.50% 2.31
18.00 100.00 24.31 6.28
innodb update_of_key_big 37.00 -36.49% -9.89
15.00 75.00 27.11 11.03
innodb update_of_primary_key_many_keys 1317.00 -6.66% -82.29
647.00 6065.00 1234.71 983.98
innodb update_rollback 2.00 -14.60% -0.25
1.00 31.00 1.75 1.94
innodb update_with_key 122.00 -11.54% -12.63
90.00 598.00 109.37 21.06
innodb update_with_key_prefix 43.00 -9.09% -3.58
33.00 202.00 39.42 6.86
innodb wisc_benchmark 3.00 -21.29% -0.53
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2168.1.7: Monty Taylor 2011-02-14 Fixed a solaris warning. Wow. 3 for 3.
2168.1.6: Monty Taylor 2011-02-14 Fixed an ICC warning.
2168.1.5: Monty Taylor 2011-02-14 Fixed an OSX warning.
2168.1.4: Lee Bieber 2011-02-14 [merge] Merge Monty - fix for build tweaks
2167.2.6: Monty Taylor 2011-02-14 Making debug plugin non-static made us
need to expose a symbol.
2168.1.3: Lee Bieber 2011-02-14 [merge] Merge Monty - build tweaks
2167.2.5: Monty Taylor 2011-02-14 Let's not vomit on tarball builds on
missing po mentions.
2167.2.4: Monty Taylor 2011-02-14 We don't want the debug plugin by default.
2167.2.3: Monty Taylor 2011-02-14 Fix daemonize c++ patch.
2167.2.2: Monty Taylor 2011-02-14 Made sphinx -Werror dependent on the same
thing gcc -Werror is dependent on.
2167.2.1: Monty Taylor 2011-02-14 C++-ize daemon.c. Our codebase is c++.
2168.1.2: Lee Bieber 2011-02-14 [merge] Merge Stewart - 718549: HailDB
doesn't handle LOCK_WAIT_TIMEOUT stmt rollback properly
2165.4.11: Stewart Smith 2011-02-14 fix HailDB rollback of statemnet on
DB_LOCK_WAIT_TIMEOUT
2168.1.1: Lee Bieber 2011-02-14 [merge] Merge Stewart - 718516: recent merges
broke HailDB
2165.4.10: Stewart Smith 2011-02-14 fix haildb type_datetime test for
changed error for invalid date and changed precision
2165.4.9: Stewart Smith 2011-02-14 fix haildb type_date test for no
implicit cartesian join and changed error for invalid date
2165.4.8: Stewart Smith 2011-02-14 fix haildb type_blob test for no
implicit cartesian join
2165.4.7: Stewart Smith 2011-02-14 fix haildb truncat test for updated
table not found error message
2165.4.6: Stewart Smith 2011-02-14 fix haildb rename test for updated table
not found error message
2165.4.5: Stewart Smith 2011-02-14 fix haildb index_res_read_check test for
no transactional DDL test
2165.4.4: Stewart Smith 2011-02-14 update haildb.conf_lru_old_blocks_pct
test result for current error message
2165.4.3: Stewart Smith 2011-02-14 update HailDB basic_create_with_index
test result for SHOW CREATE TABLE update that prints UNIQUE constraints
2165.4.2: Stewart Smith 2011-02-14 update haildb alter_table test for
current Unknown Table error message
2165.4.1: Stewart Smith 2011-02-14 fix drizzled::session::TableMessages to
be DRIZZLED_API as we need it for HailDB. Previous to this commit, HailDB
plugin would not load due to not found symbol
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
