=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 900
RUN DATE: 2011-02-16T07:32:38.517275
SERVER: drizzled
VERSION: staging
REVISION: 2173
COMMENT: 2173: Lee Bieber 2011-02-16 [merge] Merge Stewart - remove unused
macros
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 34.00 -4.29% -1.40
31.00 34.00 32.60 1.20
innodb alter_table_drop 23.00 +1.71% 0.40
23.00 24.00 23.40 0.49
innodb connect 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
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 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb count 14.00 +7.89% 1.20
13.00 18.00 15.20 1.94
innodb count_distinct 6.00 +9.09% 0.60
6.00 7.00 6.60 0.49
innodb count_distinct_2 15.00 -8.70% -1.20
12.00 15.00 13.80 1.17
innodb count_distinct_big 20.00 +6.54% 1.40
20.00 24.00 21.40 1.36
innodb count_distinct_group 15.00 -5.63% -0.80
12.00 15.00 14.20 1.17
innodb count_distinct_group_on_key 11.00 -10.00% -1.00
9.00 11.00 10.00 0.89
innodb count_distinct_group_on_key_parts 14.00 -2.94% -0.40
11.00 15.00 13.60 1.36
innodb count_distinct_key_prefix 6.00 -0.00% 0.00
5.00 7.00 6.00 0.63
innodb count_group_on_key_parts 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_on_key 94.00 -1.29% -1.20
92.00 94.00 92.80 0.75
innodb create+drop 32.00 -0.63% -0.20
31.00 32.00 31.80 0.40
innodb create_index 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb create_key+drop 31.00 -1.97% -0.60
29.00 32.00 30.40 1.02
innodb create_MANY_tables 21.00 -0.96% -0.20
20.00 21.00 20.80 0.40
innodb create_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 650.00 +0.73% 4.80
624.00 716.00 654.80 31.99
innodb delete_autocommit 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb delete_big 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 649.00 +0.76% 5.00
623.00 715.00 654.00 31.87
innodb delete_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 8.00 +11.11% 1.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 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb drop_table_when_MANY_tables 16.00 +1.23% 0.20
16.00 17.00 16.20 0.40
innodb insert 115.00 -0.35% -0.40
114.00 115.00 114.60 0.49
innodb insert_autocommit 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb insert_commit 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
innodb insert_duplicates 19.00 -0.00% 0.00
19.00 19.00 19.00 0.00
innodb insert_key 276.00 +1.29% 3.60
274.00 297.00 279.60 8.73
innodb insert_many_fields 6.00 -3.45% -0.20
5.00 6.00 5.80 0.40
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb insert_select_2_keys 5.00 +16.67% 1.00
5.00 7.00 6.00 0.63
innodb min_max 7.00 +10.26% 0.80
7.00 9.00 7.80 0.98
innodb min_max_on_key 24.00 +3.23% 0.80
24.00 26.00 24.80 0.75
innodb multiple_value_insert 6.00 +6.25% 0.40
6.00 7.00 6.40 0.49
innodb once_prepared_select 30.00 -2.04% -0.60
29.00 30.00 29.40 0.49
innodb order_by_big 16.00 -3.90% -0.60
13.00 16.00 15.40 1.20
innodb order_by_big_key 16.00 -9.59% -1.40
12.00 16.00 14.60 1.50
innodb order_by_big_key2 12.00 +4.76% 0.60
12.00 14.00 12.60 0.80
innodb order_by_big_key_desc 16.00 -6.67% -1.00
14.00 16.00 15.00 0.89
innodb order_by_big_key_diff 12.00 +3.23% 0.40
12.00 13.00 12.40 0.49
innodb order_by_big_key_prefix 12.00 +7.69% 1.00
12.00 14.00 13.00 0.89
innodb order_by_key2_diff 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb order_by_key_prefix 1.00 -25.00% -0.20
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 23.00 -0.88% -0.20
19.00 26.00 22.80 2.32
innodb outer_join_found 22.00 -0.92% -0.20
18.00 25.00 21.80 2.32
innodb outer_join_not_found 20.00 -0.00% 0.00
18.00 22.00 20.00 1.41
innodb outer_join_on_key 16.00 -5.26% -0.80
13.00 17.00 15.20 1.47
innodb prepared_select 38.00 -1.06% -0.40
37.00 38.00 37.60 0.49
innodb select_1_row 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb select_1_row_cache 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_2_rows 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb select_big 14.00 -9.38% -1.20
12.00 14.00 12.80 0.75
innodb select_big_str 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb select_cache 62.00 +5.78% 3.80
62.00 70.00 65.80 3.25
innodb select_cache2 60.00 +4.76% 3.00
60.00 69.00 63.00 3.35
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.20
0.00 1.00 0.20 0.40
innodb select_distinct 5.00 -13.64% -0.60
4.00 5.00 4.40 0.49
innodb select_group 18.00 -7.14% -1.20
15.00 18.00 16.80 1.47
innodb select_group_when_MANY_tables 11.00 +3.51% 0.40
11.00 13.00 11.40 0.80
innodb select_join 0.00 +100.00% 0.40
0.00 1.00 0.40 0.49
innodb select_key 65.00 -0.62% -0.40
64.00 66.00 64.60 0.80
innodb select_key2 72.00 -0.00% 0.00
71.00 73.00 72.00 0.63
innodb select_key2_return_key 71.00 -2.31% -1.60
68.00 71.00 69.40 1.36
innodb select_key2_return_prim 71.00 -1.14% -0.80
69.00 71.00 70.20 0.75
innodb select_key_prefix 72.00 -0.56% -0.40
71.00 73.00 71.60 0.80
innodb select_key_prefix_join 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb select_key_return_key 65.00 -2.20% -1.40
62.00 65.00 63.60 1.02
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 44.00 -5.26% -2.20
39.00 45.00 41.80 2.32
innodb select_range_key2 10.00 -4.17% -0.40
9.00 10.00 9.60 0.49
innodb select_range_prefix 9.00 +4.26% 0.40
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 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb update_autocommit 3.00 +21.05% 0.80
3.00 4.00 3.80 0.40
innodb update_big 58.00 +1.02% 0.60
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 23.00 -0.88% -0.20
22.00 24.00 22.80 0.75
innodb update_of_key_big 31.00 +12.92% 4.60
31.00 38.00 35.60 2.50
innodb update_of_primary_key_many_keys 1344.00 +0.13% 1.80
1297.00 1457.00 1345.80 57.60
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 125.00 -1.96% -2.40
122.00 125.00 122.60 1.20
innodb update_with_key_prefix 44.00 +0.45% 0.20
43.00 48.00 44.20 1.94
innodb wisc_benchmark 2.00 +28.57% 0.80
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 34.00 -4.78% -1.55
31.00 34.00 32.45 0.80
innodb alter_table_drop 23.00 +3.56% 0.85
23.00 25.00 23.85 0.73
innodb connect 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
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 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb count 14.00 +7.59% 1.15
13.00 18.00 15.15 1.85
innodb count_distinct 6.00 +10.45% 0.70
6.00 8.00 6.70 0.64
innodb count_distinct_2 15.00 -8.30% -1.15
12.00 16.00 13.85 1.11
innodb count_distinct_big 20.00 +10.51% 2.35
20.00 25.00 22.35 1.62
innodb count_distinct_group 15.00 -3.81% -0.55
11.00 16.00 14.45 1.20
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 14.00 -4.87% -0.65
11.00 15.00 13.35 1.06
innodb count_distinct_key_prefix 6.00 -11.11% -0.60
4.00 7.00 5.40 0.73
innodb count_group_on_key_parts 11.00 -0.00% 0.00
10.00 12.00 11.00 0.32
innodb count_on_key 94.00 -0.48% -0.45
91.00 97.00 93.55 1.69
innodb create+drop 32.00 -0.16% -0.05
30.00 34.00 31.95 1.07
innodb create_index 3.00 +3.23% 0.10
2.00 4.00 3.10 0.44
innodb create_key+drop 31.00 -5.26% -1.55
28.00 32.00 29.45 0.97
innodb create_MANY_tables 21.00 -2.69% -0.55
19.00 21.00 20.45 0.67
innodb create_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 650.00 +2.17% 14.45
583.00 738.00 664.45 41.62
innodb delete_autocommit 4.00 -12.68% -0.45
3.00 4.00 3.55 0.50
innodb delete_big 0.00 +100.00% 0.40
0.00 1.00 0.40 0.49
innodb delete_big_many_keys 649.00 +2.19% 14.50
582.00 737.00 663.50 41.64
innodb delete_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb delete_key 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb delete_range 8.00 +6.98% 0.60
7.00 10.00 8.60 0.73
innodb delete_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb drop_index 3.00 +7.69% 0.25
3.00 4.00 3.25 0.43
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.57% -0.65
112.00 116.00 114.35 0.96
innodb insert_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb insert_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb insert_duplicates 19.00 +0.26% 0.05
18.00 20.00 19.05 0.50
innodb insert_key 276.00 +2.66% 7.55
266.00 302.00 283.55 11.60
innodb insert_many_fields 6.00 -4.35% -0.25
5.00 6.00 5.75 0.43
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -3.90% -0.15
3.00 5.00 3.85 0.57
innodb insert_select_2_keys 5.00 +20.63% 1.30
4.00 8.00 6.30 0.90
innodb min_max 7.00 +9.09% 0.70
6.00 9.00 7.70 0.95
innodb min_max_on_key 24.00 +1.84% 0.45
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.73
innodb once_prepared_select 30.00 -2.39% -0.70
29.00 30.00 29.30 0.46
innodb order_by_big 16.00 -9.59% -1.40
13.00 16.00 14.60 1.20
innodb order_by_big_key 16.00 -9.59% -1.40
12.00 17.00 14.60 1.28
innodb order_by_big_key2 12.00 +6.98% 0.90
12.00 14.00 12.90 0.70
innodb order_by_big_key_desc 16.00 -4.92% -0.75
14.00 16.00 15.25 0.70
innodb order_by_big_key_diff 12.00 +6.98% 0.90
12.00 14.00 12.90 0.77
innodb order_by_big_key_prefix 12.00 +10.45% 1.40
12.00 14.00 13.40 0.73
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb order_by_key_prefix 1.00 -17.65% -0.15
0.00 1.00 0.85 0.36
innodb order_by_range 1.00 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 23.00 -3.60% -0.80
17.00 26.00 22.20 3.06
innodb outer_join_found 22.00 -3.04% -0.65
16.00 25.00 21.35 3.00
innodb outer_join_not_found 20.00 -5.54% -1.05
14.00 22.00 18.95 2.78
innodb outer_join_on_key 16.00 -8.84% -1.30
11.00 18.00 14.70 2.22
innodb prepared_select 38.00 -2.15% -0.80
37.00 38.00 37.20 0.40
innodb select_1_row 3.00 +13.04% 0.45
3.00 4.00 3.45 0.50
innodb select_1_row_cache 4.00 -12.68% -0.45
3.00 4.00 3.55 0.50
innodb select_2_rows 3.00 +14.29% 0.50
3.00 4.00 3.50 0.50
innodb select_big 14.00 -7.69% -1.00
12.00 15.00 13.00 0.89
innodb select_big_str 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb select_cache 62.00 +2.59% 1.65
57.00 71.00 63.65 3.57
innodb select_cache2 60.00 +4.69% 2.95
60.00 69.00 62.95 2.44
innodb select_column+column 4.00 -3.90% -0.15
3.00 4.00 3.85 0.36
innodb select_diff_key 0.00 +100.00% 0.30
0.00 1.00 0.30 0.46
innodb select_distinct 5.00 -8.70% -0.40
4.00 5.00 4.60 0.49
innodb select_group 18.00 -4.65% -0.80
15.00 19.00 17.20 1.47
innodb select_group_when_MANY_tables 11.00 +9.47% 1.15
11.00 14.00 12.15 0.91
innodb select_join 0.00 +100.00% 0.60
0.00 1.00 0.60 0.49
innodb select_key 65.00 -1.96% -1.25
63.00 66.00 63.75 0.77
innodb select_key2 72.00 -1.12% -0.80
70.00 73.00 71.20 1.03
innodb select_key2_return_key 71.00 -3.42% -2.35
67.00 71.00 68.65 1.01
innodb select_key2_return_prim 71.00 -2.23% -1.55
68.00 71.00 69.45 0.92
innodb select_key_prefix 72.00 -1.62% -1.15
69.00 73.00 70.85 0.85
innodb select_key_prefix_join 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb select_key_return_key 65.00 -3.01% -1.90
62.00 65.00 63.10 0.77
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 44.00 -4.27% -1.80
39.00 49.00 42.20 2.48
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.70% 0.25
8.00 10.00 9.25 0.62
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 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb update_autocommit 3.00 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb update_big 58.00 +2.27% 1.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 23.00 -3.14% -0.70
21.00 24.00 22.30 1.05
innodb update_of_key_big 31.00 +12.55% 4.45
29.00 47.00 35.45 3.83
innodb update_of_primary_key_many_keys 1344.00 +1.39% 19.00
1218.00 1472.00 1363.00 70.01
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 125.00 -2.08% -2.55
117.00 127.00 122.45 2.60
innodb update_with_key_prefix 44.00 -0.23% -0.10
40.00 50.00 43.90 2.32
innodb wisc_benchmark 2.00 +24.53% 0.65
2.00 3.00 2.65 0.48
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 34.00 -64.75% -13.36
11.00 61.00 20.64 10.02
innodb alter_table_drop 23.00 -26.39% -4.80
10.00 57.00 18.20 7.00
innodb connect 2.00 +3.76% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -11.38% -0.31
2.00 5.00 2.69 0.48
innodb connect+select_simple 3.00 -28.46% -0.66
1.00 3.00 2.34 0.48
innodb count 14.00 +11.11% 1.75
12.00 193.00 15.75 8.97
innodb count_distinct 6.00 +8.58% 0.56
5.00 50.00 6.56 2.31
innodb count_distinct_2 15.00 -13.97% -1.84
11.00 63.00 13.16 2.99
innodb count_distinct_big 20.00 +8.70% 1.90
5.00 67.00 21.90 3.05
innodb count_distinct_group 15.00 -14.47% -1.90
10.00 68.00 13.10 3.13
innodb count_distinct_group_on_key 11.00 -16.05% -1.52
7.00 69.00 9.48 3.06
innodb count_distinct_group_on_key_parts 14.00 -13.95% -1.71
9.00 72.00 12.29 3.19
innodb count_distinct_key_prefix 6.00 -17.12% -0.88
3.00 52.00 5.12 2.42
innodb count_group_on_key_parts 11.00 -10.61% -1.06
7.00 72.00 9.94 3.20
innodb count_on_key 94.00 -9.69% -8.30
68.00 107.00 85.70 7.31
innodb create+drop 32.00 +1.26% 0.41
18.00 75.00 32.41 12.09
innodb create_index 3.00 -4.39% -0.13
1.00 8.00 2.87 1.15
innodb create_key+drop 31.00 -10.39% -2.92
21.00 50.00 28.08 4.95
innodb create_MANY_tables 21.00 +39.17% 13.52
14.00 121.00 34.52 17.21
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.37
innodb delete_all_many_keys 650.00 -42.13% -192.66
212.00 1888.00 457.34 369.48
innodb delete_autocommit 4.00 -16.47% -0.57
2.00 14.00 3.43 0.75
innodb delete_big 0.00 +100.00% 0.28
0.00 3.00 0.28 0.46
innodb delete_big_many_keys 649.00 -39.95% -185.28
212.00 2293.00 463.72 384.13
innodb delete_commit 2.00 -33.28% -0.50
1.00 5.00 1.50 0.53
innodb delete_key 3.00 +2.24% 0.07
2.00 35.00 3.07 1.52
innodb delete_range 8.00 +3.46% 0.29
5.00 23.00 8.29 3.29
innodb delete_rollback 2.00 -15.98% -0.28
1.00 12.00 1.72 0.93
innodb drop_index 3.00 -1.71% -0.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.39% 3.60
11.00 90.00 19.60 7.65
innodb insert 115.00 -8.03% -8.55
3.00 343.00 106.45 14.78
innodb insert_autocommit 3.00 -0.28% -0.01
2.00 99.00 2.99 3.37
innodb insert_commit 2.00 -47.08% -0.64
1.00 3.00 1.36 0.49
innodb insert_duplicates 19.00 -23.95% -3.67
11.00 21.00 15.33 2.60
innodb insert_key 276.00 +9.21% 28.01
142.00 700.00 304.01 109.02
innodb insert_many_fields 6.00 -7.22% -0.40
3.00 17.00 5.60 1.80
innodb insert_rollback 2.00 -21.05% -0.35
1.00 3.00 1.65 0.53
innodb insert_select_1_key 4.00 -5.87% -0.22
2.00 10.00 3.78 0.90
innodb insert_select_2_keys 5.00 +17.61% 1.07
4.00 16.00 6.07 2.12
innodb min_max 7.00 +10.51% 0.82
6.00 110.00 7.82 4.62
innodb min_max_on_key 24.00 -17.68% -3.61
14.00 37.00 20.39 3.04
innodb multiple_value_insert 6.00 -10.72% -0.58
2.00 50.00 5.42 4.35
innodb once_prepared_select 30.00 -24.87% -5.97
18.00 32.00 24.03 3.50
innodb order_by_big 16.00 -11.84% -1.69
12.00 31.00 14.31 1.54
innodb order_by_big_key 16.00 -20.90% -2.77
11.00 32.00 13.23 1.64
innodb order_by_big_key2 12.00 +1.31% 0.16
10.00 33.00 12.16 1.55
innodb order_by_big_key_desc 16.00 -19.03% -2.56
11.00 32.00 13.44 1.67
innodb order_by_big_key_diff 12.00 +1.59% 0.19
10.00 31.00 12.19 1.51
innodb order_by_big_key_prefix 12.00 +2.98% 0.37
10.00 32.00 12.37 1.58
innodb order_by_key2_diff 2.00 -43.10% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -26.91% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -20.82% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 23.00 -19.48% -3.75
15.00 61.00 19.25 3.73
innodb outer_join_found 22.00 -17.76% -3.32
14.00 58.00 18.68 3.59
innodb outer_join_not_found 20.00 -22.20% -3.63
12.00 46.00 16.37 3.17
innodb outer_join_on_key 16.00 -24.58% -3.16
10.00 59.00 12.84 2.79
innodb prepared_select 38.00 -22.20% -6.90
22.00 40.00 31.10 4.44
innodb select_1_row 3.00 -6.08% -0.17
2.00 4.00 2.83 0.69
innodb select_1_row_cache 4.00 -51.07% -1.35
2.00 4.00 2.65 0.67
innodb select_2_rows 3.00 -5.36% -0.15
2.00 4.00 2.85 0.69
innodb select_big 14.00 -15.37% -1.87
0.00 31.00 12.13 1.56
innodb select_big_str 1.00 +13.19% 0.15
0.00 2.00 1.15 0.36
innodb select_cache 62.00 -4.21% -2.50
49.00 77.00 59.50 5.64
innodb select_cache2 60.00 -0.18% -0.11
49.00 75.00 59.89 6.35
innodb select_column+column 4.00 -38.09% -1.10
2.00 4.00 2.90 0.71
innodb select_diff_key 0.00 +100.00% 0.22
0.00 1.00 0.22 0.41
innodb select_distinct 5.00 -18.28% -0.77
3.00 8.00 4.23 0.54
innodb select_group 18.00 -10.81% -1.76
4.00 136.00 16.24 5.52
innodb select_group_when_MANY_tables 11.00 -17.50% -1.64
3.00 49.00 9.36 9.61
innodb select_join 0.00 +100.00% 0.58
0.00 1.00 0.58 0.49
innodb select_key 65.00 -24.21% -12.67
40.00 66.00 52.33 7.26
innodb select_key2 72.00 -22.02% -12.99
45.00 75.00 59.01 8.14
innodb select_key2_return_key 71.00 -26.03% -14.67
42.00 71.00 56.33 7.92
innodb select_key2_return_prim 71.00 -24.36% -13.91
42.00 72.00 57.09 8.07
innodb select_key_prefix 72.00 -23.61% -13.75
44.00 75.00 58.25 8.14
innodb select_key_prefix_join 5.00 -6.23% -0.29
3.00 10.00 4.71 0.66
innodb select_key_return_key 65.00 -26.55% -13.64
38.00 65.00 51.36 7.27
innodb select_many_fields 13.00 +13.38% 2.01
11.00 19.00 15.01 1.79
innodb select_range 44.00 +6.86% 3.24
39.00 76.00 47.24 3.92
innodb select_range_key2 10.00 -21.75% -1.79
6.00 11.00 8.21 1.03
innodb select_range_prefix 9.00 -15.63% -1.22
5.00 10.00 7.78 1.09
innodb select_simple 2.00 -22.53% -0.37
1.00 3.00 1.63 0.51
innodb select_simple_cache 2.00 -30.10% -0.46
1.00 3.00 1.54 0.52
innodb select_simple_join 1.00 -53.79% -0.35
0.00 3.00 0.65 0.48
innodb update_autocommit 3.00 +9.58% 0.32
2.00 16.00 3.32 1.02
innodb update_big 58.00 -14.44% -7.32
31.00 195.00 50.68 24.86
innodb update_commit 2.00 -29.24% -0.45
1.00 10.00 1.55 0.74
innodb update_of_key 23.00 +5.36% 1.30
18.00 100.00 24.30 6.27
innodb update_of_key_big 31.00 -14.24% -3.87
15.00 75.00 27.13 11.02
innodb update_of_primary_key_many_keys 1344.00 -8.79% -108.65
647.00 6065.00 1235.35 981.71
innodb update_rollback 2.00 -14.54% -0.25
1.00 31.00 1.75 1.93
innodb update_with_key 125.00 -14.23% -15.58
90.00 598.00 109.42 21.04
innodb update_with_key_prefix 44.00 -11.57% -4.56
33.00 202.00 39.44 6.86
innodb wisc_benchmark 2.00 +19.16% 0.47
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2172.1.5: Lee Bieber 2011-02-15 [merge] Merge Stewart - remove unused macros
2168.2.35: Stewart Smith 2011-02-16 remove unused ulong_to_double macro
2168.2.34: Stewart Smith 2011-02-16 remove unused HA_CREATE_USED_ROW_FORMAT
- this is now part of the generic create table options infrastructure
2168.2.33: Stewart Smith 2011-02-16 remove unused LOG_PREFIX define
2168.2.32: Stewart Smith 2011-02-16 move PTR_BYTE_DIFF to drizzletest.cc as
it's the only place that still uses it
2168.2.31: Stewart Smith 2011-02-16 remove unused OFFSET macro.
2168.2.30: Stewart Smith 2011-02-16 remove unused ALIGN_PTR
2168.2.29: Stewart Smith 2011-02-16 remove unused MAX_DBKEY_LENGTH
2168.2.28: Stewart Smith 2011-02-16 remove unused MAX_ALIAS_NAME
2168.2.27: Stewart Smith 2011-02-16 remove unused FN_EXTLEN
2168.2.26: Stewart Smith 2011-02-16 remove unused
MAX_DATETIME_COMPRESSED_WIDTH
2168.2.25: Stewart Smith 2011-02-16 remove unused MAX_HOSTNAME define -
from old (mysql) permissions system
2168.2.24: Stewart Smith 2011-02-16 remove unused HA_LOCK_IN_SHARE_MODE and
HA_LOCK_IN_EXCLUSIVE_MODE
2168.2.23: Stewart Smith 2011-02-16 remove unused and very out of date
MAX_HA. We don't have such limits in Drizzle
2168.2.22: Stewart Smith 2011-02-16 move DEFAULT_CONCURRENCY define out of
definitions.h and into ARCHIVE's concurrency_test.cc - the only place that it's
used
2168.2.21: Stewart Smith 2011-02-16 remove unused FLUSH_TIME
2168.2.20: Stewart Smith 2011-02-16 remove unused PRECISION_FOR_DOUBLE and
PRECISION_FOR_FLOAT defines
2168.2.19: Stewart Smith 2011-02-16 remove unused USER_VARS_HASH_SIZE
2168.2.18: Stewart Smith 2011-02-16 remove unused NRERRBUFFS define from
error.h
2168.2.17: Stewart Smith 2011-02-16 actually use some of the constants in
temporal.h for MAX minutes/seconds et al (including leap seconds) in temporal.cc
2168.2.16: Stewart Smith 2011-02-16 remove a couple of unused STATUS_ flags
for form->status
2168.2.15: Stewart Smith 2011-02-16 remove unused TIME_MAX_VALUE_SECONDS
2168.2.14: Stewart Smith 2011-02-16 remove unused DECIMAL_MAX_FIELD_SIZE
2168.2.13: Stewart Smith 2011-02-16 remove unused DECIMAL_LONG_DIGITS and
DECIMAL_LONG3_DIGITS
2168.2.12: Stewart Smith 2011-02-16 [merge] merge trunk
2168.2.11: Stewart Smith 2011-02-15 remove unused my_tz_init
2168.2.10: Stewart Smith 2011-02-15 remove traces of system_time_zone
2168.2.9: Stewart Smith 2011-02-15 remove unused sys_var_session_time_zone
2168.2.8: Stewart Smith 2011-02-15 remove unused my_tz_find()
2168.2.7: Stewart Smith 2011-02-15 remove completely unused
drizzled/tzfile.h
2168.2.6: Stewart Smith 2011-02-15 remove unused get_chunk_count() macro
from memory/heap_priv.h
2168.2.5: Stewart Smith 2011-02-15 remove unused CHUNK_STATUS_LINKED define
from memory/heap_priv.h
2168.2.4: Stewart Smith 2011-02-15 remove unused
SWITCH_TO_NEXT_CHUNK_FOR_READ() macro from memory plugin
2168.2.3: Stewart Smith 2011-02-15 remove unused
CLIENT_NET_(READ|WRITE)_TIMEOUT from mysql_Protocol plugin
2168.2.2: Stewart Smith 2011-02-15 remove unused GREGORIAN_START defines
2168.2.1: Stewart Smith 2011-02-15 use DRIZZLE_MAX_MONTHS instead of 12 in
temporal code
2172.1.4: Lee Bieber 2011-02-15 [merge] Merge Olaf - remove old style casts
2160.1.8: Olaf van der Spek 2011-02-16 casts
2172.1.3: Lee Bieber 2011-02-15 [merge] Merge Stewart remove unused macros
in drizzledump
2170.2.1: Stewart Smith 2011-02-16 remove unused #defines from drizzledump
2172.1.2: Lee Bieber 2011-02-15 [merge] Merge Andrew - 718657: Several errors
in Date/Time docs
2165.2.6: Andrew Hutchings 2011-02-15 Missed something on temporal docs,
now fixed
2165.2.5: Andrew Hutchings 2011-02-15 Make fixes to temporal docs
2172.1.1: Lee Bieber 2011-02-15 [merge] Merge Olaf - Move strfunc functions
into TYPELIB class
2151.5.11: Olaf van der Spek 2011-02-15 [merge] merge trunk
2151.5.10: Olaf van der Spek 2011-02-14 [merge] merge trunk
2151.5.9: Olaf van der Spek 2011-02-13 [merge] merge trunk
2151.5.8: Olaf van der Spek 2011-02-12 [merge] merge from trunk
2151.5.7: Olaf van der Spek 2011-02-11 [merge] merge from trunk
2151.5.6: Olaf van der Spek 2011-02-10 [merge] merge from trunk
2151.5.5: Olaf van der Spek 2011-02-09 char* -> const char*
2151.5.4: Olaf van der Spek 2011-02-09 Move strfunc functions into TYPELIB
class
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
