=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 899
RUN DATE: 2011-02-15T20:36:53.384464
SERVER: drizzled
VERSION: staging
REVISION: 2172
COMMENT: 2172: Brian Aker 2011-02-15 [merge] Merge of all fixes related to
errors, schemas, etc.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 31.00 +3.73% 1.20
31.00 34.00 32.20 0.98
innodb alter_table_drop 23.00 +3.36% 0.80
23.00 25.00 23.80 0.75
innodb connect 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb connect+select_1_row 3.00 -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 +18.75% 3.00
13.00 18.00 16.00 2.10
innodb count_distinct 6.00 +11.76% 0.80
6.00 7.00 6.80 0.40
innodb count_distinct_2 13.00 +7.14% 1.00
12.00 16.00 14.00 1.41
innodb count_distinct_big 21.00 +5.41% 1.20
21.00 24.00 22.20 1.47
innodb count_distinct_group 15.00 -5.63% -0.80
12.00 15.00 14.20 1.17
innodb count_distinct_group_on_key 10.00 -0.00% 0.00
9.00 11.00 10.00 0.89
innodb count_distinct_group_on_key_parts 14.00 -4.48% -0.60
11.00 15.00 13.40 1.36
innodb count_distinct_key_prefix 6.00 -3.45% -0.20
5.00 7.00 5.80 0.75
innodb count_group_on_key_parts 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_on_key 92.00 +1.29% 1.20
92.00 96.00 93.20 1.47
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 30.00 -0.00% 0.00
29.00 32.00 30.00 1.10
innodb create_MANY_tables 21.00 -1.94% -0.40
20.00 21.00 20.60 0.49
innodb create_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 648.00 +0.74% 4.80
624.00 716.00 652.80 32.54
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 647.00 +0.77% 5.00
623.00 715.00 652.00 32.43
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb delete_range 10.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 4.00 -17.65% -0.60
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 114.00 +0.35% 0.40
114.00 115.00 114.40 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 -1.06% -0.20
18.00 19.00 18.80 0.40
innodb insert_key 276.00 +1.29% 3.60
274.00 297.00 279.60 8.73
innodb insert_many_fields 6.00 -7.14% -0.40
5.00 6.00 5.60 0.49
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb insert_select_2_keys 6.00 +3.23% 0.20
6.00 7.00 6.20 0.40
innodb min_max 7.00 +14.63% 1.20
7.00 9.00 8.20 0.98
innodb min_max_on_key 25.00 -0.81% -0.20
24.00 26.00 24.80 0.75
innodb multiple_value_insert 7.00 -6.06% -0.40
6.00 7.00 6.60 0.49
innodb once_prepared_select 29.00 +1.36% 0.40
29.00 30.00 29.40 0.49
innodb order_by_big 16.00 -5.26% -0.80
13.00 16.00 15.20 1.17
innodb order_by_big_key 14.00 +1.41% 0.20
12.00 16.00 14.20 1.33
innodb order_by_big_key2 12.00 +7.69% 1.00
12.00 14.00 13.00 0.89
innodb order_by_big_key_desc 14.00 +5.41% 0.80
14.00 16.00 14.80 0.75
innodb order_by_big_key_diff 12.00 +6.25% 0.80
12.00 14.00 12.80 0.75
innodb order_by_big_key_prefix 13.00 +2.99% 0.40
12.00 14.00 13.40 0.80
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 -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 22.00 +5.17% 1.20
19.00 26.00 23.20 2.48
innodb outer_join_found 21.00 +6.25% 1.40
18.00 25.00 22.40 2.65
innodb outer_join_not_found 19.00 +6.86% 1.40
18.00 22.00 20.40 1.62
innodb outer_join_on_key 14.00 +9.09% 1.40
13.00 17.00 15.40 1.62
innodb prepared_select 37.00 +1.07% 0.40
37.00 38.00 37.40 0.49
innodb select_1_row 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb select_1_row_cache 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_2_rows 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb select_big 13.00 -1.56% -0.20
12.00 14.00 12.80 0.75
innodb select_big_str 2.00 -66.67% -0.80
1.00 2.00 1.20 0.40
innodb select_cache 62.00 +6.06% 4.00
62.00 70.00 66.00 3.03
innodb select_cache2 60.00 +5.66% 3.60
60.00 69.00 63.60 3.01
innodb select_column+column 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_diff_key 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb select_distinct 4.00 +9.09% 0.40
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 +5.17% 0.60
11.00 13.00 11.60 0.80
innodb select_join 0.00 +100.00% 0.60
0.00 1.00 0.60 0.49
innodb select_key 64.00 +0.62% 0.40
64.00 66.00 64.40 0.80
innodb select_key2 72.00 -0.00% 0.00
71.00 73.00 72.00 0.63
innodb select_key2_return_key 69.00 -0.29% -0.20
68.00 71.00 68.80 1.17
innodb select_key2_return_prim 70.00 -0.00% 0.00
69.00 71.00 70.00 0.63
innodb select_key_prefix 71.00 +0.28% 0.20
70.00 73.00 71.20 0.98
innodb select_key_prefix_join 6.00 -15.38% -0.80
5.00 6.00 5.20 0.40
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 +2.99% 0.40
13.00 14.00 13.40 0.49
innodb select_range 39.00 +5.80% 2.40
39.00 45.00 41.40 2.06
innodb select_range_key2 9.00 +6.25% 0.60
9.00 10.00 9.60 0.49
innodb select_range_prefix 10.00 -6.38% -0.60
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 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb update_autocommit 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb update_big 58.00 +1.36% 0.80
57.00 61.00 58.80 1.33
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 35.00 +0.57% 0.20
29.00 38.00 35.20 3.25
innodb update_of_primary_key_many_keys 1314.00 +2.22% 29.80
1297.00 1457.00 1343.80 57.80
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 122.00 +0.33% 0.40
122.00 124.00 122.40 0.80
innodb update_with_key_prefix 43.00 +2.27% 1.00
43.00 48.00 44.00 2.00
innodb wisc_benchmark 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 31.00 +4.32% 1.40
31.00 34.00 32.40 0.73
innodb alter_table_drop 23.00 +3.77% 0.90
23.00 25.00 23.90 0.70
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 13.00 +15.03% 2.30
13.00 18.00 15.30 1.87
innodb count_distinct 6.00 +10.45% 0.70
6.00 8.00 6.70 0.64
innodb count_distinct_2 13.00 +5.11% 0.70
12.00 16.00 13.70 1.14
innodb count_distinct_big 21.00 +6.67% 1.50
20.00 25.00 22.50 1.53
innodb count_distinct_group 15.00 -4.53% -0.65
11.00 16.00 14.35 1.24
innodb count_distinct_group_on_key 10.00 +3.85% 0.40
8.00 17.00 10.40 2.20
innodb count_distinct_group_on_key_parts 14.00 -5.26% -0.70
11.00 15.00 13.30 1.05
innodb count_distinct_key_prefix 6.00 -12.15% -0.65
4.00 7.00 5.35 0.73
innodb count_group_on_key_parts 11.00 -0.46% -0.05
10.00 12.00 10.95 0.38
innodb count_on_key 92.00 +1.76% 1.65
91.00 97.00 93.65 1.77
innodb create+drop 32.00 -0.47% -0.15
30.00 34.00 31.85 1.15
innodb create_index 3.00 +3.23% 0.10
2.00 4.00 3.10 0.44
innodb create_key+drop 30.00 -2.21% -0.65
28.00 32.00 29.35 0.91
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 648.00 +1.88% 12.40
569.00 738.00 660.40 46.49
innodb delete_autocommit 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb delete_big 0.00 +100.00% 0.45
0.00 1.00 0.45 0.50
innodb delete_big_many_keys 647.00 +1.90% 12.50
569.00 737.00 659.50 46.41
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 10.00 -14.94% -1.30
7.00 10.00 8.70 0.78
innodb delete_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb drop_index 4.00 -23.08% -0.75
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 114.00 +0.26% 0.30
112.00 116.00 114.30 0.95
innodb insert_autocommit 3.00 +7.69% 0.25
3.00 4.00 3.25 0.43
innodb insert_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb insert_duplicates 19.00 +0.52% 0.10
18.00 20.00 19.10 0.54
innodb insert_key 276.00 +2.51% 7.10
266.00 302.00 283.10 12.05
innodb insert_many_fields 6.00 -4.35% -0.25
5.00 6.00 5.75 0.43
innodb insert_rollback 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb insert_select_1_key 4.00 -2.56% -0.10
3.00 5.00 3.90 0.62
innodb insert_select_2_keys 6.00 +5.51% 0.35
4.00 8.00 6.35 0.85
innodb min_max 7.00 +10.26% 0.80
6.00 9.00 7.80 0.98
innodb min_max_on_key 25.00 -2.25% -0.55
24.00 26.00 24.45 0.59
innodb multiple_value_insert 7.00 -6.06% -0.40
5.00 8.00 6.60 0.73
innodb once_prepared_select 29.00 +0.85% 0.25
29.00 30.00 29.25 0.43
innodb order_by_big 16.00 -10.73% -1.55
13.00 16.00 14.45 1.20
innodb order_by_big_key 14.00 +3.78% 0.55
12.00 17.00 14.55 1.24
innodb order_by_big_key2 12.00 +7.34% 0.95
12.00 14.00 12.95 0.67
innodb order_by_big_key_desc 14.00 +8.20% 1.25
14.00 16.00 15.25 0.70
innodb order_by_big_key_diff 12.00 +7.69% 1.00
12.00 14.00 13.00 0.77
innodb order_by_big_key_prefix 13.00 +3.70% 0.50
12.00 14.00 13.50 0.67
innodb order_by_key2_diff 1.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 22.00 +1.12% 0.25
17.00 26.00 22.25 3.08
innodb outer_join_found 21.00 +2.10% 0.45
16.00 25.00 21.45 3.06
innodb outer_join_not_found 19.00 -0.26% -0.05
14.00 22.00 18.95 2.78
innodb outer_join_on_key 14.00 +4.76% 0.70
11.00 18.00 14.70 2.22
innodb prepared_select 37.00 +0.40% 0.15
37.00 38.00 37.15 0.36
innodb select_1_row 3.00 +14.29% 0.50
3.00 4.00 3.50 0.50
innodb select_1_row_cache 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb select_2_rows 3.00 +15.49% 0.55
3.00 4.00 3.55 0.50
innodb select_big 13.00 -0.00% 0.00
12.00 15.00 13.00 0.89
innodb select_big_str 2.00 -60.00% -0.75
1.00 2.00 1.25 0.43
innodb select_cache 62.00 +2.44% 1.55
57.00 71.00 63.55 3.64
innodb select_cache2 60.00 +4.91% 3.10
60.00 69.00 63.10 2.34
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_diff_key 1.00 -233.33% -0.70
0.00 1.00 0.30 0.46
innodb select_distinct 4.00 +13.04% 0.60
4.00 5.00 4.60 0.49
innodb select_group 18.00 -4.96% -0.85
15.00 19.00 17.15 1.46
innodb select_group_when_MANY_tables 11.00 +9.84% 1.20
11.00 14.00 12.20 0.87
innodb select_join 0.00 +100.00% 0.65
0.00 1.00 0.65 0.48
innodb select_key 64.00 -0.47% -0.30
63.00 66.00 63.70 0.71
innodb select_key2 72.00 -1.19% -0.85
70.00 73.00 71.15 1.01
innodb select_key2_return_key 69.00 -0.73% -0.50
67.00 71.00 68.50 0.87
innodb select_key2_return_prim 70.00 -0.94% -0.65
68.00 71.00 69.35 0.85
innodb select_key_prefix 71.00 -0.35% -0.25
69.00 73.00 70.75 0.83
innodb select_key_prefix_join 6.00 -15.38% -0.80
5.00 6.00 5.20 0.40
innodb select_key_return_key 64.00 -1.59% -1.00
62.00 64.00 63.00 0.63
innodb select_many_fields 13.00 +1.89% 0.25
13.00 14.00 13.25 0.43
innodb select_range 39.00 +7.14% 3.00
39.00 49.00 42.00 2.49
innodb select_range_key2 9.00 +5.26% 0.50
9.00 10.00 9.50 0.50
innodb select_range_prefix 10.00 -7.53% -0.70
8.00 10.00 9.30 0.64
innodb select_simple 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb select_simple_cache 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -42.86% -0.30
0.00 1.00 0.70 0.46
innodb update_autocommit 4.00 -8.11% -0.30
3.00 4.00 3.70 0.46
innodb update_big 58.00 +2.19% 1.30
56.00 64.00 59.30 2.17
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 23.00 -3.37% -0.75
21.00 24.00 22.25 1.04
innodb update_of_key_big 35.00 +1.55% 0.55
29.00 47.00 35.55 3.73
innodb update_of_primary_key_many_keys 1314.00 +3.09% 41.95
1203.00 1472.00 1355.95 78.19
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 122.00 +0.20% 0.25
117.00 127.00 122.25 2.55
innodb update_with_key_prefix 43.00 +2.49% 1.10
40.00 50.00 44.10 2.49
innodb wisc_benchmark 3.00 -13.21% -0.35
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 31.00 -50.33% -10.38
11.00 61.00 20.62 10.02
innodb alter_table_drop 23.00 -26.43% -4.81
10.00 57.00 18.19 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.39% -0.31
2.00 5.00 2.69 0.48
innodb connect+select_simple 3.00 -28.51% -0.67
1.00 3.00 2.33 0.48
innodb count 13.00 +17.47% 2.75
12.00 193.00 15.75 8.97
innodb count_distinct 6.00 +8.59% 0.56
5.00 50.00 6.56 2.31
innodb count_distinct_2 13.00 +1.21% 0.16
11.00 63.00 13.16 2.99
innodb count_distinct_big 21.00 +4.14% 0.91
5.00 67.00 21.91 3.05
innodb count_distinct_group 15.00 -14.49% -1.90
10.00 68.00 13.10 3.13
innodb count_distinct_group_on_key 10.00 -5.52% -0.52
7.00 69.00 9.48 3.06
innodb count_distinct_group_on_key_parts 14.00 -13.97% -1.72
9.00 72.00 12.28 3.20
innodb count_distinct_key_prefix 6.00 -17.15% -0.88
3.00 52.00 5.12 2.43
innodb count_group_on_key_parts 11.00 -10.63% -1.06
7.00 72.00 9.94 3.20
innodb count_on_key 92.00 -7.37% -6.31
68.00 107.00 85.69 7.31
innodb create+drop 32.00 +1.26% 0.41
18.00 75.00 32.41 12.10
innodb create_index 3.00 -4.40% -0.13
1.00 8.00 2.87 1.15
innodb create_key+drop 30.00 -6.84% -1.92
21.00 50.00 28.08 4.95
innodb create_MANY_tables 21.00 +39.20% 13.54
14.00 121.00 34.54 17.21
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.37
innodb delete_all_many_keys 648.00 -41.77% -190.91
212.00 1888.00 457.09 369.65
innodb delete_autocommit 4.00 -16.49% -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 647.00 -39.59% -183.51
212.00 2293.00 463.49 384.31
innodb delete_commit 2.00 -33.33% -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 10.00 -20.67% -1.71
5.00 23.00 8.29 3.29
innodb delete_rollback 2.00 -16.00% -0.28
1.00 12.00 1.72 0.93
innodb drop_index 4.00 -35.62% -1.05
1.00 9.00 2.95 1.34
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.23
innodb drop_table_when_MANY_tables 16.00 +18.40% 3.61
11.00 90.00 19.61 7.66
innodb insert 114.00 -7.10% -7.56
3.00 343.00 106.44 14.79
innodb insert_autocommit 3.00 -0.28% -0.01
2.00 99.00 2.99 3.37
innodb insert_commit 2.00 -47.16% -0.64
1.00 3.00 1.36 0.49
innodb insert_duplicates 19.00 -23.98% -3.68
11.00 21.00 15.32 2.60
innodb insert_key 276.00 +9.23% 28.05
142.00 700.00 304.05 109.09
innodb insert_many_fields 6.00 -7.23% -0.40
3.00 17.00 5.60 1.80
innodb insert_rollback 2.00 -21.08% -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 6.00 +1.15% 0.07
4.00 16.00 6.07 2.13
innodb min_max 7.00 +10.52% 0.82
6.00 110.00 7.82 4.62
innodb min_max_on_key 25.00 -22.61% -4.61
14.00 37.00 20.39 3.04
innodb multiple_value_insert 7.00 -29.19% -1.58
2.00 50.00 5.42 4.36
innodb once_prepared_select 29.00 -20.74% -4.98
18.00 32.00 24.02 3.50
innodb order_by_big 16.00 -11.86% -1.70
12.00 31.00 14.30 1.54
innodb order_by_big_key 14.00 -5.82% -0.77
11.00 32.00 13.23 1.63
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 14.00 -4.17% -0.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 13.00 -5.10% -0.63
10.00 32.00 12.37 1.58
innodb order_by_key2_diff 1.00 +28.41% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -26.95% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -20.85% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 22.00 -14.32% -2.76
15.00 61.00 19.24 3.73
innodb outer_join_found 21.00 -12.43% -2.32
14.00 58.00 18.68 3.59
innodb outer_join_not_found 19.00 -16.12% -2.64
12.00 46.00 16.36 3.16
innodb outer_join_on_key 14.00 -9.04% -1.16
10.00 59.00 12.84 2.78
innodb prepared_select 37.00 -19.02% -5.91
22.00 40.00 31.09 4.43
innodb select_1_row 3.00 -6.09% -0.17
2.00 4.00 2.83 0.69
innodb select_1_row_cache 4.00 -51.16% -1.35
2.00 4.00 2.65 0.67
innodb select_2_rows 3.00 -5.37% -0.15
2.00 4.00 2.85 0.69
innodb select_big 13.00 -7.15% -0.87
0.00 31.00 12.13 1.56
innodb select_big_str 2.00 -73.59% -0.85
0.00 2.00 1.15 0.36
innodb select_cache 62.00 -4.21% -2.51
49.00 77.00 59.49 5.64
innodb select_cache2 60.00 -0.18% -0.11
49.00 75.00 59.89 6.36
innodb select_column+column 4.00 -38.15% -1.10
2.00 4.00 2.90 0.71
innodb select_diff_key 1.00 -360.56% -0.78
0.00 1.00 0.22 0.41
innodb select_distinct 4.00 +5.35% 0.23
3.00 8.00 4.23 0.54
innodb select_group 18.00 -10.82% -1.76
4.00 136.00 16.24 5.52
innodb select_group_when_MANY_tables 11.00 -17.52% -1.64
3.00 49.00 9.36 9.62
innodb select_join 0.00 +100.00% 0.58
0.00 1.00 0.58 0.49
innodb select_key 64.00 -22.33% -11.68
40.00 66.00 52.32 7.25
innodb select_key2 72.00 -22.05% -13.01
45.00 75.00 58.99 8.13
innodb select_key2_return_key 69.00 -22.52% -12.68
42.00 71.00 56.32 7.91
innodb select_key2_return_prim 70.00 -22.64% -12.92
42.00 72.00 57.08 8.06
innodb select_key_prefix 71.00 -21.93% -12.77
44.00 75.00 58.23 8.13
innodb select_key_prefix_join 6.00 -27.49% -1.29
3.00 10.00 4.71 0.66
innodb select_key_return_key 64.00 -24.65% -12.66
38.00 65.00 51.34 7.26
innodb select_many_fields 13.00 +13.40% 2.01
11.00 19.00 15.01 1.79
innodb select_range 39.00 +17.45% 8.25
39.00 76.00 47.25 3.92
innodb select_range_key2 9.00 -9.61% -0.79
6.00 11.00 8.21 1.03
innodb select_range_prefix 10.00 -28.51% -2.22
5.00 10.00 7.78 1.09
innodb select_simple 2.00 -22.57% -0.37
1.00 3.00 1.63 0.51
innodb select_simple_cache 2.00 -30.15% -0.46
1.00 3.00 1.54 0.52
innodb select_simple_join 1.00 -53.89% -0.35
0.00 3.00 0.65 0.48
innodb update_autocommit 4.00 -20.55% -0.68
2.00 16.00 3.32 1.02
innodb update_big 58.00 -14.46% -7.33
31.00 195.00 50.67 24.88
innodb update_commit 2.00 -29.28% -0.45
1.00 10.00 1.55 0.74
innodb update_of_key 23.00 +5.37% 1.30
18.00 100.00 24.30 6.27
innodb update_of_key_big 35.00 -29.01% -7.87
15.00 75.00 27.13 11.02
innodb update_of_primary_key_many_keys 1314.00 -6.38% -78.82
647.00 6065.00 1235.18 982.47
innodb update_rollback 2.00 -14.56% -0.25
1.00 31.00 1.75 1.93
innodb update_with_key 122.00 -11.51% -12.59
90.00 598.00 109.41 21.05
innodb update_with_key_prefix 43.00 -9.05% -3.57
33.00 202.00 39.43 6.86
innodb wisc_benchmark 3.00 -21.23% -0.53
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2171.1.3: Brian Aker 2011-02-15 Good old ICC, it found an error.
2171.1.2: Brian Aker 2011-02-15 Merge in change of test (ie not report host)
2171.1.1: Brian Aker 2011-02-15 [merge] Merge in schema/error fixes.
2170.1.1: Brian Aker 2011-02-15 [merge] Merge with trunk.
2159.2.8: Brian Aker 2011-02-14 Merge in fixes for error messages with
privs.
2159.2.7: Brian Aker 2011-02-14 Merge in shared ptr modification for auth
(namely we don't take the hit for
2159.2.6: Brian Aker 2011-02-14 Finalize interface for schema.
2159.2.5: Brian Aker 2011-02-13 Merge in move of schema.
2159.2.4: Brian Aker 2011-02-12 Merge in error wasteful removal.
2159.2.3: Brian Aker 2011-02-12 Remove dead call for getTableMessage()
2159.2.2: Brian Aker 2011-02-12 Remove additional spot where we passed in
a reference of a shared pointer.
2159.2.1: Brian Aker 2011-02-12 Remove the pass by reference, it really
wasn't a good choice.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
