=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 835
RUN DATE: 2011-01-20T22:19:10.412532
SERVER: drizzled
VERSION: staging
REVISION: 2100
COMMENT: 2100: Lee Bieber 2011-01-21 [merge] Merge Stewart - Fix bug 664222:
DDL operations have an implicit commit
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 30.00 +6.25% 2.00
30.00 33.00 32.00 1.10
innodb alter_table_drop 24.00 +0.83% 0.20
23.00 25.00 24.20 0.75
innodb connect 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
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 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb count 13.00 +13.33% 2.00
13.00 18.00 15.00 2.10
innodb count_distinct 6.00 +18.92% 1.40
6.00 8.00 7.40 0.80
innodb count_distinct_2 12.00 +14.29% 2.00
12.00 16.00 14.00 1.41
innodb count_distinct_big 21.00 +5.41% 1.20
20.00 25.00 22.20 1.94
innodb count_distinct_group 16.00 -5.26% -0.80
14.00 16.00 15.20 0.75
innodb count_distinct_group_on_key 8.00 +18.37% 1.80
8.00 11.00 9.80 1.17
innodb count_distinct_group_on_key_parts 14.00 -1.45% -0.20
12.00 15.00 13.80 0.98
innodb count_distinct_key_prefix 5.00 +10.71% 0.60
5.00 6.00 5.60 0.49
innodb count_group_on_key_parts 11.00 +3.51% 0.40
11.00 12.00 11.40 0.49
innodb count_on_key 92.00 +1.92% 1.80
92.00 96.00 93.80 1.60
innodb create+drop 33.00 -4.43% -1.40
31.00 33.00 31.60 0.80
innodb create_index 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb create_key+drop 29.00 +2.03% 0.60
29.00 31.00 29.60 0.80
innodb create_MANY_tables 20.00 +1.96% 0.40
20.00 21.00 20.40 0.49
innodb create_table 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb delete_all_many_keys 664.00 -0.03% -0.20
618.00 749.00 663.80 45.32
innodb delete_autocommit 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb delete_big 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb delete_big_many_keys 663.00 -0.00% 0.00
618.00 748.00 663.00 45.12
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
innodb delete_range 9.00 -4.65% -0.40
8.00 10.00 8.60 0.80
innodb delete_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
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 +8.54% 1.40
15.00 17.00 16.40 0.80
innodb insert 112.00 +1.23% 1.40
112.00 115.00 113.40 1.02
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 274.00 +2.91% 8.20
274.00 306.00 282.20 12.11
innodb insert_many_fields 7.00 -12.90% -0.80
6.00 7.00 6.20 0.40
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 3.00 +16.67% 0.60
3.00 5.00 3.60 0.80
innodb insert_select_2_keys 7.00 -6.06% -0.40
6.00 7.00 6.60 0.49
innodb min_max 7.00 +12.50% 1.00
7.00 9.00 8.00 0.89
innodb min_max_on_key 26.00 -4.00% -1.00
24.00 26.00 25.00 0.89
innodb multiple_value_insert 7.00 -2.94% -0.20
6.00 7.00 6.80 0.40
innodb once_prepared_select 30.00 -1.35% -0.40
29.00 30.00 29.60 0.49
innodb order_by_big 15.00 -5.63% -0.80
13.00 15.00 14.20 0.98
innodb order_by_big_key 13.00 +9.72% 1.40
13.00 16.00 14.40 1.36
innodb order_by_big_key2 12.00 +4.76% 0.60
11.00 14.00 12.60 1.02
innodb order_by_big_key_desc 14.00 +7.89% 1.20
14.00 17.00 15.20 1.17
innodb order_by_big_key_diff 13.00 +4.41% 0.60
12.00 15.00 13.60 1.02
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 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
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 21.00 +4.55% 1.00
18.00 24.00 22.00 2.28
innodb outer_join_found 20.00 +5.66% 1.20
17.00 23.00 21.20 2.40
innodb outer_join_not_found 18.00 +5.26% 1.00
16.00 21.00 19.00 1.79
innodb outer_join_on_key 14.00 +6.67% 1.00
12.00 17.00 15.00 1.79
innodb prepared_select 37.00 -0.54% -0.20
36.00 37.00 36.80 0.40
innodb select_1_row 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_1_row_cache 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb select_2_rows 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_big 13.00 -0.00% 0.00
11.00 14.00 13.00 1.10
innodb select_big_str 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb select_cache 65.00 +6.07% 4.20
63.00 76.00 69.20 5.31
innodb select_cache2 58.00 +14.96% 10.20
58.00 75.00 68.20 5.78
innodb select_column+column 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_diff_key 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb select_distinct 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb select_group 15.00 +6.25% 1.00
15.00 19.00 16.00 1.55
innodb select_group_when_MANY_tables 11.00 +8.33% 1.00
11.00 13.00 12.00 0.63
innodb select_join 0.00 +100.00% 0.80
0.00 1.00 0.80 0.40
innodb select_key 64.00 -0.31% -0.20
63.00 64.00 63.80 0.40
innodb select_key2 71.00 -0.28% -0.20
69.00 72.00 70.80 0.98
innodb select_key2_return_key 69.00 -1.17% -0.80
67.00 69.00 68.20 0.75
innodb select_key2_return_prim 70.00 -1.45% -1.00
67.00 70.00 69.00 1.10
innodb select_key_prefix 72.00 -1.69% -1.20
69.00 72.00 70.80 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 64.00 -0.95% -0.60
63.00 64.00 63.40 0.49
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 46.00 -6.48% -2.80
39.00 46.00 43.20 2.79
innodb select_range_key2 10.00 -4.17% -0.40
9.00 10.00 9.60 0.49
innodb select_range_prefix 8.00 +11.11% 1.00
8.00 10.00 9.00 0.63
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 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb update_autocommit 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb update_big 61.00 -2.69% -1.60
57.00 62.00 59.40 2.06
innodb update_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb update_of_key 23.00 -0.00% 0.00
22.00 24.00 23.00 0.63
innodb update_of_key_big 33.00 -0.61% -0.20
30.00 35.00 32.80 1.72
innodb update_of_primary_key_many_keys 1327.00 +2.15% 29.20
1317.00 1491.00 1356.20 67.50
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 120.00 +1.15% 1.40
119.00 125.00 121.40 2.06
innodb update_with_key_prefix 42.00 +4.11% 1.80
41.00 50.00 43.80 3.25
innodb wisc_benchmark 3.00 -25.00% -0.60
2.00 3.00 2.40 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 30.00 +8.06% 2.63
29.00 34.00 32.63 1.38
innodb alter_table_drop 24.00 +2.77% 0.68
23.00 27.00 24.68 0.86
innodb connect 2.00 +11.63% 0.26
2.00 3.00 2.26 0.44
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 -14.00% -0.37
2.00 3.00 2.63 0.48
innodb count 13.00 +17.11% 2.68
13.00 18.00 15.68 2.00
innodb count_distinct 6.00 +15.56% 1.11
6.00 8.00 7.11 0.72
innodb count_distinct_2 12.00 +16.18% 2.32
12.00 16.00 14.32 1.38
innodb count_distinct_big 21.00 +7.42% 1.68
20.00 25.00 22.68 1.84
innodb count_distinct_group 16.00 +0.65% 0.11
12.00 24.00 16.11 3.19
innodb count_distinct_group_on_key 8.00 +20.42% 2.05
8.00 12.00 10.05 1.00
innodb count_distinct_group_on_key_parts 14.00 +6.67% 1.00
11.00 25.00 15.00 3.21
innodb count_distinct_key_prefix 5.00 +12.04% 0.68
5.00 7.00 5.68 0.57
innodb count_group_on_key_parts 11.00 +0.95% 0.11
10.00 12.00 11.11 0.55
innodb count_on_key 92.00 +3.10% 2.95
92.00 102.00 94.95 2.48
innodb create+drop 33.00 +2.49% 0.84
30.00 42.00 33.84 4.27
innodb create_index 3.00 +6.56% 0.21
2.00 4.00 3.21 0.52
innodb create_key+drop 29.00 +11.41% 3.74
27.00 49.00 32.74 7.69
innodb create_MANY_tables 20.00 +30.53% 8.79
19.00 62.00 28.79 16.19
innodb create_table 1.00 -850.00% -0.89
0.00 1.00 0.11 0.31
innodb delete_all_many_keys 664.00 -12.75% -75.11
281.00 749.00 588.89 160.70
innodb delete_autocommit 4.00 -11.76% -0.42
3.00 4.00 3.58 0.49
innodb delete_big 1.00 -171.43% -0.63
0.00 1.00 0.37 0.48
innodb delete_big_many_keys 663.00 -12.72% -74.84
281.00 748.00 588.16 160.29
innodb delete_commit 2.00 -15.15% -0.26
1.00 2.00 1.74 0.44
innodb delete_key 2.00 +30.91% 0.89
2.00 4.00 2.89 0.45
innodb delete_range 9.00 -10.32% -0.84
6.00 10.00 8.16 0.87
innodb delete_rollback 2.00 +52.50% 2.21
2.00 12.00 4.21 4.03
innodb drop_index 3.00 +5.00% 0.16
2.00 4.00 3.16 0.49
innodb drop_table_when_MANY_tables 15.00 +49.74% 14.84
15.00 90.00 29.84 26.38
innodb insert 112.00 +3.18% 3.68
111.00 125.00 115.68 4.71
innodb insert_autocommit 3.00 +12.31% 0.42
3.00 5.00 3.42 0.59
innodb insert_commit 2.00 -5.56% -0.11
1.00 3.00 1.89 0.45
innodb insert_duplicates 19.00 +0.82% 0.16
18.00 20.00 19.16 0.49
innodb insert_key 274.00 +13.69% 43.47
270.00 445.00 317.47 62.13
innodb insert_many_fields 7.00 -16.67% -1.00
5.00 7.00 6.00 0.46
innodb insert_rollback 2.00 +2.56% 0.05
2.00 3.00 2.05 0.22
innodb insert_select_1_key 3.00 +30.49% 1.32
3.00 7.00 4.32 1.13
innodb insert_select_2_keys 7.00 -2.31% -0.16
5.00 10.00 6.84 1.72
innodb min_max 7.00 +10.14% 0.79
6.00 9.00 7.79 1.00
innodb min_max_on_key 26.00 -5.11% -1.26
24.00 26.00 24.74 0.64
innodb multiple_value_insert 7.00 -13.68% -0.84
4.00 7.00 6.16 0.99
innodb once_prepared_select 30.00 -2.15% -0.63
29.00 30.00 29.37 0.48
innodb order_by_big 15.00 -2.89% -0.42
13.00 16.00 14.58 1.14
innodb order_by_big_key 13.00 +11.47% 1.68
13.00 17.00 14.68 1.38
innodb order_by_big_key2 12.00 +5.79% 0.74
11.00 14.00 12.74 0.91
innodb order_by_big_key_desc 14.00 +7.96% 1.21
13.00 17.00 15.21 1.20
innodb order_by_big_key_diff 13.00 +3.14% 0.42
12.00 15.00 13.42 0.82
innodb order_by_big_key_prefix 12.00 +10.59% 1.42
12.00 15.00 13.42 0.88
innodb order_by_key2_diff 1.00 +20.83% 0.26
1.00 2.00 1.26 0.44
innodb order_by_key_prefix 1.00 -11.76% -0.11
0.00 1.00 0.89 0.31
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 21.00 +5.00% 1.11
18.00 25.00 22.11 1.83
innodb outer_join_found 20.00 +6.63% 1.42
17.00 23.00 21.42 1.84
innodb outer_join_not_found 18.00 +5.79% 1.11
16.00 21.00 19.11 1.59
innodb outer_join_on_key 14.00 +7.96% 1.21
12.00 17.00 15.21 1.36
innodb prepared_select 37.00 +0.42% 0.16
36.00 38.00 37.16 0.67
innodb select_1_row 4.00 -7.04% -0.26
3.00 4.00 3.74 0.44
innodb select_1_row_cache 3.00 +8.06% 0.26
3.00 4.00 3.26 0.44
innodb select_2_rows 4.00 -4.11% -0.16
3.00 4.00 3.84 0.36
innodb select_big 13.00 +1.98% 0.26
11.00 15.00 13.26 1.21
innodb select_big_str 1.00 +26.92% 0.37
1.00 2.00 1.37 0.48
innodb select_cache 65.00 -1.73% -1.11
57.00 76.00 63.89 4.77
innodb select_cache2 58.00 +7.86% 4.95
56.00 75.00 62.95 4.97
innodb select_column+column 4.00 -7.04% -0.26
3.00 4.00 3.74 0.44
innodb select_diff_key 1.00 -90.00% -0.47
0.00 1.00 0.53 0.50
innodb select_distinct 5.00 -11.76% -0.53
4.00 5.00 4.47 0.50
innodb select_group 15.00 +10.38% 1.74
15.00 19.00 16.74 1.55
innodb select_group_when_MANY_tables 11.00 +42.11% 8.00
11.00 49.00 19.00 13.29
innodb select_join 0.00 +100.00% 0.68
0.00 1.00 0.68 0.46
innodb select_key 64.00 -0.50% -0.32
63.00 65.00 63.68 0.57
innodb select_key2 71.00 -0.37% -0.26
69.00 72.00 70.74 0.91
innodb select_key2_return_key 69.00 -1.16% -0.79
67.00 70.00 68.21 0.89
innodb select_key2_return_prim 70.00 -1.53% -1.05
67.00 71.00 68.95 1.05
innodb select_key_prefix 72.00 -1.94% -1.37
69.00 72.00 70.63 0.81
innodb select_key_prefix_join 5.00 +3.06% 0.16
5.00 6.00 5.16 0.36
innodb select_key_return_key 64.00 -1.93% -1.21
62.00 64.00 62.79 0.69
innodb select_many_fields 13.00 +0.80% 0.11
13.00 14.00 13.11 0.31
innodb select_range 46.00 -8.30% -3.53
39.00 47.00 42.47 2.72
innodb select_range_key2 10.00 -5.56% -0.53
9.00 10.00 9.47 0.50
innodb select_range_prefix 8.00 +12.14% 1.11
8.00 10.00 9.11 0.64
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 -35.71% -0.26
0.00 1.00 0.74 0.44
innodb update_autocommit 3.00 +52.50% 3.32
3.00 16.00 6.32 4.89
innodb update_big 61.00 +12.79% 8.95
57.00 112.00 69.95 20.05
innodb update_commit 2.00 +41.54% 1.42
1.00 10.00 3.42 3.03
innodb update_of_key 23.00 -0.23% -0.05
21.00 25.00 22.95 1.19
innodb update_of_key_big 33.00 +16.06% 6.32
29.00 58.00 39.32 7.79
innodb update_of_primary_key_many_keys 1327.00 -7.03% -87.11
688.00 1513.00 1239.89 275.87
innodb update_rollback 2.00 +73.61% 5.58
2.00 31.00 7.58 10.70
innodb update_with_key 120.00 +1.21% 1.47
118.00 125.00 121.47 1.96
innodb update_with_key_prefix 42.00 +4.89% 2.16
41.00 50.00 44.16 2.25
innodb wisc_benchmark 3.00 -14.00% -0.37
2.00 3.00 2.63 0.48
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 30.00 -52.54% -10.33
11.00 61.00 19.67 9.82
innodb alter_table_drop 24.00 -35.41% -6.28
10.00 57.00 17.72 7.08
innodb connect 2.00 +3.34% 0.07
1.00 3.00 2.07 0.42
innodb connect+select_1_row 3.00 -12.06% -0.32
2.00 5.00 2.68 0.48
innodb connect+select_simple 3.00 -29.58% -0.68
1.00 3.00 2.32 0.47
innodb count 13.00 +17.40% 2.74
12.00 193.00 15.74 9.32
innodb count_distinct 6.00 +8.33% 0.54
5.00 50.00 6.54 2.39
innodb count_distinct_2 12.00 +8.43% 1.10
11.00 63.00 13.10 3.09
innodb count_distinct_big 21.00 +3.75% 0.82
5.00 67.00 21.82 3.11
innodb count_distinct_group 16.00 -23.24% -3.02
10.00 68.00 12.98 3.21
innodb count_distinct_group_on_key 8.00 +15.21% 1.44
7.00 69.00 9.44 3.15
innodb count_distinct_group_on_key_parts 14.00 -14.70% -1.79
9.00 72.00 12.21 3.29
innodb count_distinct_key_prefix 5.00 +1.99% 0.10
3.00 52.00 5.10 2.52
innodb count_group_on_key_parts 11.00 -11.81% -1.16
7.00 72.00 9.84 3.30
innodb count_on_key 92.00 -8.31% -7.06
68.00 107.00 84.94 7.07
innodb create+drop 33.00 -1.67% -0.54
18.00 75.00 32.46 12.58
innodb create_index 3.00 -5.30% -0.15
1.00 8.00 2.85 1.19
innodb create_key+drop 29.00 -3.52% -0.99
21.00 50.00 28.01 5.14
innodb create_MANY_tables 20.00 +43.99% 15.71
14.00 121.00 35.71 17.39
innodb create_table 1.00 -803.53% -0.89
0.00 3.00 0.11 0.37
innodb delete_all_many_keys 664.00 -50.91% -224.00
212.00 1888.00 440.00 380.42
innodb delete_autocommit 4.00 -17.05% -0.58
2.00 14.00 3.42 0.77
innodb delete_big 1.00 -277.83% -0.74
0.00 3.00 0.26 0.46
innodb delete_big_many_keys 663.00 -48.29% -215.90
212.00 2293.00 447.10 396.17
innodb delete_commit 2.00 -35.87% -0.53
1.00 5.00 1.47 0.53
innodb delete_key 2.00 +35.22% 1.09
2.00 35.00 3.09 1.57
innodb delete_range 9.00 -8.94% -0.74
5.00 23.00 8.26 3.41
innodb delete_rollback 2.00 -18.09% -0.31
1.00 12.00 1.69 0.95
innodb drop_index 3.00 -2.26% -0.07
1.00 9.00 2.93 1.39
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.61% 4.90
11.00 90.00 19.90 7.90
innodb insert 112.00 -5.85% -6.19
3.00 343.00 105.81 15.21
innodb insert_autocommit 3.00 -1.05% -0.03
2.00 99.00 2.97 3.51
innodb insert_commit 2.00 -50.84% -0.67
1.00 3.00 1.33 0.48
innodb insert_duplicates 19.00 -26.56% -3.99
11.00 21.00 15.01 2.45
innodb insert_key 274.00 +10.50% 32.14
142.00 700.00 306.14 113.70
innodb insert_many_fields 7.00 -25.34% -1.42
3.00 17.00 5.58 1.86
innodb insert_rollback 2.00 -22.82% -0.37
1.00 3.00 1.63 0.54
innodb insert_select_1_key 3.00 +20.43% 0.77
2.00 10.00 3.77 0.92
innodb insert_select_2_keys 7.00 -15.71% -0.95
4.00 16.00 6.05 2.20
innodb min_max 7.00 +10.45% 0.82
6.00 110.00 7.82 4.80
innodb min_max_on_key 26.00 -29.70% -5.95
14.00 37.00 20.05 2.90
innodb multiple_value_insert 7.00 -31.42% -1.67
2.00 50.00 5.33 4.52
innodb once_prepared_select 30.00 -27.09% -6.39
18.00 32.00 23.61 3.31
innodb order_by_big 15.00 -5.05% -0.72
12.00 31.00 14.28 1.57
innodb order_by_big_key 13.00 +1.09% 0.14
11.00 32.00 13.14 1.63
innodb order_by_big_key2 12.00 +0.68% 0.08
10.00 33.00 12.08 1.57
innodb order_by_big_key_desc 14.00 -5.36% -0.71
11.00 32.00 13.29 1.62
innodb order_by_big_key_diff 13.00 -7.23% -0.88
10.00 31.00 12.12 1.54
innodb order_by_big_key_prefix 12.00 +2.28% 0.28
10.00 32.00 12.28 1.59
innodb order_by_key2_diff 1.00 +28.34% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -27.45% -0.22
0.00 2.00 0.78 0.42
innodb order_by_range 1.00 -22.36% -0.18
0.00 2.00 0.82 0.39
innodb outer_join 21.00 -10.23% -1.95
15.00 61.00 19.05 3.74
innodb outer_join_found 20.00 -8.03% -1.49
14.00 58.00 18.51 3.60
innodb outer_join_not_found 18.00 -11.20% -1.81
12.00 46.00 16.19 3.15
innodb outer_join_on_key 14.00 -10.24% -1.30
10.00 59.00 12.70 2.79
innodb prepared_select 37.00 -20.95% -6.41
22.00 40.00 30.59 4.24
innodb select_1_row 4.00 -44.63% -1.23
2.00 4.00 2.77 0.66
innodb select_1_row_cache 3.00 -16.25% -0.42
2.00 4.00 2.58 0.64
innodb select_2_rows 4.00 -43.69% -1.22
2.00 4.00 2.78 0.67
innodb select_big 13.00 -7.84% -0.95
0.00 31.00 12.05 1.57
innodb select_big_str 1.00 +12.44% 0.14
0.00 2.00 1.14 0.35
innodb select_cache 65.00 -9.86% -5.83
49.00 77.00 59.17 5.67
innodb select_cache2 58.00 +2.74% 1.63
49.00 75.00 59.63 6.49
innodb select_column+column 4.00 -41.83% -1.18
2.00 4.00 2.82 0.67
innodb select_diff_key 1.00 -372.84% -0.79
0.00 1.00 0.21 0.41
innodb select_distinct 5.00 -18.96% -0.80
3.00 8.00 4.20 0.54
innodb select_group 15.00 +7.21% 1.17
4.00 136.00 16.17 5.73
innodb select_group_when_MANY_tables 11.00 -20.24% -1.85
3.00 49.00 9.15 9.97
innodb select_join 0.00 +100.00% 0.57
0.00 1.00 0.57 0.50
innodb select_key 64.00 -24.52% -12.60
40.00 66.00 51.40 6.76
innodb select_key2 71.00 -22.36% -12.97
45.00 75.00 58.03 7.69
innodb select_key2_return_key 69.00 -24.66% -13.65
42.00 70.00 55.35 7.44
innodb select_key2_return_prim 70.00 -24.80% -13.91
42.00 72.00 56.09 7.58
innodb select_key_prefix 72.00 -25.79% -14.76
44.00 75.00 57.24 7.64
innodb select_key_prefix_join 5.00 -7.17% -0.33
3.00 10.00 4.67 0.66
innodb select_key_return_key 64.00 -26.94% -13.58
38.00 65.00 50.42 6.76
innodb select_many_fields 13.00 +14.23% 2.16
11.00 19.00 15.16 1.78
innodb select_range 46.00 +3.42% 1.63
39.00 76.00 47.63 3.77
innodb select_range_key2 10.00 -23.39% -1.90
6.00 10.00 8.10 0.99
innodb select_range_prefix 8.00 -4.38% -0.34
5.00 10.00 7.66 1.03
innodb select_simple 2.00 -24.98% -0.40
1.00 3.00 1.60 0.52
innodb select_simple_cache 2.00 -33.57% -0.50
1.00 3.00 1.50 0.52
innodb select_simple_join 1.00 -55.47% -0.36
0.00 3.00 0.64 0.49
innodb update_autocommit 3.00 +8.76% 0.29
2.00 16.00 3.29 1.05
innodb update_big 61.00 -22.01% -11.00
31.00 195.00 50.00 25.76
innodb update_commit 2.00 -31.90% -0.48
1.00 10.00 1.52 0.75
innodb update_of_key 23.00 +5.97% 1.46
18.00 100.00 24.46 6.50
innodb update_of_key_big 33.00 -25.10% -6.62
15.00 75.00 26.38 11.09
innodb update_of_primary_key_many_keys 1327.00 -8.55% -104.51
647.00 6065.00 1222.49 1,034.10
innodb update_rollback 2.00 -16.12% -0.28
1.00 31.00 1.72 2.01
innodb update_with_key 120.00 -10.75% -11.65
90.00 598.00 108.35 21.54
innodb update_with_key_prefix 42.00 -7.52% -2.94
33.00 202.00 39.06 6.98
innodb wisc_benchmark 3.00 -21.62% -0.53
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2099.1.3: Lee Bieber 2011-01-21 [merge] Merge Stewart - Fix bug 664222: DDL
operations have an implicit commit
1890.2.53: Stewart Smith 2011-01-21 [merge] merge trunk
1890.2.52: Stewart Smith 2011-01-07 add test for EXECUTE WAIT doing DDL
that will actually do the DDL - run a COMMIT first.
1890.2.51: Stewart Smith 2011-01-07 revert patch that changed EXECUTE to
use AUTOCOMMIT=0 instead of START TRANSACTION. Of course, this means that you
cannot do DDL inside EXECUTE, so change the test and result for execute_wait
test which did that.
1890.2.50: Stewart Smith 2011-01-06 [merge] merge trunk
1890.2.49: Stewart Smith 2011-01-04 error out on DROP INDEX inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED.
1890.2.48: Stewart Smith 2011-01-04 error out on CREATE INDEX inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED.
1890.2.47: Stewart Smith 2011-01-04 statement_boundaries test relied on
implicit commits in schema operations. use explicit commits instead
1890.2.46: Stewart Smith 2011-01-04 add test for DROP SCHEMA inside a txn
erroring out
1890.2.45: Stewart Smith 2011-01-04 error out on DROP SCHEMA inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED. You may have been mistaken
that this would previously error out on ER_LOCK_OR_ACTIVE_TRANSACTION. It
didn't.
1890.2.44: Stewart Smith 2011-01-04 error out on ALTER SCHEMA inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED. Previously this would be
ER_LOCK_OR_ACTIVE_TRANSACTION which isn't exactly correct or consistent with
others.
1890.2.43: Stewart Smith 2011-01-04 add test for CREATE SCHEMA inside a txn
erroring out
1890.2.42: Stewart Smith 2011-01-04 error out on CREATE SCHEMA inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED
1890.2.41: Stewart Smith 2011-01-04 innobase innodb test relied on implicit
commits in TRUNCATE TABLE and RENAME TABLE. use explicit commits instead
1890.2.40: Stewart Smith 2011-01-04 error out on RENAME TABLE inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED
1890.2.39: Stewart Smith 2011-01-04 error out on TRUNCATE TABLE inside a
transaction with ER_TRANSACTIONAL_DDL_NOT_SUPPORTED
1890.2.38: Stewart Smith 2011-01-04 change EXECUTE to use SET AUTOCOMMIT=0
instead of START TRANSACTION as this continues to allow us to execute DDL using
EXECUTE as we won't have an ongoing transaction to cause us to error out....
although if we're running any other statement, we will start a transaction.
neat trick(tm)
1890.2.37: Stewart Smith 2011-01-04 update Transactional DDL not supported
error number
1890.2.36: Stewart Smith 2011-01-04 fix merge conflict that was accidently
committed
1890.2.35: Stewart Smith 2011-01-04 add ddl_transactions to list of default
test suites
1890.2.34: Stewart Smith 2011-01-04 [merge] merge run-more-suites (incl
trunk
1890.2.33: Stewart Smith 2011-01-04 add a small test suite for DDL
transactions (i.e. that we get an error when doing them
1890.2.32: Stewart Smith 2011-01-04 innobase innodb test relied on implicit
commit in ALTER TABLE. use explicit commit instead
1890.2.31: Stewart Smith 2011-01-04 myisam mix2 test relied on implicit
commit in ALTER TABLE. use explicit commit instead
1890.2.30: Stewart Smith 2011-01-04 throw
ER_TRANSACTIONAL_DDL_NOT_SUPPORTED in ALTER TABLE if there is an ongoing txn
1890.2.29: Stewart Smith 2010-12-29 use explicit commit in
haildb.trx_isolation_serializable test instead of implicit commit in DROP TABLE
1890.2.28: Stewart Smith 2010-12-29 use explicit commit in
haildb.trx_isolation_repeatable_read test instead of implicit commit in DROP
TABLE
1890.2.27: Stewart Smith 2010-12-29 use explicit commit in
haildb.trx_isolation_read_uncommitted test instead of implicit commit in DROP
TABLE
1890.2.26: Stewart Smith 2010-12-29 use explicit commit in
storage_engine_apI_tester.transaction test instead of implicit commit in DROP
TABLE
1890.2.25: Stewart Smith 2010-12-29 use explicit COMMIT in
transaction_log.auto_commit test instead of implicit commit in DROP TABLE
1890.2.24: Stewart Smith 2010-12-29 use explicit COMMIT in innodb_bug51920
test intesad of implicit commit in DROP TABLE
1890.2.23: Stewart Smith 2010-12-29 use explicit COMMIT in innodb_bug53674
test intesad of implicit commit in DROP TABLE
1890.2.22: Stewart Smith 2010-12-29 use explicit COMMIT in innodb test
intesad of implicit commit in DROP TABLE
1890.2.21: Stewart Smith 2010-12-29 use explicit COMMIT in
innodb-semi-consistent test intesad of implicit commit in DROP TABLE
1890.2.20: Stewart Smith 2010-12-29 use explicit COMMIT in
trx_isolation_read_committed test instead of implicit commit in DROP TABLE
1890.2.19: Stewart Smith 2010-12-29 use explicit COMMIT in transaction test
instead of implicit commit in DROP TABLE
1890.2.18: Stewart Smith 2010-12-29 use explicit COMMIT in
statement_boundaries test instead of relying on implicit COMMIT in DROP TABLE
statement
1890.2.17: Stewart Smith 2010-12-29 use explicit COMMITs in savepoints test
instead of implicit COMMITs in DROP TABLE statement
1890.2.16: Stewart Smith 2010-12-29 use explicit COMMIT in randgen_queries
test instead of implicit COMMIt in DROP TABLE
1890.2.15: Stewart Smith 2010-12-29 make insert test use an explicit commit
instead of an implicit one in DROP TABLE
1890.2.14: Stewart Smith 2010-12-29 update flush_block_commit test to use
an explicit COMMIT instead of the implicit one in DROP TABLE
1890.2.13: Stewart Smith 2010-12-29 error out with
ER_TRANSACTIONAL_DDL_NOT_SUPPORTED in DROP TABLE if there is an ongoing
transaction.
1890.2.12: Stewart Smith 2010-12-29 update docs on Transactional DDL support
1890.2.11: Stewart Smith 2010-12-29 use explicit COMMIT in innobase
unsafe_binlog test
1890.2.10: Stewart Smith 2010-12-29 use explicit commit in innodb_mysql
test instead of implicit in CREATE TABLE
1890.2.9: Stewart Smith 2010-12-29 innobase.innodb test: use explicit
COMMIT instead of relying on implicit commit in CREATE TABLE
1890.2.8: Stewart Smith 2010-12-29 transaction log test: use explicit
COMMIT instead of relying on implicit in CREATE TABLE
1890.2.7: Stewart Smith 2010-12-29 select_in_null test was attempting DDL
inside txn. remove begin/commit as it's not needed anyway
1890.2.6: Stewart Smith 2010-12-29 insert.test was setting autocommit=0 but
not resetting it. really we just wanted a txn for bulk loading, which we had
anyway. remove the set
1890.2.5: Stewart Smith 2010-12-29 SET AUTOCOMMIT=1 was not completely
performing a COMMIT
1890.2.4: Stewart Smith 2010-12-29 remove unneeded and incorrectly added
errname.cc.THIS
1890.2.3: Stewart Smith 2010-12-29 [merge] merge fixing test-run --gdb
1890.2.2: Stewart Smith 2010-12-29 [merge] merge trunk
1890.2.1: Stewart Smith 2010-11-01 add error message for Transactional DDL
not being supported. Throw it in CREATE TABLE instead of implicit commit.
2099.1.2: Lee Bieber 2011-01-21 Add BSD copyright file to win32/config.h
2099.1.1: Lee Bieber 2011-01-20 [merge] Merge Brian - cleanup
user_locks.kill_wait test
2098.2.1: Brian Aker 2011-01-20 Fix lcov issue.
_______________________________________________
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
