=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 962
RUN DATE: 2011-03-17T22:31:28.351869
SERVER: drizzled
VERSION: staging
REVISION: 2242
COMMENT: 2242: Lee Bieber 2011-03-18 [merge] Merge Stewart - refactoring of
default values
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 31.00 +3.13% 1.00
31.00 33.00 32.00 0.89
innodb alter_table_drop 23.00 +2.54% 0.60
23.00 24.00 23.60 0.49
innodb connect 3.00 -25.00% -0.60
2.00 3.00 2.40 0.49
innodb connect+select_1_row 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb connect+select_simple 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
innodb count 17.00 -11.84% -1.80
13.00 18.00 15.20 1.94
innodb count_distinct 6.00 +11.76% 0.80
6.00 7.00 6.80 0.40
innodb count_distinct_2 13.00 +2.99% 0.40
13.00 15.00 13.40 0.80
innodb count_distinct_big 22.00 -0.92% -0.20
21.00 24.00 21.80 1.17
innodb count_distinct_group 15.00 +2.60% 0.40
15.00 16.00 15.40 0.49
innodb count_distinct_group_on_key 10.00 -0.00% 0.00
9.00 11.00 10.00 0.63
innodb count_distinct_group_on_key_parts 14.00 -0.00% 0.00
13.00 15.00 14.00 0.63
innodb count_distinct_key_prefix 4.00 +23.08% 1.20
4.00 6.00 5.20 0.75
innodb count_group_on_key_parts 11.00 +3.51% 0.40
11.00 12.00 11.40 0.49
innodb count_on_key 94.00 -0.00% 0.00
91.00 97.00 94.00 1.90
innodb create+drop 33.00 +1.20% 0.40
33.00 34.00 33.40 0.49
innodb create_index 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb create_key+drop 31.00 +2.52% 0.80
30.00 34.00 31.80 1.47
innodb create_MANY_tables 21.00 -1.94% -0.40
20.00 21.00 20.60 0.49
innodb delete_all_many_keys 641.00 -0.38% -2.40
619.00 658.00 638.60 12.72
innodb delete_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb delete_big 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 640.00 -0.34% -2.20
619.00 657.00 637.80 12.42
innodb delete_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb delete_key 2.00 +33.33% 1.00
2.00 4.00 3.00 0.63
innodb delete_range 8.00 +2.44% 0.20
8.00 9.00 8.20 0.40
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 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb insert 114.00 -0.35% -0.40
112.00 114.00 113.60 0.80
innodb insert_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
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 279.00 -1.53% -4.20
272.00 279.00 274.80 2.79
innodb insert_many_fields 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 +4.76% 0.20
3.00 5.00 4.20 0.75
innodb insert_select_2_keys 8.00 -21.21% -1.40
5.00 8.00 6.60 1.02
innodb min_max 9.00 -15.38% -1.20
7.00 9.00 7.80 0.98
innodb min_max_on_key 24.00 +2.44% 0.60
24.00 25.00 24.60 0.49
innodb multiple_value_insert 7.00 -6.06% -0.40
6.00 7.00 6.60 0.49
innodb once_prepared_select 29.00 +2.03% 0.60
29.00 31.00 29.60 0.80
innodb order_by_big 13.00 +7.14% 1.00
13.00 16.00 14.00 1.26
innodb order_by_big_key 12.00 +11.76% 1.60
12.00 16.00 13.60 1.62
innodb order_by_big_key2 12.00 +1.64% 0.20
11.00 13.00 12.20 0.75
innodb order_by_big_key_desc 14.00 +5.41% 0.80
14.00 16.00 14.80 0.98
innodb order_by_big_key_diff 13.00 -0.00% 0.00
12.00 14.00 13.00 0.63
innodb order_by_big_key_prefix 12.00 +6.25% 0.80
12.00 14.00 12.80 0.98
innodb order_by_key2_diff 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
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 18.00 +10.89% 2.20
18.00 24.00 20.20 2.40
innodb outer_join_found 18.00 +6.25% 1.20
17.00 23.00 19.20 2.40
innodb outer_join_not_found 16.00 +11.11% 2.00
16.00 21.00 18.00 2.10
innodb outer_join_on_key 12.00 +11.76% 1.60
12.00 16.00 13.60 1.62
innodb prepared_select 37.00 +1.07% 0.40
37.00 39.00 37.40 0.80
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 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_big 14.00 -9.38% -1.20
11.00 14.00 12.80 1.17
innodb select_big_str 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb select_cache 62.00 +1.27% 0.80
59.00 69.00 62.80 3.54
innodb select_cache2 61.00 +4.39% 2.80
58.00 71.00 63.80 4.35
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 +13.04% 0.60
4.00 5.00 4.60 0.49
innodb select_group 16.00 +3.61% 0.60
15.00 19.00 16.60 1.36
innodb select_group_when_MANY_tables 12.00 -1.69% -0.20
11.00 12.00 11.80 0.40
innodb select_join 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_key 64.00 -0.00% 0.00
64.00 64.00 64.00 0.00
innodb select_key2 70.00 +1.69% 1.20
70.00 72.00 71.20 0.75
innodb select_key2_return_key 67.00 +1.47% 1.00
67.00 69.00 68.00 0.63
innodb select_key2_return_prim 69.00 +0.29% 0.20
69.00 70.00 69.20 0.40
innodb select_key_prefix 69.00 +2.27% 1.60
69.00 72.00 70.60 1.02
innodb select_key_prefix_join 6.00 -15.38% -0.80
5.00 6.00 5.20 0.40
innodb select_key_return_key 61.00 +2.56% 1.60
61.00 64.00 62.60 1.02
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 41.00 +4.65% 2.00
40.00 45.00 43.00 2.10
innodb select_range_key2 9.00 +4.26% 0.40
9.00 10.00 9.40 0.49
innodb select_range_prefix 9.00 +2.17% 0.20
9.00 10.00 9.20 0.40
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 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb update_big 60.00 -2.74% -1.60
57.00 60.00 58.40 1.02
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
22.00 24.00 22.80 0.75
innodb update_of_key_big 37.00 +6.09% 2.40
31.00 46.00 39.40 5.82
innodb update_of_primary_key_many_keys 1332.00 -1.26% -16.60
1294.00 1332.00 1315.40 14.39
innodb update_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb update_with_key 120.00 +0.66% 0.80
119.00 124.00 120.80 1.72
innodb update_with_key_prefix 44.00 +1.35% 0.60
42.00 47.00 44.60 1.62
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 31.00 +4.47% 1.45
25.00 35.00 32.45 2.56
innodb alter_table_drop 23.00 +2.34% 0.55
22.00 25.00 23.55 0.86
innodb connect 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
innodb connect+select_1_row 3.00 -1.69% -0.05
2.00 3.00 2.95 0.22
innodb connect+select_simple 2.00 +25.93% 0.70
2.00 3.00 2.70 0.46
innodb count 17.00 -6.58% -1.05
13.00 18.00 15.95 1.72
innodb count_distinct 6.00 +9.09% 0.60
5.00 8.00 6.60 0.80
innodb count_distinct_2 13.00 +5.45% 0.75
12.00 16.00 13.75 1.09
innodb count_distinct_big 22.00 +3.93% 0.90
20.00 25.00 22.90 1.89
innodb count_distinct_group 15.00 -2.74% -0.40
11.00 16.00 14.60 1.07
innodb count_distinct_group_on_key 10.00 -6.38% -0.60
8.00 11.00 9.40 1.02
innodb count_distinct_group_on_key_parts 14.00 -4.87% -0.65
11.00 15.00 13.35 1.11
innodb count_distinct_key_prefix 4.00 +25.93% 1.40
4.00 6.00 5.40 0.66
innodb count_group_on_key_parts 11.00 -0.46% -0.05
10.00 12.00 10.95 0.59
innodb count_on_key 94.00 -0.53% -0.50
91.00 97.00 93.50 1.83
innodb create+drop 33.00 +0.75% 0.25
32.00 35.00 33.25 0.77
innodb create_index 3.00 +4.76% 0.15
3.00 4.00 3.15 0.36
innodb create_key+drop 31.00 +1.59% 0.50
30.00 34.00 31.50 1.02
innodb create_MANY_tables 21.00 -1.69% -0.35
19.00 22.00 20.65 0.79
innodb delete_all_many_keys 641.00 -0.36% -2.30
608.00 692.00 638.70 21.05
innodb delete_autocommit 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb delete_big 1.00 -233.33% -0.70
0.00 1.00 0.30 0.46
innodb delete_big_many_keys 640.00 -0.32% -2.05
608.00 691.00 637.95 20.94
innodb delete_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb delete_key 2.00 +27.27% 0.75
2.00 4.00 2.75 0.54
innodb delete_range 8.00 +6.43% 0.55
7.00 10.00 8.55 0.74
innodb delete_rollback 2.00 +11.11% 0.25
2.00 3.00 2.25 0.43
innodb drop_index 3.00 -0.00% 0.00
2.00 4.00 3.00 0.55
innodb drop_table_when_MANY_tables 18.00 +2.44% 0.45
17.00 20.00 18.45 0.80
innodb insert 114.00 -0.35% -0.40
111.00 116.00 113.60 1.20
innodb insert_autocommit 3.00 +4.76% 0.15
3.00 4.00 3.15 0.36
innodb insert_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb insert_duplicates 19.00 +0.78% 0.15
18.00 20.00 19.15 0.48
innodb insert_key 279.00 -0.59% -1.65
265.00 299.00 277.35 8.08
innodb insert_many_fields 6.00 -0.84% -0.05
5.00 7.00 5.95 0.38
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -0.00% 0.00
3.00 5.00 4.00 0.55
innodb insert_select_2_keys 8.00 -30.08% -1.85
5.00 8.00 6.15 0.73
innodb min_max 9.00 -15.38% -1.20
6.00 9.00 7.80 0.98
innodb min_max_on_key 24.00 +1.84% 0.45
23.00 25.00 24.45 0.59
innodb multiple_value_insert 7.00 -7.69% -0.50
5.00 7.00 6.50 0.59
innodb once_prepared_select 29.00 -0.17% -0.05
28.00 31.00 28.95 0.67
innodb order_by_big 13.00 +6.47% 0.90
12.00 16.00 13.90 1.14
innodb order_by_big_key 12.00 +14.89% 2.10
12.00 16.00 14.10 1.51
innodb order_by_big_key2 12.00 +4.38% 0.55
11.00 14.00 12.55 0.86
innodb order_by_big_key_desc 14.00 +6.98% 1.05
13.00 17.00 15.05 1.16
innodb order_by_big_key_diff 13.00 -2.36% -0.30
11.00 14.00 12.70 0.71
innodb order_by_big_key_prefix 12.00 +6.25% 0.80
12.00 14.00 12.80 0.81
innodb order_by_key2_diff 1.00 +20.00% 0.25
1.00 2.00 1.25 0.43
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 18.00 +18.00% 3.95
18.00 26.00 21.95 2.69
innodb outer_join_found 18.00 +15.09% 3.20
17.00 26.00 21.20 2.80
innodb outer_join_not_found 16.00 +16.45% 3.15
16.00 22.00 19.15 1.98
innodb outer_join_on_key 12.00 +18.64% 2.75
12.00 18.00 14.75 1.97
innodb prepared_select 37.00 +0.27% 0.10
36.00 39.00 37.10 0.62
innodb select_1_row 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb select_1_row_cache 3.00 +14.29% 0.50
3.00 4.00 3.50 0.50
innodb select_2_rows 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb select_big 14.00 -11.55% -1.45
11.00 15.00 12.55 1.16
innodb select_big_str 1.00 +23.08% 0.30
1.00 2.00 1.30 0.46
innodb select_cache 62.00 +0.96% 0.60
57.00 69.00 62.60 3.20
innodb select_cache2 61.00 +4.91% 3.15
58.00 71.00 64.15 3.04
innodb select_column+column 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb select_diff_key 1.00 -185.71% -0.65
0.00 1.00 0.35 0.48
innodb select_distinct 4.00 +13.98% 0.65
4.00 5.00 4.65 0.48
innodb select_group 16.00 +3.61% 0.60
15.00 19.00 16.60 1.32
innodb select_group_when_MANY_tables 12.00 +1.64% 0.20
11.00 14.00 12.20 0.68
innodb select_join 0.00 +100.00% 0.45
0.00 1.00 0.45 0.50
innodb select_key 64.00 -0.16% -0.10
63.00 65.00 63.90 0.44
innodb select_key2 70.00 +1.20% 0.85
70.00 72.00 70.85 0.73
innodb select_key2_return_key 67.00 +1.90% 1.30
67.00 70.00 68.30 0.84
innodb select_key2_return_prim 69.00 +0.36% 0.25
68.00 71.00 69.25 0.70
innodb select_key_prefix 69.00 +2.34% 1.65
69.00 72.00 70.65 0.91
innodb select_key_prefix_join 6.00 -18.81% -0.95
4.00 6.00 5.05 0.38
innodb select_key_return_key 61.00 +2.87% 1.80
61.00 64.00 62.80 0.68
innodb select_many_fields 13.00 +1.89% 0.25
13.00 14.00 13.25 0.43
innodb select_range 41.00 +3.64% 1.55
38.00 47.00 42.55 2.80
innodb select_range_key2 9.00 +6.74% 0.65
9.00 10.00 9.65 0.48
innodb select_range_prefix 9.00 +1.10% 0.10
8.00 10.00 9.10 0.54
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 -17.65% -0.15
0.00 1.00 0.85 0.36
innodb update_autocommit 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb update_big 60.00 -1.78% -1.05
56.00 63.00 58.95 1.75
innodb update_commit 2.00 -5.26% -0.10
1.00 3.00 1.90 0.44
innodb update_of_key 22.00 +1.57% 0.35
21.00 25.00 22.35 1.19
innodb update_of_key_big 37.00 +0.13% 0.05
29.00 46.00 37.05 4.98
innodb update_of_primary_key_many_keys 1332.00 -0.26% -3.45
1233.00 1464.00 1328.55 48.21
innodb update_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb update_with_key 120.00 +1.19% 1.45
116.00 127.00 121.45 3.22
innodb update_with_key_prefix 44.00 +0.45% 0.20
40.00 47.00 44.20 1.96
innodb wisc_benchmark 2.00 +27.27% 0.75
2.00 3.00 2.75 0.43
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 31.00 -44.38% -9.53
11.00 61.00 21.47 10.15
innodb alter_table_drop 23.00 -23.73% -4.41
10.00 57.00 18.59 6.91
innodb connect 3.00 -43.81% -0.91
1.00 3.00 2.09 0.42
innodb connect+select_1_row 3.00 -10.73% -0.29
2.00 5.00 2.71 0.47
innodb connect+select_simple 2.00 +15.14% 0.36
1.00 3.00 2.36 0.49
innodb count 17.00 -7.94% -1.25
12.00 193.00 15.75 8.67
innodb count_distinct 6.00 +8.72% 0.57
5.00 50.00 6.57 2.24
innodb count_distinct_2 13.00 +1.60% 0.21
11.00 63.00 13.21 2.91
innodb count_distinct_big 22.00 -0.16% -0.04
5.00 67.00 21.96 2.99
innodb count_distinct_group 15.00 -13.61% -1.80
10.00 68.00 13.20 3.05
innodb count_distinct_group_on_key 10.00 -5.23% -0.50
7.00 69.00 9.50 2.97
innodb count_distinct_group_on_key_parts 14.00 -13.24% -1.64
9.00 72.00 12.36 3.11
innodb count_distinct_key_prefix 4.00 +22.08% 1.13
3.00 52.00 5.13 2.34
innodb count_group_on_key_parts 11.00 -9.83% -0.98
7.00 72.00 10.02 3.10
innodb count_on_key 94.00 -8.98% -7.75
68.00 107.00 86.25 7.37
innodb create+drop 33.00 -1.64% -0.53
18.00 75.00 32.47 11.67
innodb create_index 3.00 -3.43% -0.10
1.00 8.00 2.90 1.12
innodb create_key+drop 31.00 -9.49% -2.69
21.00 50.00 28.31 4.86
innodb create_MANY_tables 21.00 +37.44% 12.57
14.00 121.00 33.57 16.96
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.36
innodb delete_all_many_keys 641.00 -36.06% -169.90
212.00 1888.00 471.10 359.28
innodb delete_autocommit 3.00 +12.99% 0.45
2.00 14.00 3.45 0.74
innodb delete_big 1.00 -234.46% -0.70
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 640.00 -34.20% -163.09
212.00 2293.00 476.91 373.04
innodb delete_commit 2.00 -31.03% -0.47
1.00 5.00 1.53 0.53
innodb delete_key 2.00 +34.29% 1.04
2.00 35.00 3.04 1.47
innodb delete_range 8.00 +3.87% 0.32
5.00 23.00 8.32 3.18
innodb delete_rollback 2.00 -14.05% -0.25
1.00 12.00 1.75 0.90
innodb drop_index 3.00 -1.67% -0.05
1.00 9.00 2.95 1.30
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.23
innodb drop_table_when_MANY_tables 18.00 +7.87% 1.54
11.00 90.00 19.54 7.39
innodb insert 114.00 -6.59% -7.04
3.00 343.00 106.96 14.38
innodb insert_autocommit 3.00 +0.11% 0.00
2.00 99.00 3.00 3.25
innodb insert_commit 2.00 -43.11% -0.60
1.00 3.00 1.40 0.50
innodb insert_duplicates 19.00 -21.84% -3.41
11.00 21.00 15.59 2.69
innodb insert_key 279.00 +7.67% 23.19
142.00 700.00 302.19 105.02
innodb insert_many_fields 6.00 -6.83% -0.38
3.00 17.00 5.62 1.74
innodb insert_rollback 2.00 -18.99% -0.32
1.00 3.00 1.68 0.53
innodb insert_select_1_key 4.00 -5.66% -0.21
2.00 10.00 3.79 0.88
innodb insert_select_2_keys 8.00 -31.64% -1.92
4.00 16.00 6.08 2.06
innodb min_max 9.00 -15.03% -1.18
6.00 110.00 7.82 4.46
innodb min_max_on_key 24.00 -16.04% -3.32
14.00 37.00 20.68 3.12
innodb multiple_value_insert 7.00 -27.45% -1.51
2.00 50.00 5.49 4.21
innodb once_prepared_select 29.00 -18.95% -4.62
18.00 32.00 24.38 3.62
innodb order_by_big 13.00 +9.16% 1.31
12.00 31.00 14.31 1.52
innodb order_by_big_key 12.00 +9.83% 1.31
11.00 32.00 13.31 1.64
innodb order_by_big_key2 12.00 +1.80% 0.22
10.00 33.00 12.22 1.53
innodb order_by_big_key_desc 14.00 -3.30% -0.45
11.00 32.00 13.55 1.69
innodb order_by_big_key_diff 13.00 -6.11% -0.75
10.00 31.00 12.25 1.49
innodb order_by_big_key_prefix 12.00 +3.38% 0.42
10.00 32.00 12.42 1.54
innodb order_by_key2_diff 1.00 +28.30% 0.39
1.00 3.00 1.39 0.49
innodb order_by_key_prefix 1.00 -26.17% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -19.57% -0.16
0.00 2.00 0.84 0.38
innodb outer_join 18.00 +7.32% 1.42
15.00 61.00 19.42 3.72
innodb outer_join_found 18.00 +4.46% 0.84
14.00 58.00 18.84 3.57
innodb outer_join_not_found 16.00 +3.31% 0.55
12.00 46.00 16.55 3.18
innodb outer_join_on_key 12.00 +7.45% 0.97
10.00 59.00 12.97 2.77
innodb prepared_select 37.00 -17.38% -5.48
22.00 40.00 31.52 4.55
innodb select_1_row 4.00 -39.20% -1.13
2.00 4.00 2.87 0.70
innodb select_1_row_cache 3.00 -10.73% -0.29
2.00 4.00 2.71 0.70
innodb select_2_rows 4.00 -37.80% -1.10
2.00 4.00 2.90 0.71
innodb select_big 14.00 -14.96% -1.82
0.00 31.00 12.18 1.54
innodb select_big_str 1.00 +14.44% 0.17
0.00 2.00 1.17 0.38
innodb select_cache 62.00 -3.77% -2.25
49.00 77.00 59.75 5.60
innodb select_cache2 61.00 -1.48% -0.89
49.00 75.00 60.11 6.23
innodb select_column+column 4.00 -35.51% -1.05
2.00 4.00 2.95 0.72
innodb select_diff_key 1.00 -348.24% -0.78
0.00 1.00 0.22 0.42
innodb select_distinct 4.00 +5.82% 0.25
3.00 8.00 4.25 0.55
innodb select_group 16.00 +1.68% 0.27
4.00 136.00 16.27 5.34
innodb select_group_when_MANY_tables 12.00 -25.58% -2.44
3.00 49.00 9.56 9.30
innodb select_join 0.00 +100.00% 0.57
0.00 1.00 0.57 0.49
innodb select_key 64.00 -20.45% -10.87
40.00 66.00 53.13 7.59
innodb select_key2 70.00 -17.00% -10.17
45.00 75.00 59.83 8.41
innodb select_key2_return_key 67.00 -17.21% -9.84
42.00 71.00 57.16 8.22
innodb select_key2_return_prim 69.00 -19.12% -11.07
42.00 72.00 57.93 8.37
innodb select_key_prefix 69.00 -16.75% -9.90
44.00 75.00 59.10 8.45
innodb select_key_prefix_join 6.00 -26.81% -1.27
3.00 10.00 4.73 0.65
innodb select_key_return_key 61.00 -16.96% -8.85
38.00 65.00 52.15 7.59
innodb select_many_fields 13.00 +12.66% 1.88
11.00 19.00 14.88 1.79
innodb select_range 41.00 +12.56% 5.89
38.00 76.00 46.89 4.06
innodb select_range_key2 9.00 -8.40% -0.70
6.00 11.00 8.30 1.06
innodb select_range_prefix 9.00 -14.18% -1.12
5.00 10.00 7.88 1.12
innodb select_simple 2.00 -20.57% -0.34
1.00 3.00 1.66 0.51
innodb select_simple_cache 2.00 -27.35% -0.43
1.00 3.00 1.57 0.51
innodb select_simple_join 1.00 -50.50% -0.34
0.00 3.00 0.66 0.48
innodb update_autocommit 4.00 -19.66% -0.66
2.00 16.00 3.34 1.00
innodb update_big 60.00 -17.06% -8.74
31.00 195.00 51.26 24.08
innodb update_commit 2.00 -26.94% -0.42
1.00 10.00 1.58 0.72
innodb update_of_key 22.00 +8.96% 2.16
18.00 100.00 24.16 6.08
innodb update_of_key_big 37.00 -33.27% -9.24
15.00 75.00 27.76 10.93
innodb update_of_primary_key_many_keys 1332.00 -7.03% -87.54
647.00 6065.00 1244.46 937.80
innodb update_rollback 2.00 -12.97% -0.23
1.00 31.00 1.77 1.87
innodb update_with_key 120.00 -8.84% -9.75
90.00 598.00 110.25 20.53
innodb update_with_key_prefix 44.00 -10.57% -4.21
33.00 202.00 39.79 6.77
innodb wisc_benchmark 2.00 +19.26% 0.48
2.00 5.00 2.48 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2241.1.2: Lee Bieber 2011-03-17 [merge] Merge Stewart - refactoring of
default values
2200.2.25: Stewart Smith 2011-03-17 [merge] Merge refactoring of default
values work
2200.2.24: Stewart Smith 2011-03-07 [merge] merge trunk
2200.2.23: Stewart Smith 2011-03-04 [merge] merge trunk
2200.2.22: Stewart Smith 2011-03-03 [merge] merge trunk
2200.2.21: Stewart Smith 2011-03-02 remove the now unused AlterDrop class,
header file and includes
2200.2.20: Stewart Smith 2011-03-02 remove drop_list from AlterInfo - is
now only in the message::AlterTable protobuf message
2200.2.19: Stewart Smith 2011-03-02 use the AlterTable protobuf message
list of colmuns, keys and foreign keys to drop inside the ALTER TABLE code
instead of the list in alter_info
2200.2.18: Stewart Smith 2011-03-02 add fields, indexes and foreign keys to
drop in ALTER TABLE DROP and DROP INDEX to the AlterTable protobuf message in
parser
2200.2.17: Stewart Smith 2011-03-02 add AlterTable operations for dropping
column, keys and foreign keys (by name) in the AlterTable protobuf message.
2200.2.16: Stewart Smith 2011-03-02 remove enum_enable_or_disable which was
only used for alter_info.keys_onoff. We can just use the message::AlterTable now
2200.2.15: Stewart Smith 2011-03-01 remove enum ha_build_method and instead
use the build method in message::AlterTable.
2200.2.14: Stewart Smith 2011-03-01 throw an error if ONLINE ALTER TABLE is
asked for that we cannot do without a copying alter table.
2200.2.13: Stewart Smith 2011-03-01 make ALTER TABLE RENAME and
DISABLE/ENABLE keys use the AlterTable protobuf message constructed in the
parser, with asserts for the old AlterInfo structure matching
2200.2.12: Stewart Smith 2011-03-01 set RenameTable and AlterKeysOnOff
protobuf messages inside the AlterTable protobuf message for ALTER TABLE in
parser
2200.2.11: Stewart Smith 2011-03-01 move the message::AlterTable header
include into sql_lex.cc so we can just have a forward declaration in sql_lex.h
- greatly speeding compile time
2200.2.10: Stewart Smith 2011-03-01 add RenameTable and AlterKeysOnOff
messages inside AlterTable protobuf message. We have these separate to the main
repeated AlterTableOperation message as multiple invocations of these parts of
ALTER TABLE have no effect (the last one in the ALTER TABLE statement is taken)
2200.2.9: Stewart Smith 2011-03-01 add a utterly insane test of combination
of renaming table and disable/enable keys to alter_table_rename_plus test
2200.2.8: Stewart Smith 2011-02-28 in test for ALTER TABLE including RENAME
and others, add a test for DISABLE KEYS, RENAME as there is a special RENAME
TABLE code path for this case.
2200.2.7: Stewart Smith 2011-02-28 add a test for ALTER TABLE with both
renaming the table and another operation.
2200.2.6: Stewart Smith 2011-02-28 switch DISCARD/IMPORT TABLESPACE to only
use the alter table protobuf message
2200.2.5: Stewart Smith 2011-02-28 properly reset alter_table in Lex
2200.2.4: Stewart Smith 2011-02-28 document the limitation on
DISCARD/IMPORT tablespace in teh AlterTableOperation protobuf message
2200.2.3: Stewart Smith 2011-02-28 add code to store IMPORT/DISCARD
TABLESPACE operation in the AlterTable protobuf message. assert that we get the
right thing in alter table code
2200.2.2: Stewart Smith 2011-02-28 add very basic ALTER TABLE protobuf
message and add the DEFAULT/OFFLINE/ONLINE build method member to it, assert
that we're doing the right thing.
2200.2.1: Stewart Smith 2011-02-28 rename old alter table proto to
AddedFields as it really has a dual purpose and isn't how we should structure
Alter Table.
2241.1.1: Lee Bieber 2011-03-17 [merge] Merge Olaf - more refactoring
2240.2.2: Olaf van der Spek 2011-03-17 Refactor
2240.2.1: Olaf van der Spek 2011-03-17 Refactor
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
