=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 739
RUN DATE: 2010-12-16T13:00:34.517601
SERVER: drizzled
VERSION: staging
REVISION: 2000
COMMENT: 2000: Brian Aker 2010-12-16 [merge] Rollup of error work done by
Monty.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 49.00 -42.44% -14.60
18.00 49.00 34.40 11.53
innodb alter_table_drop 36.00 -28.57% -8.00
15.00 42.00 28.00 9.74
innodb connect 3.00 -25.00% -0.60
2.00 3.00 2.40 0.49
innodb connect+select_1_row 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb connect+select_simple 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
innodb count 13.00 +15.58% 2.40
13.00 17.00 15.40 1.62
innodb count_distinct 6.00 -3.45% -0.20
5.00 6.00 5.80 0.40
innodb count_distinct_2 13.00 -6.56% -0.80
11.00 13.00 12.20 0.75
innodb count_distinct_big 21.00 +8.70% 2.00
20.00 25.00 23.00 2.10
innodb count_distinct_group 13.00 +5.80% 0.80
13.00 14.00 13.80 0.40
innodb count_distinct_group_on_key 9.00 +2.17% 0.20
9.00 10.00 9.20 0.40
innodb count_distinct_group_on_key_parts 15.00 -20.97% -2.60
11.00 15.00 12.40 1.36
innodb count_distinct_key_prefix 6.00 -20.00% -1.00
4.00 6.00 5.00 0.63
innodb count_group_on_key_parts 10.00 +12.28% 1.40
10.00 13.00 11.40 1.20
innodb count_on_key 91.00 +1.09% 1.00
91.00 95.00 92.00 1.55
innodb create+drop 64.00 -20.75% -11.00
42.00 67.00 53.00 10.43
innodb create_index 5.00 -19.05% -0.80
2.00 6.00 4.20 1.33
innodb create_key+drop 40.00 -15.61% -5.40
30.00 43.00 34.60 5.71
innodb create_MANY_tables 62.00 -21.57% -11.00
38.00 63.00 51.00 10.02
innodb create_table 3.00 -400.00% -2.40
0.00 3.00 0.60 1.20
innodb delete_all_many_keys 1458.00 -81.93% -656.60
317.00 1483.00 801.40 546.87
innodb delete_autocommit 4.00 -11.11% -0.40
3.00 5.00 3.60 0.80
innodb delete_big 0.00 +100.00% 0.40
0.00 2.00 0.40 0.80
innodb delete_big_many_keys 1457.00 -81.99% -656.40
316.00 1482.00 800.60 546.70
innodb delete_commit 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb delete_key 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb delete_range 17.00 -18.06% -2.60
9.00 21.00 14.40 4.45
innodb delete_rollback 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb drop_index 5.00 +7.41% 0.40
2.00 8.00 5.40 2.06
innodb drop_table_when_MANY_tables 40.00 -35.14% -10.40
18.00 44.00 29.60 10.44
innodb insert 119.00 -2.06% -2.40
110.00 124.00 116.60 4.72
innodb insert_autocommit 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb insert_commit 1.00 +44.44% 0.80
1.00 2.00 1.80 0.40
innodb insert_duplicates 19.00 +1.04% 0.20
19.00 20.00 19.20 0.40
innodb insert_key 746.00 -51.38% -253.20
293.00 805.00 492.80 231.88
innodb insert_many_fields 8.00 -17.65% -1.20
5.00 8.00 6.80 1.17
innodb insert_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb insert_select_1_key 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb insert_select_2_keys 14.00 -34.62% -3.60
7.00 16.00 10.40 3.83
innodb min_max 7.00 +7.89% 0.60
6.00 9.00 7.60 1.20
innodb min_max_on_key 25.00 -2.46% -0.60
24.00 25.00 24.40 0.49
innodb multiple_value_insert 11.00 -44.74% -3.40
3.00 15.00 7.60 4.63
innodb once_prepared_select 30.00 -1.35% -0.40
29.00 30.00 29.60 0.49
innodb order_by_big 14.00 -9.38% -1.20
12.00 14.00 12.80 0.75
innodb order_by_big_key 12.00 -1.69% -0.20
11.00 12.00 11.80 0.40
innodb order_by_big_key2 11.00 +1.79% 0.20
11.00 12.00 11.20 0.40
innodb order_by_big_key_desc 13.00 -1.56% -0.20
12.00 13.00 12.80 0.40
innodb order_by_big_key_diff 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb order_by_big_key_prefix 11.00 +1.79% 0.20
11.00 12.00 11.20 0.40
innodb order_by_key2_diff 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb order_by_key_prefix 0.00 +100.00% 0.60
0.00 1.00 0.60 0.49
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 23.00 -5.50% -1.20
18.00 24.00 21.80 2.14
innodb outer_join_found 21.00 +1.87% 0.40
18.00 24.00 21.40 1.96
innodb outer_join_not_found 19.00 -3.26% -0.60
16.00 22.00 18.40 2.06
innodb outer_join_on_key 15.00 -1.35% -0.20
12.00 17.00 14.80 1.60
innodb prepared_select 37.00 +1.60% 0.60
37.00 38.00 37.60 0.49
innodb select_1_row 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_1_row_cache 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_2_rows 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_big 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb select_big_str 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
innodb select_cache 58.00 +2.03% 1.20
56.00 61.00 59.20 1.94
innodb select_cache2 60.00 +1.64% 1.00
58.00 68.00 61.00 3.69
innodb select_column+column 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_diff_key 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_distinct 5.00 -13.64% -0.60
4.00 5.00 4.40 0.49
innodb select_group 15.00 +3.85% 0.60
15.00 18.00 15.60 1.20
innodb select_group_when_MANY_tables 39.00 -27.45% -8.40
21.00 44.00 30.60 9.13
innodb select_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb select_key 64.00 +0.62% 0.40
63.00 65.00 64.40 0.80
innodb select_key2 72.00 -0.00% 0.00
71.00 74.00 72.00 1.10
innodb select_key2_return_key 68.00 +0.29% 0.20
67.00 69.00 68.20 0.75
innodb select_key2_return_prim 69.00 +1.15% 0.80
69.00 71.00 69.80 0.75
innodb select_key_prefix 71.00 +0.84% 0.60
71.00 73.00 71.60 0.80
innodb select_key_prefix_join 4.00 +13.04% 0.60
4.00 5.00 4.60 0.49
innodb select_key_return_key 63.00 +0.63% 0.40
63.00 64.00 63.40 0.49
innodb select_many_fields 15.00 -2.74% -0.40
13.00 16.00 14.60 1.02
innodb select_range 47.00 +3.69% 1.80
47.00 52.00 48.80 1.72
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 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb select_simple_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb update_autocommit 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb update_big 161.00 -34.17% -41.00
81.00 171.00 120.00 38.54
innodb update_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb update_of_key 22.00 +0.90% 0.20
21.00 24.00 22.20 0.98
innodb update_of_key_big 58.00 -30.04% -13.40
33.00 58.00 44.60 10.71
innodb update_of_primary_key_many_keys 3088.00 -74.58% -1319.20
766.00 3178.00 1768.80 1,115.63
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
117.00 135.00 123.60 6.86
innodb update_with_key_prefix 46.00 -4.07% -1.80
41.00 49.00 44.20 3.06
innodb wisc_benchmark 5.00 -56.25% -1.80
2.00 5.00 3.20 0.98
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 49.00 -46.27% -15.50
14.00 49.00 33.50 10.59
innodb alter_table_drop 36.00 -33.83% -9.10
13.00 42.00 26.90 8.06
innodb connect 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
innodb connect+select_1_row 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb connect+select_simple 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb count 13.00 +15.58% 2.40
13.00 18.00 15.40 1.77
innodb count_distinct 6.00 +6.25% 0.40
5.00 8.00 6.40 0.86
innodb count_distinct_2 13.00 +0.76% 0.10
11.00 17.00 13.10 1.58
innodb count_distinct_big 21.00 +4.98% 1.10
19.00 25.00 22.10 2.12
innodb count_distinct_group 13.00 +9.09% 1.30
12.00 15.00 14.30 0.78
innodb count_distinct_group_on_key 9.00 +5.76% 0.55
8.00 11.00 9.55 0.86
innodb count_distinct_group_on_key_parts 15.00 -19.05% -2.40
11.00 15.00 12.60 1.16
innodb count_distinct_key_prefix 6.00 -15.38% -0.80
4.00 7.00 5.20 0.75
innodb count_group_on_key_parts 10.00 +8.68% 0.95
10.00 13.00 10.95 1.02
innodb count_on_key 91.00 +0.66% 0.60
88.00 96.00 91.60 2.01
innodb create+drop 64.00 -20.19% -10.75
26.00 81.00 53.25 14.90
innodb create_index 5.00 -11.11% -0.50
2.00 7.00 4.50 1.53
innodb create_key+drop 40.00 -13.80% -4.85
28.00 43.00 35.15 5.59
innodb create_MANY_tables 62.00 -27.44% -13.35
16.00 65.00 48.65 13.76
innodb create_table 3.00 -1100.00% -2.75
0.00 3.00 0.25 0.70
innodb delete_all_many_keys 1458.00 -69.38% -597.20
295.00 1838.00 860.80 562.79
innodb delete_autocommit 4.00 -14.29% -0.50
3.00 5.00 3.50 0.59
innodb delete_big 0.00 +100.00% 0.40
0.00 2.00 0.40 0.58
innodb delete_big_many_keys 1457.00 -69.44% -597.10
295.00 1835.00 859.90 562.22
innodb delete_commit 2.00 -2.56% -0.05
1.00 3.00 1.95 0.50
innodb delete_key 4.00 -21.21% -0.70
2.00 5.00 3.30 0.71
innodb delete_range 17.00 -18.88% -2.70
6.00 21.00 14.30 4.68
innodb delete_rollback 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb drop_index 5.00 -12.36% -0.55
2.00 8.00 4.45 1.53
innodb drop_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb drop_table_when_MANY_tables 40.00 -38.41% -11.10
14.00 44.00 28.90 9.38
innodb insert 119.00 +6.89% 8.80
109.00 343.00 127.80 49.71
innodb insert_autocommit 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb insert_commit 1.00 +42.86% 0.75
1.00 2.00 1.75 0.43
innodb insert_duplicates 19.00 +1.04% 0.20
18.00 20.00 19.20 0.51
innodb insert_key 746.00 -45.67% -233.90
172.00 959.00 512.10 252.79
innodb insert_many_fields 8.00 +4.76% 0.40
5.00 15.00 8.40 2.69
innodb insert_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb insert_select_1_key 4.00 +1.23% 0.05
3.00 6.00 4.05 0.86
innodb insert_select_2_keys 14.00 -45.08% -4.35
5.00 16.00 9.65 2.95
innodb min_max 7.00 +7.89% 0.60
6.00 9.00 7.60 1.16
innodb min_max_on_key 25.00 -1.21% -0.30
24.00 25.00 24.70 0.46
innodb multiple_value_insert 11.00 -4.27% -0.45
3.00 50.00 10.55 10.65
innodb once_prepared_select 30.00 -0.84% -0.25
29.00 31.00 29.75 0.70
innodb order_by_big 14.00 +1.75% 0.25
12.00 16.00 14.25 1.44
innodb order_by_big_key 12.00 +7.34% 0.95
11.00 15.00 12.95 1.12
innodb order_by_big_key2 11.00 +7.95% 0.95
10.00 13.00 11.95 1.02
innodb order_by_big_key_desc 13.00 +3.35% 0.45
11.00 15.00 13.45 1.20
innodb order_by_big_key_diff 11.00 +7.95% 0.95
11.00 13.00 11.95 0.97
innodb order_by_big_key_prefix 11.00 +10.20% 1.25
11.00 14.00 12.25 1.09
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb order_by_key_prefix 0.00 +100.00% 0.70
0.00 1.00 0.70 0.46
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 23.00 -3.37% -0.75
17.00 25.00 22.25 2.02
innodb outer_join_found 21.00 +2.78% 0.60
17.00 24.00 21.60 1.91
innodb outer_join_not_found 19.00 -0.80% -0.15
16.00 22.00 18.85 1.68
innodb outer_join_on_key 15.00 -0.67% -0.10
12.00 17.00 14.90 1.48
innodb prepared_select 37.00 +1.86% 0.70
37.00 39.00 37.70 0.71
innodb select_1_row 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb select_1_row_cache 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_2_rows 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb select_big 11.00 +9.47% 1.15
11.00 14.00 12.15 1.24
innodb select_big_str 2.00 -53.85% -0.70
1.00 2.00 1.30 0.46
innodb select_cache 58.00 +3.49% 2.10
56.00 67.00 60.10 2.84
innodb select_cache2 60.00 +0.66% 0.40
55.00 68.00 60.40 3.29
innodb select_column+column 3.00 +20.00% 0.75
3.00 4.00 3.75 0.43
innodb select_diff_key 0.00 +100.00% 0.30
0.00 1.00 0.30 0.46
innodb select_distinct 5.00 -17.65% -0.75
4.00 5.00 4.25 0.43
innodb select_group 15.00 +7.98% 1.30
14.00 19.00 16.30 1.62
innodb select_group_when_MANY_tables 39.00 -33.33% -9.75
7.00 47.00 29.25 11.11
innodb select_join 1.00 -81.82% -0.45
0.00 1.00 0.55 0.50
innodb select_key 64.00 +0.54% 0.35
63.00 65.00 64.35 0.65
innodb select_key2 72.00 -0.42% -0.30
71.00 74.00 71.70 0.95
innodb select_key2_return_key 68.00 +0.07% 0.05
66.00 70.00 68.05 0.97
innodb select_key2_return_prim 69.00 +0.50% 0.35
68.00 71.00 69.35 0.79
innodb select_key_prefix 71.00 +0.21% 0.15
70.00 74.00 71.15 1.11
innodb select_key_prefix_join 4.00 +16.67% 0.80
4.00 5.00 4.80 0.40
innodb select_key_return_key 63.00 -0.08% -0.05
61.00 64.00 62.95 0.74
innodb select_many_fields 15.00 -3.81% -0.55
13.00 18.00 14.45 1.32
innodb select_range 47.00 +2.79% 1.35
44.00 52.00 48.35 2.59
innodb select_range_key2 9.00 +4.76% 0.45
9.00 10.00 9.45 0.50
innodb select_range_prefix 9.00 +1.64% 0.15
8.00 10.00 9.15 0.57
innodb select_simple 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb select_simple_cache 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb select_simple_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb update_autocommit 3.00 +15.49% 0.55
3.00 5.00 3.55 0.59
innodb update_big 161.00 -38.73% -44.95
41.00 171.00 116.05 40.18
innodb update_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb update_of_key 22.00 +1.12% 0.25
20.00 25.00 22.25 1.44
innodb update_of_key_big 58.00 -32.27% -14.15
29.00 58.00 43.85 8.50
innodb update_of_primary_key_many_keys 3088.00 -64.17% -1207.05
686.00 3842.00 1880.95 1,143.82
innodb update_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb update_with_key 128.00 -3.10% -3.85
109.00 140.00 124.15 8.86
innodb update_with_key_prefix 46.00 -5.02% -2.20
40.00 49.00 43.80 3.14
innodb wisc_benchmark 5.00 -72.41% -2.10
2.00 5.00 2.90 0.62
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 49.00 -177.42% -31.34
11.00 61.00 17.66 8.56
innodb alter_table_drop 36.00 -117.70% -19.46
10.00 57.00 16.54 6.49
innodb connect 3.00 -46.84% -0.96
1.00 3.00 2.04 0.41
innodb connect+select_1_row 3.00 -13.36% -0.35
2.00 5.00 2.65 0.50
innodb connect+select_simple 2.00 +12.37% 0.28
1.00 3.00 2.28 0.46
innodb count 13.00 +17.22% 2.70
12.00 193.00 15.70 9.92
innodb count_distinct 6.00 +7.46% 0.48
5.00 50.00 6.48 2.53
innodb count_distinct_2 13.00 +0.01% 0.00
11.00 63.00 13.00 3.24
innodb count_distinct_big 21.00 +3.31% 0.72
5.00 67.00 21.72 3.24
innodb count_distinct_group 13.00 -2.37% -0.30
10.00 68.00 12.70 3.26
innodb count_distinct_group_on_key 9.00 +3.77% 0.35
7.00 69.00 9.35 3.33
innodb count_distinct_group_on_key_parts 15.00 -25.58% -3.06
9.00 72.00 11.94 3.35
innodb count_distinct_key_prefix 6.00 -18.73% -0.95
3.00 52.00 5.05 2.67
innodb count_group_on_key_parts 10.00 -3.54% -0.34
7.00 72.00 9.66 3.48
innodb count_on_key 91.00 -8.67% -7.26
68.00 203.00 83.74 7.86
innodb create+drop 64.00 -103.32% -32.52
18.00 81.00 31.48 12.60
innodb create_index 5.00 -84.99% -2.30
1.00 8.00 2.70 1.10
innodb create_key+drop 40.00 -46.34% -12.67
21.00 50.00 27.33 4.77
innodb create_MANY_tables 62.00 -72.04% -25.96
14.00 121.00 36.04 17.64
innodb create_table 3.00 -2592.01% -2.89
0.00 3.00 0.11 0.38
innodb delete_all_many_keys 1458.00 -262.53% -1055.83
212.00 2293.00 402.17 378.57
innodb delete_autocommit 4.00 -19.68% -0.66
2.00 6.00 3.34 0.59
innodb delete_big 0.00 +100.00% 0.22
0.00 2.00 0.22 0.42
innodb delete_big_many_keys 1457.00 -262.41% -1054.96
212.00 2293.00 402.04 378.41
innodb delete_commit 2.00 -41.77% -0.59
1.00 3.00 1.41 0.50
innodb delete_key 4.00 -29.91% -0.92
2.00 35.00 3.08 1.65
innodb delete_range 17.00 -116.45% -9.15
5.00 23.00 7.85 3.08
innodb delete_rollback 3.00 -92.55% -1.44
1.00 4.00 1.56 0.57
innodb drop_index 5.00 -79.66% -2.22
1.00 9.00 2.78 1.30
innodb drop_table 0.00 +100.00% 0.04
0.00 2.00 0.04 0.21
innodb drop_table_when_MANY_tables 40.00 -108.57% -20.82
11.00 49.00 19.18 6.28
innodb insert 119.00 -14.01% -14.62
3.00 343.00 104.38 15.63
innodb insert_autocommit 4.00 -37.28% -1.09
2.00 99.00 2.91 3.74
innodb insert_commit 1.00 +21.59% 0.28
1.00 3.00 1.28 0.46
innodb insert_duplicates 19.00 -31.81% -4.59
11.00 21.00 14.41 1.98
innodb insert_key 746.00 -121.31% -408.92
142.00 959.00 337.08 166.03
innodb insert_many_fields 8.00 -46.78% -2.55
3.00 17.00 5.45 1.88
innodb insert_rollback 2.00 -28.00% -0.44
1.00 3.00 1.56 0.53
innodb insert_select_1_key 4.00 -7.15% -0.27
2.00 10.00 3.73 0.92
innodb insert_select_2_keys 14.00 -141.62% -8.21
4.00 16.00 5.79 2.06
innodb min_max 7.00 +10.28% 0.80
6.00 110.00 7.80 5.11
innodb min_max_on_key 25.00 -28.71% -5.58
14.00 37.00 19.42 2.53
innodb multiple_value_insert 11.00 -118.50% -5.97
2.00 50.00 5.03 4.61
innodb once_prepared_select 30.00 -31.71% -7.22
18.00 32.00 22.78 2.64
innodb order_by_big 14.00 +1.88% 0.27
12.00 31.00 14.27 1.60
innodb order_by_big_key 12.00 +8.06% 1.05
11.00 32.00 13.05 1.62
innodb order_by_big_key2 11.00 +8.50% 1.02
10.00 33.00 12.02 1.61
innodb order_by_big_key_desc 13.00 +0.82% 0.11
11.00 32.00 13.11 1.57
innodb order_by_big_key_diff 11.00 +8.68% 1.05
10.00 31.00 12.05 1.56
innodb order_by_big_key_prefix 11.00 +9.69% 1.18
10.00 32.00 12.18 1.63
innodb order_by_key2_diff 2.00 -42.77% -0.60
1.00 3.00 1.40 0.50
innodb order_by_key_prefix 0.00 +100.00% 0.77
0.00 2.00 0.77 0.43
innodb order_by_range 1.00 -25.42% -0.20
0.00 2.00 0.80 0.41
innodb outer_join 23.00 -23.60% -4.39
15.00 61.00 18.61 3.69
innodb outer_join_found 21.00 -16.01% -2.90
14.00 58.00 18.10 3.56
innodb outer_join_not_found 19.00 -20.42% -3.22
12.00 46.00 15.78 3.07
innodb outer_join_on_key 15.00 -20.99% -2.60
10.00 59.00 12.40 2.80
innodb prepared_select 37.00 -24.83% -7.36
22.00 40.00 29.64 3.63
innodb select_1_row 4.00 -52.00% -1.37
2.00 4.00 2.63 0.57
innodb select_1_row_cache 4.00 -62.17% -1.53
2.00 4.00 2.47 0.57
innodb select_2_rows 4.00 -51.15% -1.35
2.00 4.00 2.65 0.57
innodb select_big 11.00 +8.15% 0.98
0.00 31.00 11.98 1.60
innodb select_big_str 2.00 -78.89% -0.88
0.00 2.00 1.12 0.33
innodb select_cache 58.00 +3.69% 2.22
49.00 676.00 60.22 30.54
innodb select_cache2 60.00 +1.20% 0.73
49.00 677.00 60.73 32.23
innodb select_column+column 3.00 -11.79% -0.32
2.00 4.00 2.68 0.59
innodb select_diff_key 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_distinct 5.00 -19.71% -0.82
3.00 8.00 4.18 0.54
innodb select_group 15.00 +6.49% 1.04
4.00 136.00 16.04 6.08
innodb select_group_when_MANY_tables 39.00 -428.96% -31.63
3.00 47.00 7.37 8.21
innodb select_join 1.00 -81.40% -0.45
0.00 1.00 0.55 0.50
innodb select_key 64.00 -29.01% -14.39
40.00 66.00 49.61 5.12
innodb select_key2 72.00 -28.16% -15.82
45.00 75.00 56.18 6.32
innodb select_key2_return_key 68.00 -27.07% -14.48
42.00 70.00 53.52 5.99
innodb select_key2_return_prim 69.00 -27.19% -14.75
42.00 72.00 54.25 6.18
innodb select_key_prefix 71.00 -28.34% -15.68
44.00 75.00 55.32 6.09
innodb select_key_prefix_join 4.00 +13.08% 0.60
3.00 10.00 4.60 0.67
innodb select_key_return_key 63.00 -29.48% -14.34
38.00 65.00 48.66 5.20
innodb select_many_fields 15.00 +2.74% 0.42
11.00 19.00 15.42 1.72
innodb select_range 47.00 +2.62% 1.26
42.00 76.00 48.26 3.45
innodb select_range_key2 9.00 -13.92% -1.10
6.00 10.00 7.90 0.86
innodb select_range_prefix 9.00 -20.90% -1.56
5.00 10.00 7.44 0.88
innodb select_simple 2.00 -30.30% -0.47
1.00 3.00 1.53 0.52
innodb select_simple_cache 2.00 -40.65% -0.58
1.00 3.00 1.42 0.50
innodb select_simple_join 1.00 -60.24% -0.38
0.00 3.00 0.62 0.49
innodb update_autocommit 3.00 +4.91% 0.15
2.00 5.00 3.15 0.49
innodb update_big 161.00 -258.72% -116.12
31.00 171.00 44.88 19.25
innodb update_commit 2.00 -41.32% -0.58
1.00 3.00 1.42 0.50
innodb update_of_key 22.00 +11.15% 2.76
18.00 100.00 24.76 6.88
innodb update_of_key_big 58.00 -136.94% -33.52
15.00 75.00 24.48 10.17
innodb update_of_primary_key_many_keys 3088.00 -169.32% -1941.43
660.00 6065.00 1146.57 1,060.39
innodb update_rollback 2.00 -32.94% -0.50
1.00 4.00 1.50 0.55
innodb update_with_key 128.00 -20.44% -21.72
90.00 598.00 106.28 22.14
innodb update_with_key_prefix 46.00 -19.91% -7.64
33.00 202.00 38.36 7.13
innodb wisc_benchmark 5.00 -104.88% -2.56
2.00 5.00 2.44 0.52
=========================================================================================================================
FULL REVISION COMMENTARY:
1999.1.6: Brian Aker 2010-12-16 Remove bad change. The test does not run in
isolation.
1999.1.5: Brian Aker 2010-12-16 Fix up the tests, remove flush.
1999.1.4: Brian Aker 2010-12-16 Test correction.
1999.1.3: Brian Aker 2010-12-16 [merge] Merge in Monty. Two changes were made:
1996.3.9: Monty Taylor 2010-12-15 Update logging_stats test results to
account for the extra query which pulls
1996.3.8: Monty Taylor 2010-12-15 Resolve error messages earlier, so that
we can avoid clashes with
1996.3.7: Monty Taylor 2010-12-15 Replaced static error code mapping with a
query of data_dictionary.errors.
1999.1.2: Brian Aker 2010-12-15 Fix compile issue because of new error
messages.
1999.1.1: Brian Aker 2010-12-15 [merge] Merge in error message DD.
1996.3.6: Monty Taylor 2010-12-15 Fixed information_schema_dictionary test
result.
1996.3.5: Monty Taylor 2010-12-15 Update data_dictionary test to include
new standard table/columns.
1996.3.4: Monty Taylor 2010-12-15 Update information_schema test with new
default D_D table.
1996.3.3: Monty Taylor 2010-12-15 Add error message data dictionary table.
1996.3.2: Monty Taylor 2010-12-15 Add API for getting at ErrorMap
information.
1996.3.1: Monty Taylor 2010-12-15 Add error code name into ErrorMap.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
