=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 889
RUN DATE: 2011-02-11T17:49:05.543419
SERVER: drizzled
VERSION: staging
REVISION: 2159
COMMENT: 2159: Lee Bieber 2011-02-11 [merge] Merge Stewart - 716852: drizzle
--prompt doesn't work
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 34.00 -3.66% -1.20
32.00 34.00 32.80 0.75
innodb alter_table_drop 24.00 -0.00% 0.00
23.00 25.00 24.00 0.63
innodb connect 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb connect+select_1_row 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb connect+select_simple 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb count 17.00 -11.84% -1.80
13.00 18.00 15.20 1.94
innodb count_distinct 8.00 -14.29% -1.00
6.00 8.00 7.00 0.63
innodb count_distinct_2 14.00 +1.41% 0.20
13.00 16.00 14.20 1.17
innodb count_distinct_big 24.00 -7.14% -1.60
21.00 24.00 22.40 1.36
innodb count_distinct_group 16.00 -9.59% -1.40
13.00 16.00 14.60 1.02
innodb count_distinct_group_on_key 10.00 -0.00% 0.00
10.00 10.00 10.00 0.00
innodb count_distinct_group_on_key_parts 13.00 +2.99% 0.40
13.00 14.00 13.40 0.49
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb count_group_on_key_parts 11.00 -1.85% -0.20
10.00 11.00 10.80 0.40
innodb count_on_key 95.00 -1.71% -1.60
91.00 95.00 93.40 1.36
innodb create+drop 33.00 -2.48% -0.80
31.00 34.00 32.20 1.17
innodb create_index 2.00 +28.57% 0.80
2.00 3.00 2.80 0.40
innodb create_key+drop 29.00 -0.69% -0.20
28.00 30.00 28.80 0.75
innodb create_MANY_tables 20.00 +2.91% 0.60
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 656.00 +1.06% 7.00
583.00 738.00 663.00 49.30
innodb delete_autocommit 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb delete_big 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 655.00 +1.09% 7.20
582.00 737.00 662.20 49.34
innodb delete_commit 1.00 +44.44% 0.80
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 8.00 +9.09% 0.80
8.00 10.00 8.80 0.75
innodb delete_rollback 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
innodb drop_index 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb drop_table_when_MANY_tables 16.00 -0.00% 0.00
15.00 17.00 16.00 0.63
innodb insert 115.00 -0.00% 0.00
114.00 116.00 115.00 0.63
innodb insert_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb insert_commit 2.00 -11.11% -0.20
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 280.00 +1.75% 5.00
266.00 302.00 285.00 11.83
innodb insert_many_fields 5.00 +10.71% 0.60
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 +4.76% 0.20
4.00 5.00 4.20 0.40
innodb insert_select_2_keys 6.00 +9.09% 0.60
6.00 8.00 6.60 0.80
innodb min_max 8.00 -5.26% -0.40
7.00 8.00 7.60 0.49
innodb min_max_on_key 24.00 +1.64% 0.40
24.00 25.00 24.40 0.49
innodb multiple_value_insert 6.00 +6.25% 0.40
5.00 8.00 6.40 1.02
innodb once_prepared_select 30.00 -1.35% -0.40
29.00 30.00 29.60 0.49
innodb order_by_big 13.00 +4.41% 0.60
13.00 15.00 13.60 0.80
innodb order_by_big_key 15.00 -5.63% -0.80
13.00 15.00 14.20 0.75
innodb order_by_big_key2 13.00 -0.00% 0.00
12.00 14.00 13.00 0.63
innodb order_by_big_key_desc 15.00 -0.00% 0.00
14.00 16.00 15.00 0.63
innodb order_by_big_key_diff 14.00 -7.69% -1.00
12.00 14.00 13.00 0.89
innodb order_by_big_key_prefix 14.00 -4.48% -0.60
13.00 14.00 13.40 0.49
innodb order_by_key2_diff 2.00 -25.00% -0.40
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 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb outer_join 19.00 +10.38% 2.20
17.00 25.00 21.20 2.86
innodb outer_join_found 18.00 +10.00% 2.00
16.00 23.00 20.00 2.61
innodb outer_join_not_found 17.00 +8.60% 1.60
15.00 22.00 18.60 2.58
innodb outer_join_on_key 13.00 +7.14% 1.00
11.00 16.00 14.00 1.79
innodb prepared_select 37.00 +0.54% 0.20
37.00 38.00 37.20 0.40
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 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_2_rows 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb select_big 12.00 +3.23% 0.40
12.00 14.00 12.40 0.80
innodb select_big_str 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb select_cache 64.00 -4.23% -2.60
57.00 64.00 61.40 2.65
innodb select_cache2 65.00 -5.18% -3.20
60.00 65.00 61.80 1.94
innodb select_column+column 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_diff_key 0.00 +100.00% 0.40
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 -4.65% -0.80
15.00 19.00 17.20 1.47
innodb select_group_when_MANY_tables 11.00 +11.29% 1.40
11.00 14.00 12.40 1.20
innodb select_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb select_key 64.00 -0.63% -0.40
63.00 64.00 63.60 0.49
innodb select_key2 71.00 +0.56% 0.40
70.00 73.00 71.40 1.02
innodb select_key2_return_key 69.00 -0.58% -0.40
67.00 70.00 68.60 1.02
innodb select_key2_return_prim 70.00 -0.29% -0.20
68.00 71.00 69.80 0.98
innodb select_key_prefix 71.00 -0.57% -0.40
69.00 71.00 70.60 0.80
innodb select_key_prefix_join 5.00 +7.41% 0.40
5.00 6.00 5.40 0.49
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 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb select_range 41.00 +4.21% 1.80
41.00 45.00 42.80 1.60
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
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 -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 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb update_big 56.00 +6.35% 3.80
56.00 63.00 59.80 2.93
innodb update_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb update_of_key 23.00 -5.50% -1.20
21.00 23.00 21.80 0.98
innodb update_of_key_big 31.00 +7.74% 2.60
31.00 36.00 33.60 2.24
innodb update_of_primary_key_many_keys 1313.00 +2.41% 32.40
1218.00 1466.00 1345.40 80.99
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 122.00 +0.49% 0.60
120.00 125.00 122.60 1.74
innodb update_with_key_prefix 42.00 +2.78% 1.20
42.00 45.00 43.20 1.17
innodb wisc_benchmark 3.00 -15.38% -0.40
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 34.00 -4.94% -1.60
31.00 34.00 32.40 0.86
innodb alter_table_drop 24.00 +0.41% 0.10
23.00 25.00 24.10 0.70
innodb connect 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb connect+select_1_row 3.00 -1.69% -0.05
2.00 3.00 2.95 0.22
innodb connect+select_simple 3.00 -13.21% -0.35
2.00 3.00 2.65 0.48
innodb count 17.00 -7.59% -1.20
13.00 18.00 15.80 1.78
innodb count_distinct 8.00 -20.30% -1.35
6.00 8.00 6.65 0.73
innodb count_distinct_2 14.00 -1.08% -0.15
12.00 16.00 13.85 1.11
innodb count_distinct_big 24.00 -4.58% -1.05
20.00 25.00 22.95 1.80
innodb count_distinct_group 16.00 -10.34% -1.50
13.00 16.00 14.50 0.87
innodb count_distinct_group_on_key 10.00 -0.00% 0.00
8.00 12.00 10.00 0.95
innodb count_distinct_group_on_key_parts 13.00 +2.99% 0.40
11.00 14.00 13.40 0.73
innodb count_distinct_key_prefix 5.00 +5.66% 0.30
5.00 6.00 5.30 0.46
innodb count_group_on_key_parts 11.00 -0.00% 0.00
10.00 12.00 11.00 0.45
innodb count_on_key 95.00 -1.12% -1.05
91.00 98.00 93.95 1.75
innodb create+drop 33.00 -3.77% -1.20
30.00 34.00 31.80 1.21
innodb create_index 2.00 +37.50% 1.20
2.00 4.00 3.20 0.51
innodb create_key+drop 29.00 -0.69% -0.20
28.00 30.00 28.80 0.75
innodb create_MANY_tables 20.00 +2.91% 0.60
19.00 22.00 20.60 0.80
innodb create_table 0.00 +100.00% 0.15
0.00 1.00 0.15 0.36
innodb delete_all_many_keys 656.00 +1.04% 6.90
569.00 738.00 662.90 42.63
innodb delete_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb delete_big 0.00 +100.00% 0.55
0.00 1.00 0.55 0.50
innodb delete_big_many_keys 655.00 +1.06% 7.05
569.00 737.00 662.05 42.45
innodb delete_commit 1.00 +45.95% 0.85
1.00 2.00 1.85 0.36
innodb delete_key 3.00 -7.14% -0.20
2.00 4.00 2.80 0.60
innodb delete_range 8.00 +8.57% 0.75
8.00 10.00 8.75 0.70
innodb delete_rollback 2.00 +11.11% 0.25
2.00 3.00 2.25 0.43
innodb drop_index 3.00 +6.25% 0.20
2.00 4.00 3.20 0.51
innodb drop_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb drop_table_when_MANY_tables 16.00 +1.23% 0.20
15.00 17.00 16.20 0.60
innodb insert 115.00 -0.61% -0.70
112.00 116.00 114.30 1.14
innodb insert_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
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
19.00 20.00 19.10 0.30
innodb insert_key 280.00 +1.44% 4.10
266.00 304.00 284.10 11.44
innodb insert_many_fields 5.00 +11.50% 0.65
5.00 6.00 5.65 0.48
innodb insert_rollback 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb insert_select_1_key 4.00 +2.44% 0.10
3.00 5.00 4.10 0.44
innodb insert_select_2_keys 6.00 +4.76% 0.30
6.00 8.00 6.30 0.56
innodb min_max 8.00 -4.58% -0.35
6.00 9.00 7.65 1.06
innodb min_max_on_key 24.00 +2.24% 0.55
24.00 26.00 24.55 0.59
innodb multiple_value_insert 6.00 +7.69% 0.50
5.00 8.00 6.50 0.74
innodb once_prepared_select 30.00 -3.09% -0.90
28.00 30.00 29.10 0.44
innodb order_by_big 13.00 +9.09% 1.30
13.00 16.00 14.30 1.05
innodb order_by_big_key 15.00 -4.17% -0.60
13.00 16.00 14.40 0.92
innodb order_by_big_key2 13.00 -0.78% -0.10
12.00 14.00 12.90 0.70
innodb order_by_big_key_desc 15.00 +1.32% 0.20
14.00 17.00 15.20 0.81
innodb order_by_big_key_diff 14.00 -7.69% -1.00
12.00 14.00 13.00 0.77
innodb order_by_big_key_prefix 14.00 -5.26% -0.70
12.00 15.00 13.30 0.78
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb order_by_key_prefix 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb order_by_range 1.00 -11.11% -0.10
0.00 1.00 0.90 0.30
innodb outer_join 19.00 +13.44% 2.95
17.00 25.00 21.95 2.56
innodb outer_join_found 18.00 +15.69% 3.35
16.00 25.00 21.35 2.85
innodb outer_join_not_found 17.00 +10.53% 2.00
14.00 22.00 19.00 2.49
innodb outer_join_on_key 13.00 +12.46% 1.85
11.00 18.00 14.85 1.96
innodb prepared_select 37.00 +0.67% 0.25
37.00 38.00 37.25 0.43
innodb select_1_row 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_1_row_cache 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb select_2_rows 3.00 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb select_big 12.00 +8.40% 1.10
12.00 14.00 13.10 0.89
innodb select_big_str 1.00 +25.93% 0.35
1.00 2.00 1.35 0.48
innodb select_cache 64.00 -2.48% -1.55
57.00 67.00 62.45 2.56
innodb select_cache2 65.00 -3.83% -2.40
57.00 67.00 62.60 2.50
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_diff_key 0.00 +100.00% 0.25
0.00 1.00 0.25 0.43
innodb select_distinct 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_group 18.00 -4.65% -0.80
15.00 19.00 17.20 1.44
innodb select_group_when_MANY_tables 11.00 +8.71% 1.05
11.00 14.00 12.05 0.92
innodb select_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb select_key 64.00 -0.95% -0.60
62.00 65.00 63.40 0.66
innodb select_key2 71.00 -0.21% -0.15
69.00 73.00 70.85 1.06
innodb select_key2_return_key 69.00 -1.10% -0.75
67.00 70.00 68.25 0.89
innodb select_key2_return_prim 70.00 -1.08% -0.75
68.00 71.00 69.25 0.94
innodb select_key_prefix 71.00 -0.64% -0.45
69.00 72.00 70.55 0.92
innodb select_key_prefix_join 5.00 +4.76% 0.25
5.00 6.00 5.25 0.43
innodb select_key_return_key 64.00 -1.91% -1.20
62.00 65.00 62.80 0.87
innodb select_many_fields 13.00 +0.76% 0.10
13.00 14.00 13.10 0.30
innodb select_range 41.00 +3.42% 1.45
39.00 45.00 42.45 1.91
innodb select_range_key2 10.00 -4.71% -0.45
9.00 11.00 9.55 0.59
innodb select_range_prefix 9.00 +2.17% 0.20
8.00 10.00 9.20 0.60
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 -42.86% -0.30
0.00 1.00 0.70 0.46
innodb update_autocommit 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb update_big 56.00 +6.12% 3.65
56.00 64.00 59.65 2.37
innodb update_commit 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb update_of_key 23.00 -3.84% -0.85
21.00 25.00 22.15 1.15
innodb update_of_key_big 31.00 +15.18% 5.55
31.00 47.00 36.55 4.14
innodb update_of_primary_key_many_keys 1313.00 +3.32% 45.10
1203.00 1482.00 1358.10 78.27
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 122.00 -0.00% 0.00
117.00 127.00 122.00 2.55
innodb update_with_key_prefix 42.00 +5.41% 2.40
40.00 50.00 44.40 2.73
innodb wisc_benchmark 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 34.00 -66.03% -13.52
11.00 61.00 20.48 9.99
innodb alter_table_drop 24.00 -32.42% -5.88
10.00 57.00 18.12 7.02
innodb connect 2.00 +3.75% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -11.50% -0.31
2.00 5.00 2.69 0.48
innodb connect+select_simple 3.00 -28.68% -0.67
1.00 3.00 2.33 0.48
innodb count 17.00 -7.89% -1.24
12.00 193.00 15.76 9.02
innodb count_distinct 8.00 -21.93% -1.44
5.00 50.00 6.56 2.32
innodb count_distinct_2 14.00 -6.44% -0.85
11.00 63.00 13.15 3.01
innodb count_distinct_big 24.00 -9.59% -2.10
5.00 67.00 21.90 3.06
innodb count_distinct_group 16.00 -22.24% -2.91
10.00 68.00 13.09 3.14
innodb count_distinct_group_on_key 10.00 -5.72% -0.54
7.00 69.00 9.46 3.06
innodb count_distinct_group_on_key_parts 13.00 -5.93% -0.73
9.00 72.00 12.27 3.21
innodb count_distinct_key_prefix 5.00 +2.33% 0.12
3.00 52.00 5.12 2.44
innodb count_group_on_key_parts 11.00 -10.78% -1.07
7.00 72.00 9.93 3.22
innodb count_on_key 95.00 -11.00% -9.41
68.00 107.00 85.59 7.30
innodb create+drop 33.00 -1.80% -0.58
18.00 75.00 32.42 12.17
innodb create_index 2.00 +30.34% 0.87
1.00 8.00 2.87 1.16
innodb create_key+drop 29.00 -3.35% -0.94
21.00 50.00 28.06 4.98
innodb create_MANY_tables 20.00 +42.38% 14.71
14.00 121.00 34.71 17.24
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.36
innodb delete_all_many_keys 656.00 -44.32% -201.44
212.00 1888.00 454.56 371.31
innodb delete_autocommit 4.00 -16.56% -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 655.00 -42.06% -193.94
212.00 2293.00 461.06 386.13
innodb delete_commit 1.00 +33.17% 0.50
1.00 5.00 1.50 0.53
innodb delete_key 3.00 +2.31% 0.07
2.00 35.00 3.07 1.53
innodb delete_range 8.00 +3.42% 0.28
5.00 23.00 8.28 3.31
innodb delete_rollback 2.00 -16.23% -0.28
1.00 12.00 1.72 0.93
innodb drop_index 3.00 -1.82% -0.05
1.00 9.00 2.95 1.35
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.58% 3.65
11.00 90.00 19.65 7.69
innodb insert 115.00 -8.13% -8.65
3.00 343.00 106.35 14.86
innodb insert_autocommit 3.00 -0.41% -0.01
2.00 99.00 2.99 3.39
innodb insert_commit 2.00 -47.61% -0.65
1.00 3.00 1.35 0.49
innodb insert_duplicates 19.00 -24.35% -3.72
11.00 21.00 15.28 2.58
innodb insert_key 280.00 +8.01% 24.37
142.00 700.00 304.37 109.78
innodb insert_many_fields 5.00 +10.62% 0.59
3.00 17.00 5.59 1.81
innodb insert_rollback 2.00 -21.39% -0.35
1.00 3.00 1.65 0.54
innodb insert_select_1_key 4.00 -5.85% -0.22
2.00 10.00 3.78 0.90
innodb insert_select_2_keys 6.00 +1.11% 0.07
4.00 16.00 6.07 2.14
innodb min_max 8.00 -2.28% -0.18
6.00 110.00 7.82 4.65
innodb min_max_on_key 24.00 -18.01% -3.66
14.00 37.00 20.34 3.02
innodb multiple_value_insert 6.00 -11.08% -0.60
2.00 50.00 5.40 4.38
innodb once_prepared_select 30.00 -25.24% -6.05
18.00 32.00 23.95 3.47
innodb order_by_big 13.00 +9.09% 1.30
12.00 31.00 14.30 1.54
innodb order_by_big_key 15.00 -13.53% -1.79
11.00 32.00 13.21 1.63
innodb order_by_big_key2 13.00 -7.02% -0.85
10.00 33.00 12.15 1.55
innodb order_by_big_key_desc 15.00 -11.79% -1.58
11.00 32.00 13.42 1.67
innodb order_by_big_key_diff 14.00 -14.89% -1.81
10.00 31.00 12.19 1.52
innodb order_by_big_key_prefix 14.00 -13.33% -1.65
10.00 32.00 12.35 1.58
innodb order_by_key2_diff 2.00 -43.18% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -27.17% -0.21
0.00 2.00 0.79 0.42
innodb order_by_range 1.00 -21.15% -0.17
0.00 2.00 0.83 0.39
innodb outer_join 19.00 +1.07% 0.21
15.00 61.00 19.21 3.72
innodb outer_join_found 18.00 +3.45% 0.64
14.00 58.00 18.64 3.58
innodb outer_join_not_found 17.00 -4.10% -0.67
12.00 46.00 16.33 3.15
innodb outer_join_on_key 13.00 -1.44% -0.18
10.00 59.00 12.82 2.78
innodb prepared_select 37.00 -19.30% -5.99
22.00 40.00 31.01 4.41
innodb select_1_row 3.00 -6.39% -0.18
2.00 4.00 2.82 0.69
innodb select_1_row_cache 4.00 -51.76% -1.36
2.00 4.00 2.64 0.66
innodb select_2_rows 3.00 -5.66% -0.16
2.00 4.00 2.84 0.69
innodb select_big 12.00 +1.00% 0.12
0.00 31.00 12.12 1.56
innodb select_big_str 1.00 +13.16% 0.15
0.00 2.00 1.15 0.36
innodb select_cache 64.00 -7.70% -4.57
49.00 77.00 59.43 5.63
innodb select_cache2 65.00 -8.60% -5.15
49.00 75.00 59.85 6.38
innodb select_column+column 4.00 -38.74% -1.12
2.00 4.00 2.88 0.70
innodb select_diff_key 0.00 +100.00% 0.21
0.00 1.00 0.21 0.41
innodb select_distinct 5.00 -18.44% -0.78
3.00 8.00 4.22 0.54
innodb select_group 18.00 -10.90% -1.77
4.00 136.00 16.23 5.56
innodb select_group_when_MANY_tables 11.00 -17.91% -1.67
3.00 49.00 9.33 9.67
innodb select_join 1.00 -72.84% -0.42
0.00 1.00 0.58 0.49
innodb select_key 64.00 -22.66% -11.82
40.00 66.00 52.18 7.18
innodb select_key2 71.00 -20.66% -12.16
45.00 75.00 58.84 8.07
innodb select_key2_return_key 69.00 -22.85% -12.83
42.00 70.00 56.17 7.84
innodb select_key2_return_prim 70.00 -22.97% -13.07
42.00 72.00 56.93 7.99
innodb select_key_prefix 71.00 -22.25% -12.92
44.00 75.00 58.08 8.06
innodb select_key_prefix_join 5.00 -6.37% -0.30
3.00 10.00 4.70 0.66
innodb select_key_return_key 64.00 -25.00% -12.80
38.00 65.00 51.20 7.19
innodb select_many_fields 13.00 +13.51% 2.03
11.00 19.00 15.03 1.79
innodb select_range 41.00 +13.34% 6.31
39.00 76.00 47.31 3.89
innodb select_range_key2 10.00 -22.04% -1.81
6.00 11.00 8.19 1.02
innodb select_range_prefix 9.00 -15.90% -1.23
5.00 10.00 7.77 1.08
innodb select_simple 2.00 -23.00% -0.37
1.00 3.00 1.63 0.51
innodb select_simple_cache 2.00 -30.63% -0.47
1.00 3.00 1.53 0.52
innodb select_simple_join 1.00 -54.03% -0.35
0.00 3.00 0.65 0.48
innodb update_autocommit 4.00 -20.68% -0.69
2.00 16.00 3.31 1.03
innodb update_big 56.00 -10.73% -5.43
31.00 195.00 50.57 25.01
innodb update_commit 2.00 -29.75% -0.46
1.00 10.00 1.54 0.74
innodb update_of_key 23.00 +5.45% 1.33
18.00 100.00 24.33 6.31
innodb update_of_key_big 31.00 -14.70% -3.97
15.00 75.00 27.03 11.05
innodb update_of_primary_key_many_keys 1313.00 -6.46% -79.66
647.00 6065.00 1233.34 990.15
innodb update_rollback 2.00 -14.77% -0.26
1.00 31.00 1.74 1.95
innodb update_with_key 122.00 -11.68% -12.76
90.00 598.00 109.24 21.12
innodb update_with_key_prefix 42.00 -6.66% -2.62
33.00 202.00 39.38 6.88
innodb wisc_benchmark 3.00 -21.42% -0.53
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2158.1.3: Lee Bieber 2011-02-11 [merge] Merge Stewart - 716852: drizzle
--prompt doesn't work
2155.5.1: Stewart Smith 2011-02-11 drizzle command line client wasn't
respecting --prompt cmd line parameter.
2158.1.2: Lee Bieber 2011-02-11 [merge] Merge Stewart - 716850: day and month
names aren't i8n'd in drizzle.cc
2155.4.1: Stewart Smith 2011-02-11 make day names and month names in
drizzle client (for prompt) internationalizable
2158.1.1: Lee Bieber 2011-02-11 [merge] Merge Stewart - updates to SEAPITester
1947.1.23: Stewart Smith 2011-02-11 fix up savepoint states in SEAPITester
1947.1.22: Stewart Smith 2011-02-11 update savepoint_txn test to check what
SEAPI methods being called
1947.1.21: Stewart Smith 2011-02-11 [merge] merge trunk
1947.1.20: Stewart Smith 2010-12-15 start a test for SEAPITester for
savepoints. Taking David's small test case r.e. txn log and savepoints and
adding engine_state transitions for savepoints. Currently, from looking at the
log you can see that the calls are never made to the engine and the test case
fails (because the savepoint wasn't created
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
