=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 903
RUN DATE: 2011-02-17T13:18:28.249380
SERVER: drizzled
VERSION: staging
REVISION: 2179
COMMENT: 2179: Brian Aker 2011-02-17 [merge] Merge in all bison updates.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 +2.44% 0.80
31.00 34.00 32.80 1.17
innodb alter_table_drop 23.00 +2.54% 0.60
23.00 26.00 23.60 1.20
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 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
innodb count 18.00 -18.42% -2.80
13.00 18.00 15.20 1.94
innodb count_distinct 7.00 -6.06% -0.40
6.00 8.00 6.60 0.80
innodb count_distinct_2 15.00 -11.94% -1.60
12.00 15.00 13.40 1.36
innodb count_distinct_big 25.00 -11.61% -2.60
20.00 25.00 22.40 2.15
innodb count_distinct_group 15.00 -0.00% 0.00
15.00 15.00 15.00 0.00
innodb count_distinct_group_on_key 11.00 -7.84% -0.80
9.00 11.00 10.20 0.75
innodb count_distinct_group_on_key_parts 13.00 +2.99% 0.40
12.00 14.00 13.40 0.80
innodb count_distinct_key_prefix 5.00 +7.41% 0.40
5.00 6.00 5.40 0.49
innodb count_group_on_key_parts 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_on_key 96.00 -1.69% -1.60
92.00 98.00 94.40 2.33
innodb create+drop 33.00 -1.85% -0.60
32.00 33.00 32.40 0.49
innodb create_index 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb create_key+drop 33.00 -7.84% -2.40
29.00 33.00 30.60 1.36
innodb create_MANY_tables 21.00 +0.94% 0.20
21.00 22.00 21.20 0.40
innodb delete_all_many_keys 604.00 +8.54% 56.40
604.00 711.00 660.40 36.94
innodb delete_autocommit 3.00 +11.76% 0.40
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 603.00 +8.55% 56.40
603.00 710.00 659.40 36.94
innodb delete_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 8.00 +9.09% 0.80
8.00 10.00 8.80 0.75
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 4.00 2.80 0.75
innodb drop_table_when_MANY_tables 18.00 -3.45% -0.60
16.00 19.00 17.40 1.20
innodb insert 117.00 -1.92% -2.20
113.00 117.00 114.80 1.33
innodb insert_autocommit 4.00 -25.00% -0.80
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 -0.00% 0.00
19.00 19.00 19.00 0.00
innodb insert_key 265.00 +6.82% 19.40
265.00 304.00 284.40 15.34
innodb insert_many_fields 6.00 -3.45% -0.20
5.00 6.00 5.80 0.40
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb insert_select_2_keys 6.00 -3.45% -0.20
5.00 6.00 5.80 0.40
innodb min_max 9.00 -15.38% -1.20
7.00 9.00 7.80 0.98
innodb min_max_on_key 25.00 -2.46% -0.60
24.00 25.00 24.40 0.49
innodb multiple_value_insert 6.00 +9.09% 0.60
6.00 7.00 6.60 0.49
innodb once_prepared_select 29.00 +0.68% 0.20
29.00 30.00 29.20 0.40
innodb order_by_big 15.00 -2.74% -0.40
13.00 16.00 14.60 1.36
innodb order_by_big_key 16.00 -6.67% -1.00
13.00 16.00 15.00 1.26
innodb order_by_big_key2 15.00 -11.94% -1.60
12.00 15.00 13.40 1.20
innodb order_by_big_key_desc 16.00 -5.26% -0.80
14.00 16.00 15.20 0.98
innodb order_by_big_key_diff 14.00 -12.90% -1.60
11.00 14.00 12.40 1.02
innodb order_by_big_key_prefix 14.00 -7.69% -1.00
12.00 14.00 13.00 0.63
innodb order_by_key2_diff 1.00 +37.50% 0.60
1.00 2.00 1.60 0.49
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 19.00 +15.18% 3.40
19.00 24.00 22.40 1.85
innodb outer_join_found 18.00 +15.09% 3.20
18.00 23.00 21.20 1.72
innodb outer_join_not_found 17.00 +13.27% 2.60
17.00 21.00 19.60 1.50
innodb outer_join_on_key 13.00 +13.33% 2.00
13.00 16.00 15.00 1.26
innodb prepared_select 38.00 -1.60% -0.60
37.00 38.00 37.40 0.49
innodb select_1_row 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb select_1_row_cache 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_2_rows 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_big 14.00 -4.48% -0.60
13.00 14.00 13.40 0.49
innodb select_big_str 1.00 +37.50% 0.60
1.00 2.00 1.60 0.49
innodb select_cache 63.00 +1.56% 1.00
62.00 69.00 64.00 2.61
innodb select_cache2 61.00 +0.97% 0.60
60.00 64.00 61.60 1.62
innodb select_column+column 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_diff_key 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb select_distinct 5.00 -8.70% -0.40
4.00 5.00 4.60 0.49
innodb select_group 18.00 +1.10% 0.20
18.00 19.00 18.20 0.40
innodb select_group_when_MANY_tables 12.00 -0.00% 0.00
11.00 13.00 12.00 0.89
innodb select_join 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb select_key 65.00 -1.56% -1.00
63.00 65.00 64.00 0.89
innodb select_key2 72.00 -1.69% -1.20
69.00 72.00 70.80 1.47
innodb select_key2_return_key 69.00 -0.58% -0.40
67.00 71.00 68.60 1.50
innodb select_key2_return_prim 70.00 -0.86% -0.60
68.00 71.00 69.40 1.20
innodb select_key_prefix 71.00 -0.85% -0.60
69.00 72.00 70.40 1.20
innodb select_key_prefix_join 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb select_key_return_key 63.00 +0.63% 0.40
62.00 65.00 63.40 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 +0.49% 0.20
39.00 44.00 41.20 1.72
innodb select_range_key2 10.00 -6.38% -0.60
9.00 10.00 9.40 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 0.00 +100.00% 0.60
0.00 1.00 0.60 0.49
innodb update_autocommit 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb update_big 58.00 +2.03% 1.20
58.00 62.00 59.20 1.60
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 21.00 +3.67% 0.80
21.00 23.00 21.80 0.98
innodb update_of_key_big 30.00 +4.46% 1.40
29.00 35.00 31.40 2.06
innodb update_of_primary_key_many_keys 1242.00 +9.49% 130.20
1242.00 1489.00 1372.20 94.59
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 128.00 -3.56% -4.40
121.00 128.00 123.60 2.58
innodb update_with_key_prefix 47.00 -5.38% -2.40
42.00 47.00 44.60 2.06
innodb wisc_benchmark 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 +1.84% 0.60
31.00 34.00 32.60 0.86
innodb alter_table_drop 23.00 +3.56% 0.85
23.00 26.00 23.85 0.91
innodb connect 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb connect+select_1_row 3.00 -3.45% -0.10
2.00 3.00 2.90 0.30
innodb connect+select_simple 2.00 +25.93% 0.70
2.00 3.00 2.70 0.46
innodb count 18.00 -16.13% -2.50
13.00 18.00 15.50 1.94
innodb count_distinct 7.00 -2.19% -0.15
6.00 8.00 6.85 0.65
innodb count_distinct_2 15.00 -8.70% -1.20
12.00 16.00 13.80 1.25
innodb count_distinct_big 25.00 -10.38% -2.35
20.00 25.00 22.65 1.68
innodb count_distinct_group 15.00 -3.81% -0.55
11.00 16.00 14.45 1.16
innodb count_distinct_group_on_key 11.00 -3.77% -0.40
9.00 17.00 10.60 2.11
innodb count_distinct_group_on_key_parts 13.00 +2.62% 0.35
11.00 15.00 13.35 1.11
innodb count_distinct_key_prefix 5.00 +5.66% 0.30
4.00 7.00 5.30 0.71
innodb count_group_on_key_parts 11.00 -0.00% 0.00
10.00 12.00 11.00 0.32
innodb count_on_key 96.00 -2.24% -2.10
91.00 98.00 93.90 2.00
innodb create+drop 33.00 -2.80% -0.90
30.00 34.00 32.10 1.04
innodb create_index 3.00 +3.23% 0.10
2.00 4.00 3.10 0.44
innodb create_key+drop 33.00 -11.49% -3.40
28.00 33.00 29.60 1.24
innodb create_MANY_tables 21.00 -2.19% -0.45
19.00 22.00 20.55 0.74
innodb create_table 0.00 +100.00% 0.15
0.00 1.00 0.15 0.36
innodb delete_all_many_keys 604.00 +8.72% 57.70
583.00 738.00 661.70 42.57
innodb delete_autocommit 3.00 +15.49% 0.55
3.00 4.00 3.55 0.50
innodb delete_big 0.00 +100.00% 0.35
0.00 1.00 0.35 0.48
innodb delete_big_many_keys 603.00 +8.74% 57.75
582.00 737.00 660.75 42.59
innodb delete_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb delete_key 3.00 -5.26% -0.15
2.00 3.00 2.85 0.36
innodb delete_range 8.00 +6.98% 0.60
7.00 10.00 8.60 0.73
innodb delete_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb drop_index 3.00 +4.76% 0.15
2.00 4.00 3.15 0.57
innodb drop_table_when_MANY_tables 18.00 -9.42% -1.55
15.00 19.00 16.45 1.02
innodb insert 117.00 -2.14% -2.45
112.00 117.00 114.55 1.12
innodb insert_autocommit 4.00 -23.08% -0.75
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.26% 0.05
18.00 20.00 19.05 0.50
innodb insert_key 265.00 +6.61% 18.75
265.00 304.00 283.75 13.11
innodb insert_many_fields 6.00 -5.26% -0.30
5.00 6.00 5.70 0.46
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -3.90% -0.15
3.00 5.00 3.85 0.57
innodb insert_select_2_keys 6.00 +4.00% 0.25
4.00 8.00 6.25 0.89
innodb min_max 9.00 -13.92% -1.10
6.00 9.00 7.90 0.99
innodb min_max_on_key 25.00 -2.25% -0.55
24.00 26.00 24.45 0.59
innodb multiple_value_insert 6.00 +9.77% 0.65
5.00 8.00 6.65 0.73
innodb once_prepared_select 29.00 +1.02% 0.30
29.00 30.00 29.30 0.46
innodb order_by_big 15.00 -4.53% -0.65
13.00 16.00 14.35 1.24
innodb order_by_big_key 16.00 -8.47% -1.25
12.00 17.00 14.75 1.34
innodb order_by_big_key2 15.00 -14.07% -1.85
12.00 15.00 13.15 0.85
innodb order_by_big_key_desc 16.00 -5.26% -0.80
14.00 16.00 15.20 0.75
innodb order_by_big_key_diff 14.00 -8.95% -1.15
11.00 14.00 12.85 0.91
innodb order_by_big_key_prefix 14.00 -4.48% -0.60
12.00 14.00 13.40 0.73
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 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb order_by_range 1.00 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 19.00 +14.61% 3.25
17.00 26.00 22.25 3.00
innodb outer_join_found 18.00 +15.29% 3.25
16.00 25.00 21.25 2.83
innodb outer_join_not_found 17.00 +11.23% 2.15
14.00 22.00 19.15 2.61
innodb outer_join_on_key 13.00 +11.56% 1.70
11.00 17.00 14.70 1.98
innodb prepared_select 38.00 -2.01% -0.75
37.00 38.00 37.25 0.43
innodb select_1_row 4.00 -15.94% -0.55
3.00 4.00 3.45 0.50
innodb select_1_row_cache 3.00 +15.49% 0.55
3.00 4.00 3.55 0.50
innodb select_2_rows 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb select_big 14.00 -7.28% -0.95
12.00 15.00 13.05 0.92
innodb select_big_str 1.00 +20.00% 0.25
1.00 2.00 1.25 0.43
innodb select_cache 63.00 +1.72% 1.10
57.00 71.00 64.10 3.69
innodb select_cache2 61.00 +3.02% 1.90
60.00 69.00 62.90 2.47
innodb select_column+column 4.00 -3.90% -0.15
3.00 4.00 3.85 0.36
innodb select_diff_key 1.00 -185.71% -0.65
0.00 1.00 0.35 0.48
innodb select_distinct 5.00 -8.70% -0.40
4.00 5.00 4.60 0.49
innodb select_group 18.00 -3.15% -0.55
15.00 19.00 17.45 1.36
innodb select_group_when_MANY_tables 12.00 +1.23% 0.15
11.00 14.00 12.15 0.91
innodb select_join 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb select_key 65.00 -1.88% -1.20
63.00 66.00 63.80 0.81
innodb select_key2 72.00 -1.27% -0.90
69.00 73.00 71.10 1.18
innodb select_key2_return_key 69.00 -0.66% -0.45
67.00 71.00 68.55 1.12
innodb select_key2_return_prim 70.00 -0.79% -0.55
68.00 71.00 69.45 0.97
innodb select_key_prefix 71.00 -0.50% -0.35
69.00 73.00 70.65 0.96
innodb select_key_prefix_join 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb select_key_return_key 63.00 +0.16% 0.10
62.00 65.00 63.10 0.77
innodb select_many_fields 13.00 +1.89% 0.25
13.00 14.00 13.25 0.43
innodb select_range 41.00 +2.26% 0.95
39.00 49.00 41.95 2.44
innodb select_range_key2 10.00 -4.71% -0.45
9.00 10.00 9.55 0.50
innodb select_range_prefix 9.00 +1.64% 0.15
8.00 10.00 9.15 0.65
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 0.00 +100.00% 0.70
0.00 1.00 0.70 0.46
innodb update_autocommit 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb update_big 58.00 +2.03% 1.20
56.00 63.00 59.20 1.91
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 21.00 +4.98% 1.10
21.00 24.00 22.10 1.04
innodb update_of_key_big 30.00 +11.37% 3.85
29.00 38.00 33.85 2.97
innodb update_of_primary_key_many_keys 1242.00 +8.85% 120.60
1218.00 1489.00 1362.60 79.88
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 128.00 -3.98% -4.90
118.00 128.00 123.10 2.43
innodb update_with_key_prefix 47.00 -7.55% -3.30
40.00 48.00 43.70 2.03
innodb wisc_benchmark 2.00 +24.53% 0.65
2.00 3.00 2.65 0.48
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -54.73% -11.32
11.00 61.00 20.68 10.03
innodb alter_table_drop 23.00 -26.25% -4.78
10.00 57.00 18.22 7.00
innodb connect 2.00 +3.75% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -11.33% -0.31
2.00 5.00 2.69 0.48
innodb connect+select_simple 2.00 +14.36% 0.34
1.00 3.00 2.34 0.48
innodb count 18.00 -14.27% -2.25
12.00 193.00 15.75 8.95
innodb count_distinct 7.00 -6.63% -0.44
5.00 50.00 6.56 2.30
innodb count_distinct_2 15.00 -13.98% -1.84
11.00 63.00 13.16 2.99
innodb count_distinct_big 25.00 -14.10% -3.09
5.00 67.00 21.91 3.05
innodb count_distinct_group 15.00 -14.41% -1.89
10.00 68.00 13.11 3.13
innodb count_distinct_group_on_key 11.00 -16.02% -1.52
7.00 69.00 9.48 3.06
innodb count_distinct_group_on_key_parts 13.00 -5.79% -0.71
9.00 72.00 12.29 3.19
innodb count_distinct_key_prefix 5.00 +2.39% 0.12
3.00 52.00 5.12 2.42
innodb count_group_on_key_parts 11.00 -10.57% -1.05
7.00 72.00 9.95 3.19
innodb count_on_key 96.00 -11.98% -10.27
68.00 107.00 85.73 7.32
innodb create+drop 33.00 -1.83% -0.59
18.00 75.00 32.41 12.07
innodb create_index 3.00 -4.33% -0.12
1.00 8.00 2.88 1.15
innodb create_key+drop 33.00 -17.48% -4.91
21.00 50.00 28.09 4.95
innodb create_MANY_tables 21.00 +39.08% 13.47
14.00 121.00 34.47 17.19
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.36
innodb delete_all_many_keys 604.00 -31.84% -145.87
212.00 1888.00 458.13 369.02
innodb delete_autocommit 3.00 +12.61% 0.43
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 603.00 -29.82% -138.51
212.00 2293.00 464.49 383.61
innodb delete_commit 2.00 -33.12% -0.50
1.00 5.00 1.50 0.53
innodb delete_key 3.00 +2.23% 0.07
2.00 35.00 3.07 1.52
innodb delete_range 8.00 +3.48% 0.29
5.00 23.00 8.29 3.28
innodb delete_rollback 2.00 -15.91% -0.27
1.00 12.00 1.73 0.92
innodb drop_index 3.00 -1.79% -0.05
1.00 9.00 2.95 1.34
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.23
innodb drop_table_when_MANY_tables 18.00 +8.16% 1.60
11.00 90.00 19.60 7.64
innodb insert 117.00 -9.88% -10.52
3.00 343.00 106.48 14.77
innodb insert_autocommit 4.00 -33.65% -1.01
2.00 99.00 2.99 3.37
innodb insert_commit 2.00 -46.83% -0.64
1.00 3.00 1.36 0.49
innodb insert_duplicates 19.00 -23.84% -3.66
11.00 21.00 15.34 2.61
innodb insert_key 265.00 +12.82% 38.96
142.00 700.00 303.96 108.81
innodb insert_many_fields 6.00 -7.21% -0.40
3.00 17.00 5.60 1.80
innodb insert_rollback 2.00 -20.96% -0.35
1.00 3.00 1.65 0.53
innodb insert_select_1_key 4.00 -5.84% -0.22
2.00 10.00 3.78 0.90
innodb insert_select_2_keys 6.00 +1.13% 0.07
4.00 16.00 6.07 2.12
innodb min_max 9.00 -15.04% -1.18
6.00 110.00 7.82 4.61
innodb min_max_on_key 25.00 -22.50% -4.59
14.00 37.00 20.41 3.04
innodb multiple_value_insert 6.00 -10.62% -0.58
2.00 50.00 5.42 4.35
innodb once_prepared_select 29.00 -20.62% -4.96
18.00 32.00 24.04 3.51
innodb order_by_big 15.00 -4.87% -0.70
12.00 31.00 14.30 1.54
innodb order_by_big_key 16.00 -20.85% -2.76
11.00 32.00 13.24 1.64
innodb order_by_big_key2 15.00 -23.29% -2.83
10.00 33.00 12.17 1.55
innodb order_by_big_key_desc 16.00 -18.97% -2.55
11.00 32.00 13.45 1.67
innodb order_by_big_key_diff 14.00 -14.79% -1.80
10.00 31.00 12.20 1.51
innodb order_by_big_key_prefix 14.00 -13.16% -1.63
10.00 32.00 12.37 1.57
innodb order_by_key2_diff 1.00 +28.50% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -26.79% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -20.72% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 19.00 +1.35% 0.26
15.00 61.00 19.26 3.73
innodb outer_join_found 18.00 +3.69% 0.69
14.00 58.00 18.69 3.58
innodb outer_join_not_found 17.00 -3.80% -0.62
12.00 46.00 16.38 3.17
innodb outer_join_on_key 13.00 -1.16% -0.15
10.00 59.00 12.85 2.78
innodb prepared_select 38.00 -22.11% -6.88
22.00 40.00 31.12 4.44
innodb select_1_row 4.00 -41.29% -1.17
2.00 4.00 2.83 0.69
innodb select_1_row_cache 3.00 -13.19% -0.35
2.00 4.00 2.65 0.67
innodb select_2_rows 4.00 -40.28% -1.15
2.00 4.00 2.85 0.69
innodb select_big 14.00 -15.33% -1.86
0.00 31.00 12.14 1.55
innodb select_big_str 1.00 +13.33% 0.15
0.00 2.00 1.15 0.36
innodb select_cache 63.00 -5.85% -3.48
49.00 77.00 59.52 5.64
innodb select_cache2 61.00 -1.83% -1.10
49.00 75.00 59.90 6.34
innodb select_column+column 4.00 -38.02% -1.10
2.00 4.00 2.90 0.71
innodb select_diff_key 1.00 -360.22% -0.78
0.00 1.00 0.22 0.41
innodb select_distinct 5.00 -18.24% -0.77
3.00 8.00 4.23 0.54
innodb select_group 18.00 -10.76% -1.75
4.00 136.00 16.25 5.51
innodb select_group_when_MANY_tables 12.00 -28.02% -2.63
3.00 49.00 9.37 9.60
innodb select_join 1.00 -73.24% -0.42
0.00 1.00 0.58 0.49
innodb select_key 65.00 -24.11% -12.63
40.00 66.00 52.37 7.28
innodb select_key2 72.00 -21.93% -12.95
45.00 75.00 59.05 8.15
innodb select_key2_return_key 69.00 -22.40% -12.63
42.00 71.00 56.37 7.93
innodb select_key2_return_prim 70.00 -22.52% -12.87
42.00 72.00 57.13 8.09
innodb select_key_prefix 71.00 -21.81% -12.71
44.00 75.00 58.29 8.15
innodb select_key_prefix_join 5.00 -6.21% -0.29
3.00 10.00 4.71 0.66
innodb select_key_return_key 63.00 -22.56% -11.60
38.00 65.00 51.40 7.29
innodb select_many_fields 13.00 +13.35% 2.00
11.00 19.00 15.00 1.79
innodb select_range 41.00 +13.17% 6.22
39.00 76.00 47.22 3.93
innodb select_range_key2 10.00 -21.69% -1.78
6.00 11.00 8.22 1.03
innodb select_range_prefix 9.00 -15.57% -1.21
5.00 10.00 7.79 1.09
innodb select_simple 2.00 -22.43% -0.37
1.00 3.00 1.63 0.51
innodb select_simple_cache 2.00 -29.96% -0.46
1.00 3.00 1.54 0.52
innodb select_simple_join 0.00 +100.00% 0.65
0.00 3.00 0.65 0.48
innodb update_autocommit 4.00 -20.48% -0.68
2.00 16.00 3.32 1.02
innodb update_big 58.00 -14.37% -7.29
31.00 195.00 50.71 24.83
innodb update_commit 2.00 -29.10% -0.45
1.00 10.00 1.55 0.73
innodb update_of_key 21.00 +13.55% 3.29
18.00 100.00 24.29 6.26
innodb update_of_key_big 30.00 -10.51% -2.85
15.00 75.00 27.15 11.00
innodb update_of_primary_key_many_keys 1242.00 -0.47% -5.87
647.00 6065.00 1236.13 979.50
innodb update_rollback 2.00 -14.48% -0.25
1.00 31.00 1.75 1.93
innodb update_with_key 128.00 -16.92% -18.52
90.00 598.00 109.48 21.02
innodb update_with_key_prefix 47.00 -19.12% -7.54
33.00 202.00 39.46 6.86
innodb wisc_benchmark 2.00 +19.19% 0.47
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2178.1.3: Brian Aker 2011-02-17 Merge in additional throw back in syntax for
bison
2178.1.2: Brian Aker 2011-02-17 Go back a version and see if this will make
the bison on RHEL happy.
2178.1.1: Brian Aker 2011-02-17 [merge] Cleanup some of the calling types we
have in the parser.
2172.3.13: Brian Aker 2011-02-17 Merge in additional bits for parser.
2172.3.12: Brian Aker 2011-02-17 Adding verbose to be explicit in the
parser.
2172.3.11: Brian Aker 2011-02-17 Fix lex to use modern param type add.
2172.3.10: Brian Aker 2011-02-17 Fix parser type to not be a void.
2172.3.9: Brian Aker 2011-02-16 Dead-ish the macro for YYSession since we
no longer cast.
2172.3.8: Brian Aker 2011-02-16 Modernize our call to the parser, no more
casting required.
2172.3.7: Brian Aker 2011-02-16 Another smallish updat
2172.3.6: Brian Aker 2011-02-16 Namespace the parser just a bit, and update
our call for the type of parser
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
