=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 918
RUN DATE: 2011-02-23T10:47:51.433170
SERVER: drizzled
VERSION: staging
REVISION: 2195
COMMENT: 2195: Lee Bieber 2011-02-23 [merge] Merge Stewart - 676770: Error log
logging 'Sort aborted' messages when DML fails with ER_INVALID_ENUM_VALUE
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -1.23% -0.40
31.00 34.00 32.60 1.02
innodb alter_table_drop 24.00 +2.44% 0.60
24.00 26.00 24.60 0.80
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 17.00 -14.86% -2.20
13.00 17.00 14.80 1.83
innodb count_distinct 6.00 +6.25% 0.40
6.00 7.00 6.40 0.49
innodb count_distinct_2 14.00 -2.94% -0.40
12.00 15.00 13.60 1.02
innodb count_distinct_big 25.00 -10.62% -2.40
21.00 25.00 22.60 1.96
innodb count_distinct_group 13.00 +9.72% 1.40
13.00 15.00 14.40 0.80
innodb count_distinct_group_on_key 9.00 +4.26% 0.40
8.00 11.00 9.40 1.02
innodb count_distinct_group_on_key_parts 12.00 +10.45% 1.40
12.00 15.00 13.40 1.02
innodb count_distinct_key_prefix 5.00 -4.17% -0.20
4.00 5.00 4.80 0.40
innodb count_group_on_key_parts 11.00 -1.85% -0.20
10.00 12.00 10.80 0.75
innodb count_on_key 93.00 -0.22% -0.20
92.00 93.00 92.80 0.40
innodb create+drop 34.00 -1.80% -0.60
32.00 34.00 33.40 0.80
innodb create_index 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb create_key+drop 30.00 +4.46% 1.40
30.00 33.00 31.40 1.02
innodb create_MANY_tables 20.00 +1.96% 0.40
20.00 22.00 20.40 0.80
innodb delete_all_many_keys 621.00 +2.63% 16.80
574.00 714.00 637.80 45.11
innodb delete_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb delete_big 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb delete_big_many_keys 620.00 +2.61% 16.60
573.00 713.00 636.60 45.10
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb delete_range 9.00 +6.25% 0.60
9.00 10.00 9.60 0.49
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 19.00 -3.26% -0.60
18.00 19.00 18.40 0.49
innodb insert 113.00 +0.70% 0.80
113.00 115.00 113.80 0.75
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 275.00 -0.22% -0.60
255.00 297.00 274.40 13.41
innodb insert_many_fields 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb insert_rollback 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
innodb insert_select_1_key 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb insert_select_2_keys 6.00 -3.45% -0.20
5.00 6.00 5.80 0.40
innodb min_max 8.00 -2.56% -0.20
7.00 9.00 7.80 0.75
innodb min_max_on_key 25.00 -1.63% -0.40
24.00 25.00 24.60 0.49
innodb multiple_value_insert 8.00 -21.21% -1.40
5.00 8.00 6.60 1.02
innodb once_prepared_select 29.00 +0.68% 0.20
29.00 30.00 29.20 0.40
innodb order_by_big 13.00 +9.72% 1.40
13.00 16.00 14.40 1.36
innodb order_by_big_key 14.00 +1.41% 0.20
13.00 15.00 14.20 0.75
innodb order_by_big_key2 14.00 -4.48% -0.60
12.00 14.00 13.40 0.80
innodb order_by_big_key_desc 15.00 +3.85% 0.60
14.00 17.00 15.60 1.02
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 13.00 -1.56% -0.20
12.00 13.00 12.80 0.40
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 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb order_by_range 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb outer_join 22.00 +4.35% 1.00
22.00 24.00 23.00 0.89
innodb outer_join_found 22.00 -0.00% 0.00
21.00 23.00 22.00 0.63
innodb outer_join_not_found 19.00 +3.06% 0.60
19.00 20.00 19.60 0.49
innodb outer_join_on_key 15.00 +1.32% 0.20
14.00 16.00 15.20 0.75
innodb prepared_select 37.00 +1.07% 0.40
37.00 38.00 37.40 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 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_big 14.00 -9.38% -1.20
12.00 14.00 12.80 0.98
innodb select_big_str 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_cache 69.00 -7.81% -5.00
60.00 69.00 64.00 3.74
innodb select_cache2 61.00 +0.97% 0.60
59.00 67.00 61.60 2.80
innodb select_column+column 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb select_diff_key 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb select_distinct 5.00 -19.05% -0.80
4.00 5.00 4.20 0.40
innodb select_group 15.00 +11.76% 2.00
15.00 19.00 17.00 1.67
innodb select_group_when_MANY_tables 12.00 +3.23% 0.40
12.00 14.00 12.40 0.80
innodb select_join 0.00 +100.00% 0.80
0.00 1.00 0.80 0.40
innodb select_key 64.00 -0.00% 0.00
63.00 65.00 64.00 0.63
innodb select_key2 72.00 -1.12% -0.80
70.00 72.00 71.20 0.75
innodb select_key2_return_key 68.00 +0.58% 0.40
67.00 69.00 68.40 0.80
innodb select_key2_return_prim 70.00 -0.86% -0.60
68.00 70.00 69.40 0.80
innodb select_key_prefix 71.00 -0.28% -0.20
70.00 71.00 70.80 0.40
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 -1.27% -0.80
62.00 64.00 63.20 0.75
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 44.00 -7.32% -3.00
39.00 44.00 41.00 2.10
innodb select_range_key2 10.00 -4.17% -0.40
9.00 10.00 9.60 0.49
innodb select_range_prefix 9.00 +2.17% 0.20
8.00 10.00 9.20 0.75
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 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb update_big 58.00 +1.69% 1.00
57.00 61.00 59.00 1.41
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 23.00 -1.77% -0.40
22.00 23.00 22.60 0.49
innodb update_of_key_big 37.00 +0.54% 0.20
34.00 39.00 37.20 1.72
innodb update_of_primary_key_many_keys 1304.00 +1.35% 17.80
1219.00 1455.00 1321.80 76.67
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 119.00 +1.49% 1.80
119.00 125.00 120.80 2.23
innodb update_with_key_prefix 43.00 +3.15% 1.40
43.00 49.00 44.40 2.33
innodb wisc_benchmark 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -0.00% 0.00
31.00 35.00 33.00 1.10
innodb alter_table_drop 24.00 -0.21% -0.05
23.00 26.00 23.95 1.07
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 -13.21% -0.35
2.00 3.00 2.65 0.48
innodb count 17.00 -9.68% -1.50
13.00 18.00 15.50 2.06
innodb count_distinct 6.00 +6.25% 0.40
6.00 8.00 6.40 0.58
innodb count_distinct_2 14.00 -1.45% -0.20
12.00 16.00 13.80 1.17
innodb count_distinct_big 25.00 -10.13% -2.30
20.00 25.00 22.70 2.05
innodb count_distinct_group 13.00 +10.34% 1.50
12.00 15.00 14.50 0.87
innodb count_distinct_group_on_key 9.00 +9.55% 0.95
8.00 12.00 9.95 0.97
innodb count_distinct_group_on_key_parts 12.00 +10.45% 1.40
12.00 15.00 13.40 0.80
innodb count_distinct_key_prefix 5.00 +4.76% 0.25
4.00 6.00 5.25 0.54
innodb count_group_on_key_parts 11.00 -0.00% 0.00
10.00 12.00 11.00 0.55
innodb count_on_key 93.00 +1.95% 1.85
92.00 105.00 94.85 3.18
innodb create+drop 34.00 -3.19% -1.05
32.00 34.00 32.95 0.80
innodb create_index 3.00 +9.09% 0.30
2.00 4.00 3.30 0.56
innodb create_key+drop 30.00 +4.00% 1.25
29.00 33.00 31.25 1.09
innodb create_MANY_tables 20.00 +4.08% 0.85
20.00 23.00 20.85 0.91
innodb create_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb delete_all_many_keys 621.00 +4.58% 29.80
574.00 714.00 650.80 34.18
innodb delete_autocommit 4.00 -6.67% -0.25
3.00 5.00 3.75 0.62
innodb delete_big 1.00 -53.85% -0.35
0.00 1.00 0.65 0.48
innodb delete_big_many_keys 620.00 +4.60% 29.90
573.00 713.00 649.90 34.16
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 9.00 +0.55% 0.05
8.00 10.00 9.05 0.74
innodb delete_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb drop_index 3.00 -0.00% 0.00
2.00 4.00 3.00 0.45
innodb drop_table_when_MANY_tables 19.00 -2.98% -0.55
16.00 21.00 18.45 1.16
innodb insert 113.00 +0.70% 0.80
112.00 117.00 113.80 1.21
innodb insert_autocommit 3.00 +9.09% 0.30
3.00 4.00 3.30 0.46
innodb insert_commit 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb insert_duplicates 19.00 +0.52% 0.10
19.00 20.00 19.10 0.30
innodb insert_key 275.00 +2.08% 5.85
255.00 304.00 280.85 12.29
innodb insert_many_fields 6.00 -2.56% -0.15
5.00 7.00 5.85 0.57
innodb insert_rollback 2.00 +2.44% 0.05
1.00 3.00 2.05 0.38
innodb insert_select_1_key 3.00 +22.08% 0.85
3.00 5.00 3.85 0.48
innodb insert_select_2_keys 6.00 -1.69% -0.10
5.00 7.00 5.90 0.44
innodb min_max 8.00 -1.91% -0.15
6.00 9.00 7.85 0.96
innodb min_max_on_key 25.00 -1.42% -0.35
24.00 26.00 24.65 0.57
innodb multiple_value_insert 8.00 -21.21% -1.40
5.00 8.00 6.60 0.86
innodb once_prepared_select 29.00 +0.68% 0.20
29.00 30.00 29.20 0.40
innodb order_by_big 13.00 +10.34% 1.50
13.00 16.00 14.50 1.32
innodb order_by_big_key 14.00 +5.08% 0.75
13.00 16.00 14.75 1.18
innodb order_by_big_key2 14.00 -5.66% -0.75
11.00 15.00 13.25 0.99
innodb order_by_big_key_desc 15.00 +1.32% 0.20
13.00 17.00 15.20 1.17
innodb order_by_big_key_diff 13.00 +0.76% 0.10
11.00 15.00 13.10 0.99
innodb order_by_big_key_prefix 13.00 +0.38% 0.05
12.00 15.00 13.05 0.67
innodb order_by_key2_diff 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb order_by_key_prefix 1.00 -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 22.00 +2.22% 0.50
17.00 25.00 22.50 2.09
innodb outer_join_found 22.00 -1.62% -0.35
17.00 25.00 21.65 2.03
innodb outer_join_not_found 19.00 +2.56% 0.50
15.00 22.00 19.50 1.72
innodb outer_join_on_key 15.00 +0.66% 0.10
12.00 17.00 15.10 1.45
innodb prepared_select 37.00 +1.07% 0.40
37.00 38.00 37.40 0.49
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 4.00 -8.11% -0.30
3.00 4.00 3.70 0.46
innodb select_big 14.00 -7.28% -0.95
11.00 14.00 13.05 0.92
innodb select_big_str 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
innodb select_cache 69.00 -9.96% -6.25
57.00 69.00 62.75 3.86
innodb select_cache2 61.00 +0.49% 0.30
56.00 67.00 61.30 2.61
innodb select_column+column 3.00 +15.49% 0.55
3.00 4.00 3.55 0.50
innodb select_diff_key 1.00 -185.71% -0.65
0.00 1.00 0.35 0.48
innodb select_distinct 5.00 -12.36% -0.55
4.00 5.00 4.45 0.50
innodb select_group 15.00 +14.53% 2.55
15.00 19.00 17.55 1.20
innodb select_group_when_MANY_tables 12.00 +2.04% 0.25
11.00 14.00 12.25 0.83
innodb select_join 0.00 +100.00% 0.65
0.00 1.00 0.65 0.48
innodb select_key 64.00 -0.23% -0.15
63.00 65.00 63.85 0.65
innodb select_key2 72.00 -1.48% -1.05
69.00 73.00 70.95 1.16
innodb select_key2_return_key 68.00 +0.58% 0.40
67.00 71.00 68.40 0.97
innodb select_key2_return_prim 70.00 -1.38% -0.95
68.00 71.00 69.05 0.97
innodb select_key_prefix 71.00 -0.57% -0.40
69.00 72.00 70.60 0.92
innodb select_key_prefix_join 5.00 +1.96% 0.10
5.00 6.00 5.10 0.30
innodb select_key_return_key 64.00 -1.75% -1.10
62.00 65.00 62.90 0.83
innodb select_many_fields 13.00 +1.14% 0.15
12.00 15.00 13.15 0.57
innodb select_range 44.00 -6.80% -2.80
38.00 47.00 41.20 2.48
innodb select_range_key2 10.00 -6.95% -0.65
8.00 10.00 9.35 0.57
innodb select_range_prefix 9.00 +4.26% 0.40
8.00 10.00 9.40 0.66
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 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb update_autocommit 3.00 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb update_big 58.00 +1.86% 1.10
57.00 63.00 59.10 1.84
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 23.00 -2.91% -0.65
21.00 24.00 22.35 0.79
innodb update_of_key_big 37.00 -4.67% -1.65
29.00 46.00 35.35 3.93
innodb update_of_primary_key_many_keys 1304.00 +3.25% 43.80
1219.00 1489.00 1347.80 70.89
innodb update_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb update_with_key 119.00 +2.46% 3.00
117.00 128.00 122.00 2.77
innodb update_with_key_prefix 43.00 +4.34% 1.95
40.00 49.00 44.95 2.48
innodb wisc_benchmark 2.00 +14.89% 0.35
2.00 3.00 2.35 0.48
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -57.89% -12.10
11.00 61.00 20.90 10.08
innodb alter_table_drop 24.00 -31.00% -5.68
10.00 57.00 18.32 6.98
innodb connect 2.00 +3.85% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -11.21% -0.30
2.00 5.00 2.70 0.47
innodb connect+select_simple 3.00 -28.14% -0.66
1.00 3.00 2.34 0.48
innodb count 17.00 -7.94% -1.25
12.00 193.00 15.75 8.88
innodb count_distinct 6.00 +8.55% 0.56
5.00 50.00 6.56 2.29
innodb count_distinct_2 14.00 -6.27% -0.83
11.00 63.00 13.17 2.96
innodb count_distinct_big 25.00 -14.01% -3.07
5.00 67.00 21.93 3.03
innodb count_distinct_group 13.00 +1.00% 0.13
10.00 68.00 13.13 3.10
innodb count_distinct_group_on_key 9.00 +5.14% 0.49
7.00 69.00 9.49 3.03
innodb count_distinct_group_on_key_parts 12.00 +2.51% 0.31
9.00 72.00 12.31 3.17
innodb count_distinct_key_prefix 5.00 +2.41% 0.12
3.00 52.00 5.12 2.40
innodb count_group_on_key_parts 11.00 -10.36% -1.03
7.00 72.00 9.97 3.17
innodb count_on_key 93.00 -8.27% -7.10
68.00 107.00 85.90 7.37
innodb create+drop 34.00 -4.87% -1.58
18.00 75.00 32.42 11.96
innodb create_index 3.00 -4.04% -0.12
1.00 8.00 2.88 1.15
innodb create_key+drop 30.00 -6.57% -1.85
21.00 50.00 28.15 4.92
innodb create_MANY_tables 20.00 +41.57% 14.23
14.00 121.00 34.23 17.14
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.36
innodb delete_all_many_keys 621.00 -34.52% -159.35
212.00 1888.00 461.65 366.50
innodb delete_autocommit 4.00 -16.26% -0.56
2.00 14.00 3.44 0.75
innodb delete_big 1.00 -245.12% -0.71
0.00 3.00 0.29 0.47
innodb delete_big_many_keys 620.00 -32.52% -152.14
212.00 2293.00 467.86 380.87
innodb delete_commit 2.00 -32.66% -0.49
1.00 5.00 1.51 0.53
innodb delete_key 3.00 +2.04% 0.06
2.00 35.00 3.06 1.50
innodb delete_range 9.00 -8.39% -0.70
5.00 23.00 8.30 3.26
innodb delete_rollback 2.00 -15.43% -0.27
1.00 12.00 1.73 0.92
innodb drop_index 3.00 -1.72% -0.05
1.00 9.00 2.95 1.33
innodb drop_table 0.00 +100.00% 0.04
0.00 2.00 0.04 0.23
innodb drop_table_when_MANY_tables 19.00 +2.99% 0.59
11.00 90.00 19.59 7.58
innodb insert 113.00 -6.00% -6.39
3.00 343.00 106.61 14.67
innodb insert_autocommit 3.00 -0.04% 0.00
2.00 99.00 3.00 3.34
innodb insert_commit 2.00 -45.88% -0.63
1.00 3.00 1.37 0.49
innodb insert_duplicates 19.00 -23.30% -3.59
11.00 21.00 15.41 2.63
innodb insert_key 275.00 +9.39% 28.48
142.00 700.00 303.48 107.81
innodb insert_many_fields 6.00 -7.12% -0.40
3.00 17.00 5.60 1.78
innodb insert_rollback 2.00 -20.43% -0.34
1.00 3.00 1.66 0.53
innodb insert_select_1_key 3.00 +20.62% 0.78
2.00 10.00 3.78 0.89
innodb insert_select_2_keys 6.00 +1.09% 0.07
4.00 16.00 6.07 2.10
innodb min_max 8.00 -2.25% -0.18
6.00 110.00 7.82 4.57
innodb min_max_on_key 25.00 -22.05% -4.52
14.00 37.00 20.48 3.07
innodb multiple_value_insert 8.00 -46.94% -2.56
2.00 50.00 5.44 4.31
innodb once_prepared_select 29.00 -20.16% -4.87
18.00 32.00 24.13 3.54
innodb order_by_big 13.00 +9.13% 1.31
12.00 31.00 14.31 1.54
innodb order_by_big_key 14.00 -5.54% -0.73
11.00 32.00 13.27 1.64
innodb order_by_big_key2 14.00 -14.89% -1.81
10.00 33.00 12.19 1.55
innodb order_by_big_key_desc 15.00 -11.28% -1.52
11.00 32.00 13.48 1.68
innodb order_by_big_key_diff 13.00 -6.42% -0.78
10.00 31.00 12.22 1.51
innodb order_by_big_key_prefix 13.00 -4.97% -0.62
10.00 32.00 12.38 1.56
innodb order_by_key2_diff 1.00 +28.44% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -26.76% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -20.45% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 22.00 -13.88% -2.68
15.00 61.00 19.32 3.73
innodb outer_join_found 22.00 -17.36% -3.25
14.00 58.00 18.75 3.59
innodb outer_join_not_found 19.00 -15.62% -2.57
12.00 46.00 16.43 3.17
innodb outer_join_on_key 15.00 -16.36% -2.11
10.00 59.00 12.89 2.78
innodb prepared_select 37.00 -18.48% -5.77
22.00 40.00 31.23 4.48
innodb select_1_row 3.00 -5.55% -0.16
2.00 4.00 2.84 0.69
innodb select_1_row_cache 4.00 -50.04% -1.33
2.00 4.00 2.67 0.68
innodb select_2_rows 4.00 -39.52% -1.13
2.00 4.00 2.87 0.70
innodb select_big 14.00 -15.20% -1.85
0.00 31.00 12.15 1.55
innodb select_big_str 2.00 -72.12% -0.84
0.00 2.00 1.16 0.37
innodb select_cache 69.00 -15.84% -9.43
49.00 77.00 59.57 5.63
innodb select_cache2 61.00 -1.79% -1.07
49.00 75.00 59.93 6.30
innodb select_column+column 3.00 -3.11% -0.09
2.00 4.00 2.91 0.71
innodb select_diff_key 1.00 -355.91% -0.78
0.00 1.00 0.22 0.41
innodb select_distinct 5.00 -18.15% -0.77
3.00 8.00 4.23 0.54
innodb select_group 15.00 +7.81% 1.27
4.00 136.00 16.27 5.47
innodb select_group_when_MANY_tables 12.00 -27.31% -2.57
3.00 49.00 9.43 9.52
innodb select_join 0.00 +100.00% 0.58
0.00 1.00 0.58 0.49
innodb select_key 64.00 -21.73% -11.42
40.00 66.00 52.58 7.37
innodb select_key2 72.00 -21.50% -12.74
45.00 75.00 59.26 8.23
innodb select_key2_return_key 68.00 -20.17% -11.41
42.00 71.00 56.59 8.02
innodb select_key2_return_prim 70.00 -22.07% -12.66
42.00 72.00 57.34 8.17
innodb select_key_prefix 71.00 -21.35% -12.49
44.00 75.00 58.51 8.25
innodb select_key_prefix_join 5.00 -6.06% -0.29
3.00 10.00 4.71 0.65
innodb select_key_return_key 64.00 -24.02% -12.40
38.00 65.00 51.60 7.38
innodb select_many_fields 13.00 +13.16% 1.97
11.00 19.00 14.97 1.79
innodb select_range 44.00 +6.61% 3.11
38.00 76.00 47.11 3.99
innodb select_range_key2 10.00 -21.40% -1.76
6.00 11.00 8.24 1.04
innodb select_range_prefix 9.00 -15.13% -1.18
5.00 10.00 7.82 1.11
innodb select_simple 2.00 -21.86% -0.36
1.00 3.00 1.64 0.51
innodb select_simple_cache 2.00 -29.28% -0.45
1.00 3.00 1.55 0.51
innodb select_simple_join 1.00 -53.15% -0.35
0.00 3.00 0.65 0.48
innodb update_autocommit 3.00 +9.78% 0.33
2.00 16.00 3.33 1.02
innodb update_big 58.00 -14.03% -7.14
31.00 195.00 50.86 24.63
innodb update_commit 2.00 -28.54% -0.44
1.00 10.00 1.56 0.73
innodb update_of_key 23.00 +5.19% 1.26
18.00 100.00 24.26 6.21
innodb update_of_key_big 37.00 -35.46% -9.69
15.00 75.00 27.31 10.98
innodb update_of_primary_key_many_keys 1304.00 -5.29% -65.50
647.00 6065.00 1238.50 968.39
innodb update_rollback 2.00 -13.96% -0.24
1.00 31.00 1.76 1.91
innodb update_with_key 119.00 -8.49% -9.31
90.00 598.00 109.69 20.90
innodb update_with_key_prefix 43.00 -8.70% -3.44
33.00 202.00 39.56 6.84
innodb wisc_benchmark 2.00 +19.07% 0.47
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2194.1.3: Lee Bieber 2011-02-23 [merge] Merge Stewart - 676770: Error log
logging 'Sort aborted' messages when DML fails with ER_INVALID_ENUM_VALUE
2077.4.11: Stewart Smith 2011-02-23 if empty file, we get NULL - which we
should get
2077.4.10: Stewart Smith 2011-02-23 [merge] Merge trunk
2077.4.9: Stewart Smith 2011-02-14 don't save the CURRENT_TEST line from
the errlog to the enum_errlog file in bug 676770 regression test as running the
test twice in a row means we get two of the CURRENT_TEST lines
2077.4.8: Stewart Smith 2011-02-14 fix regression.676770 test so that it
does really look for ONLY what we're looking for.
2077.4.7: Stewart Smith 2011-02-10 fix up regression.676770 test for
updated trunk: no error numbers in test case and no DDL in txns
2077.4.6: Stewart Smith 2011-02-10 [merge] merge trunk
2077.4.5: Stewart Smith 2011-01-18 check for a return code that would mean
we have something that's impossible and set this in the optimiser tree instead
of continuing to try and execute the query with an impossible search condition.
2077.4.4: Stewart Smith 2011-01-17 slightly improve 676770 regression test
2077.4.3: Stewart Smith 2011-01-17 [merge] merge trunk
2077.4.2: Stewart Smith 2011-01-14 modify regression test for bug 676770 so
that it'll pass when the bug is fixed
2077.4.1: Stewart Smith 2011-01-13 add regression test for bug 676770: sort
aborted logged for a bad enum value
2194.1.2: Lee Bieber 2011-02-23 [merge] Merge Olaf - Use Item_equal::begin()
and Use List::size()
2183.2.17: Olaf van der Spek 2011-02-23 Use List::size()
2183.2.16: Olaf van der Spek 2011-02-23 typedef List<Item_field>::iterator
Item_equal_iterator;
2183.2.15: Olaf van der Spek 2011-02-22 [merge] Merge trunk
2194.1.1: Lee Bieber 2011-02-23 [merge] Merge Olaf - Delete drizzled/strfunc.h
2192.3.1: Olaf van der Spek 2011-02-22 Delete drizzled/strfunc.h
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
