=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 1008
RUN DATE: 2011-04-19T14:27:40.091218
SERVER: drizzled
VERSION: staging
REVISION: 2282
COMMENT: 2282: Brian Aker 2011-04-19 [merge] Merge of build trees.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -3.90% -1.20
25.00 35.00 30.80 3.31
innodb alter_table_drop 23.00 +3.36% 0.80
23.00 24.00 23.80 0.40
innodb connect 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
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 +16.67% 0.40
2.00 3.00 2.40 0.49
innodb count 16.00 -6.67% -1.00
13.00 18.00 15.00 1.79
innodb count_distinct 8.00 -14.29% -1.00
6.00 8.00 7.00 0.63
innodb count_distinct_2 15.00 -4.17% -0.60
14.00 15.00 14.40 0.49
innodb count_distinct_big 21.00 +3.67% 0.80
21.00 25.00 21.80 1.60
innodb count_distinct_group 15.00 -7.14% -1.00
12.00 15.00 14.00 1.10
innodb count_distinct_group_on_key 10.00 +5.66% 0.60
9.00 12.00 10.60 1.02
innodb count_distinct_group_on_key_parts 14.00 -9.38% -1.20
10.00 14.00 12.80 1.47
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 12.00 -7.14% -0.80
11.00 12.00 11.20 0.40
innodb count_on_key 99.00 -2.91% -2.80
92.00 99.00 96.20 3.06
innodb create+drop 33.00 +1.20% 0.40
33.00 35.00 33.40 0.80
innodb create_index 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb create_key+drop 30.00 +5.66% 1.80
30.00 34.00 31.80 1.33
innodb create_MANY_tables 21.00 -3.96% -0.80
19.00 21.00 20.20 0.75
innodb create_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 765.00 +17.32% 160.20
765.00 1227.00 925.20 165.49
innodb delete_autocommit 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb delete_big 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 764.00 +17.35% 160.40
764.00 1226.00 924.40 165.35
innodb delete_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb delete_key 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb delete_range 9.00 -7.14% -0.60
8.00 9.00 8.40 0.49
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 18.00 +4.26% 0.80
18.00 20.00 18.80 0.75
innodb insert 111.00 +0.89% 1.00
111.00 113.00 112.00 0.63
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb insert_duplicates 19.00 -0.00% 0.00
19.00 19.00 19.00 0.00
innodb insert_key 282.00 +0.70% 2.00
277.00 296.00 284.00 6.72
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 +25.93% 1.40
4.00 6.00 5.40 0.80
innodb insert_select_2_keys 7.00 -12.90% -0.80
6.00 7.00 6.20 0.40
innodb min_max 8.00 -8.11% -0.60
6.00 9.00 7.40 1.02
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 -7.14% -0.40
5.00 6.00 5.60 0.49
innodb once_prepared_select 29.00 -0.00% 0.00
29.00 29.00 29.00 0.00
innodb order_by_big 15.00 -10.29% -1.40
12.00 15.00 13.60 1.20
innodb order_by_big_key 13.00 +9.72% 1.40
13.00 15.00 14.40 0.80
innodb order_by_big_key2 13.00 -1.56% -0.20
12.00 14.00 12.80 0.75
innodb order_by_big_key_desc 14.00 +7.89% 1.20
14.00 16.00 15.20 0.75
innodb order_by_big_key_diff 13.00 -1.56% -0.20
12.00 14.00 12.80 0.75
innodb order_by_big_key_prefix 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
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 -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 24.00 -10.09% -2.20
18.00 24.00 21.80 2.71
innodb outer_join_found 24.00 -17.65% -3.60
17.00 24.00 20.40 2.58
innodb outer_join_not_found 20.00 -8.70% -1.60
15.00 21.00 18.40 2.42
innodb outer_join_on_key 15.00 -10.29% -1.40
11.00 15.00 13.60 1.74
innodb prepared_select 37.00 -0.00% 0.00
37.00 37.00 37.00 0.00
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 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_big 13.00 -4.84% -0.60
12.00 13.00 12.40 0.49
innodb select_big_str 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb select_cache 63.00 +0.63% 0.40
57.00 70.00 63.40 5.00
innodb select_cache2 64.00 +3.03% 2.00
63.00 72.00 66.00 3.29
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_diff_key 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb select_distinct 5.00 -8.70% -0.40
4.00 5.00 4.60 0.49
innodb select_group 18.00 -5.88% -1.00
16.00 19.00 17.00 1.26
innodb select_group_when_MANY_tables 11.00 +9.84% 1.20
11.00 13.00 12.20 0.75
innodb select_join 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb select_key 63.00 +1.25% 0.80
63.00 65.00 63.80 0.75
innodb select_key2 70.00 +0.28% 0.20
70.00 71.00 70.20 0.40
innodb select_key2_return_key 68.00 -0.29% -0.20
67.00 69.00 67.80 0.75
innodb select_key2_return_prim 68.00 +0.87% 0.60
68.00 69.00 68.60 0.49
innodb select_key_prefix 70.00 -0.00% 0.00
69.00 71.00 70.00 0.63
innodb select_key_prefix_join 5.00 +7.41% 0.40
5.00 6.00 5.40 0.49
innodb select_key_return_key 62.00 +1.27% 0.80
62.00 64.00 62.80 0.75
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 46.00 +2.54% 1.20
41.00 52.00 47.20 3.66
innodb select_range_key2 9.00 +2.17% 0.20
9.00 10.00 9.20 0.40
innodb select_range_prefix 10.00 -4.17% -0.40
9.00 10.00 9.60 0.49
innodb select_simple 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
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 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb update_big 57.00 +2.06% 1.20
57.00 60.00 58.20 1.17
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 22.00 -0.92% -0.20
21.00 23.00 21.80 0.75
innodb update_of_key_big 19.00 -1.06% -0.20
18.00 20.00 18.80 0.75
innodb update_of_primary_key_many_keys 1290.00 -0.78% -10.00
1246.00 1306.00 1280.00 20.03
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 118.00 -0.17% -0.20
116.00 120.00 117.80 1.33
innodb update_with_key_prefix 44.00 -3.29% -1.40
40.00 45.00 42.60 1.85
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 -0.63% -0.20
25.00 35.00 31.80 2.06
innodb alter_table_drop 23.00 +1.92% 0.45
22.00 25.00 23.45 0.74
innodb connect 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
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 +25.93% 0.70
2.00 3.00 2.70 0.46
innodb count 16.00 -0.95% -0.15
13.00 18.00 15.85 1.80
innodb count_distinct 8.00 -17.65% -1.20
6.00 8.00 6.80 0.75
innodb count_distinct_2 15.00 -9.89% -1.35
11.00 16.00 13.65 1.49
innodb count_distinct_big 21.00 +8.30% 1.90
20.00 25.00 22.90 1.87
innodb count_distinct_group 15.00 -5.63% -0.80
11.00 16.00 14.20 1.44
innodb count_distinct_group_on_key 10.00 +0.50% 0.05
8.00 12.00 10.05 1.12
innodb count_distinct_group_on_key_parts 14.00 -7.69% -1.00
10.00 15.00 13.00 1.45
innodb count_distinct_key_prefix 5.00 +2.91% 0.15
4.00 6.00 5.15 0.65
innodb count_group_on_key_parts 12.00 -7.14% -0.80
10.00 12.00 11.20 0.51
innodb count_on_key 99.00 -3.23% -3.10
92.00 103.00 95.90 2.96
innodb create+drop 33.00 +0.15% 0.05
31.00 35.00 33.05 0.92
innodb create_index 3.00 +1.64% 0.05
2.00 4.00 3.05 0.38
innodb create_key+drop 30.00 +5.51% 1.75
28.00 36.00 31.75 1.58
innodb create_MANY_tables 21.00 -3.19% -0.65
19.00 22.00 20.35 0.65
innodb create_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb delete_all_many_keys 765.00 +3.99% 31.80
553.00 1227.00 796.80 176.67
innodb delete_autocommit 3.00 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb delete_big 1.00 -300.00% -0.75
0.00 1.00 0.25 0.43
innodb delete_big_many_keys 764.00 +4.03% 32.10
553.00 1226.00 796.10 176.61
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 9.00 -6.51% -0.55
8.00 10.00 8.45 0.59
innodb delete_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb drop_index 4.00 -26.98% -0.85
2.00 4.00 3.15 0.48
innodb drop_table_when_MANY_tables 18.00 +3.49% 0.65
17.00 20.00 18.65 0.79
innodb insert 111.00 +1.77% 2.00
111.00 117.00 113.00 1.55
innodb insert_autocommit 3.00 +3.23% 0.10
3.00 4.00 3.10 0.30
innodb insert_commit 2.00 -8.11% -0.15
1.00 2.00 1.85 0.36
innodb insert_duplicates 19.00 +1.30% 0.25
19.00 20.00 19.25 0.43
innodb insert_key 282.00 -1.22% -3.40
260.00 307.00 278.60 10.75
innodb insert_many_fields 6.00 -4.35% -0.25
5.00 7.00 5.75 0.54
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 +15.79% 0.75
3.00 6.00 4.75 0.89
innodb insert_select_2_keys 7.00 -14.75% -0.90
5.00 7.00 6.10 0.54
innodb min_max 8.00 -3.90% -0.30
6.00 9.00 7.70 1.14
innodb min_max_on_key 25.00 -2.25% -0.55
24.00 25.00 24.45 0.50
innodb multiple_value_insert 6.00 -0.84% -0.05
5.00 7.00 5.95 0.67
innodb once_prepared_select 29.00 -0.87% -0.25
28.00 29.00 28.75 0.43
innodb order_by_big 15.00 -6.76% -0.95
12.00 15.00 14.05 1.07
innodb order_by_big_key 13.00 +10.34% 1.50
12.00 16.00 14.50 1.16
innodb order_by_big_key2 13.00 -1.56% -0.20
11.00 14.00 12.80 1.12
innodb order_by_big_key_desc 14.00 +6.98% 1.05
13.00 16.00 15.05 0.97
innodb order_by_big_key_diff 13.00 -0.39% -0.05
12.00 14.00 12.95 0.67
innodb order_by_big_key_prefix 13.00 -1.17% -0.15
12.00 14.00 12.85 0.57
innodb order_by_key2_diff 1.00 +35.48% 0.55
1.00 2.00 1.55 0.50
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 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 24.00 -6.90% -1.55
17.00 26.00 22.45 2.85
innodb outer_join_found 24.00 -12.68% -2.70
17.00 24.00 21.30 2.55
innodb outer_join_not_found 20.00 -3.63% -0.70
15.00 22.00 19.30 2.33
innodb outer_join_on_key 15.00 -3.09% -0.45
11.00 17.00 14.55 1.77
innodb prepared_select 37.00 -0.68% -0.25
36.00 37.00 36.75 0.43
innodb select_1_row 3.00 +15.49% 0.55
3.00 4.00 3.55 0.50
innodb select_1_row_cache 4.00 -15.94% -0.55
3.00 4.00 3.45 0.50
innodb select_2_rows 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_big 13.00 -1.96% -0.25
11.00 15.00 12.75 0.99
innodb select_big_str 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb select_cache 63.00 +1.49% 0.95
57.00 70.00 63.95 2.80
innodb select_cache2 64.00 +1.16% 0.75
61.00 76.00 64.75 3.87
innodb select_column+column 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb select_diff_key 1.00 -566.67% -0.85
0.00 1.00 0.15 0.36
innodb select_distinct 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_group 18.00 -6.51% -1.10
15.00 19.00 16.90 1.48
innodb select_group_when_MANY_tables 11.00 +7.56% 0.90
11.00 13.00 11.90 0.62
innodb select_join 1.00 -53.85% -0.35
0.00 1.00 0.65 0.48
innodb select_key 63.00 +1.10% 0.70
63.00 65.00 63.70 0.64
innodb select_key2 70.00 +0.43% 0.30
69.00 71.00 70.30 0.64
innodb select_key2_return_key 68.00 -0.44% -0.30
67.00 69.00 67.70 0.56
innodb select_key2_return_prim 68.00 +0.66% 0.45
67.00 70.00 68.45 0.67
innodb select_key_prefix 70.00 -0.14% -0.10
69.00 71.00 69.90 0.54
innodb select_key_prefix_join 5.00 +4.76% 0.25
5.00 6.00 5.25 0.43
innodb select_key_return_key 62.00 +0.80% 0.50
61.00 64.00 62.50 0.81
innodb select_many_fields 13.00 +3.70% 0.50
13.00 17.00 13.50 0.92
innodb select_range 46.00 -0.44% -0.20
41.00 52.00 45.80 3.23
innodb select_range_key2 9.00 +4.76% 0.45
9.00 10.00 9.45 0.50
innodb select_range_prefix 10.00 -6.38% -0.60
8.00 10.00 9.40 0.58
innodb select_simple 3.00 -46.34% -0.95
2.00 3.00 2.05 0.22
innodb select_simple_cache 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb select_simple_join 1.00 -17.65% -0.15
0.00 1.00 0.85 0.36
innodb update_autocommit 4.00 -15.94% -0.55
3.00 4.00 3.45 0.50
innodb update_big 57.00 +2.98% 1.75
56.00 62.00 58.75 1.58
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 22.00 +1.57% 0.35
21.00 24.00 22.35 0.79
innodb update_of_key_big 19.00 +27.62% 7.25
18.00 46.00 26.25 9.18
innodb update_of_primary_key_many_keys 1290.00 -0.50% -6.45
1123.00 1435.00 1283.55 71.07
innodb update_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb update_with_key 118.00 +1.26% 1.50
115.00 125.00 119.50 2.97
innodb update_with_key_prefix 44.00 -0.80% -0.35
40.00 47.00 43.65 2.15
innodb wisc_benchmark 2.00 +27.27% 0.75
2.00 3.00 2.75 0.43
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -45.89% -10.07
11.00 61.00 21.93 10.16
innodb alter_table_drop 23.00 -22.26% -4.19
10.00 57.00 18.81 6.84
innodb connect 2.00 +4.35% 0.09
1.00 3.00 2.09 0.42
innodb connect+select_1_row 3.00 -10.22% -0.28
2.00 5.00 2.72 0.46
innodb connect+select_simple 2.00 +15.58% 0.37
1.00 3.00 2.37 0.49
innodb count 16.00 -1.62% -0.26
12.00 193.00 15.74 8.48
innodb count_distinct 8.00 -21.44% -1.41
5.00 50.00 6.59 2.19
innodb count_distinct_2 15.00 -13.35% -1.77
11.00 63.00 13.23 2.86
innodb count_distinct_big 21.00 +4.59% 1.01
5.00 67.00 22.01 2.96
innodb count_distinct_group 15.00 -13.15% -1.74
10.00 68.00 13.26 3.01
innodb count_distinct_group_on_key 10.00 -5.12% -0.49
7.00 69.00 9.51 2.91
innodb count_distinct_group_on_key_parts 14.00 -13.00% -1.61
9.00 72.00 12.39 3.05
innodb count_distinct_key_prefix 5.00 +2.83% 0.15
3.00 52.00 5.15 2.30
innodb count_group_on_key_parts 12.00 -19.28% -1.94
7.00 72.00 10.06 3.04
innodb count_on_key 99.00 -14.24% -12.34
68.00 107.00 86.66 7.48
innodb create+drop 33.00 -1.55% -0.50
18.00 75.00 32.50 11.41
innodb create_index 3.00 -3.24% -0.09
1.00 8.00 2.91 1.10
innodb create_key+drop 30.00 -5.46% -1.55
21.00 50.00 28.45 4.80
innodb create_MANY_tables 21.00 +36.37% 12.00
14.00 121.00 33.00 16.80
innodb create_table 0.00 +100.00% 0.10
0.00 3.00 0.10 0.35
innodb delete_all_many_keys 765.00 -58.61% -282.67
212.00 1888.00 482.33 356.07
innodb delete_autocommit 3.00 +13.22% 0.46
2.00 14.00 3.46 0.74
innodb delete_big 1.00 -228.87% -0.70
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 764.00 -56.62% -276.20
212.00 2293.00 487.80 369.16
innodb delete_commit 2.00 -29.90% -0.46
1.00 5.00 1.54 0.53
innodb delete_key 3.00 +1.13% 0.03
2.00 35.00 3.03 1.44
innodb delete_range 9.00 -8.06% -0.67
5.00 23.00 8.33 3.11
innodb delete_rollback 2.00 -13.08% -0.23
1.00 12.00 1.77 0.89
innodb drop_index 4.00 -35.31% -1.04
1.00 9.00 2.96 1.27
innodb drop_table 0.00 +100.00% 0.04
0.00 2.00 0.04 0.22
innodb drop_table_when_MANY_tables 18.00 +7.69% 1.50
11.00 90.00 19.50 7.23
innodb insert 111.00 -3.52% -3.77
3.00 343.00 107.23 14.13
innodb insert_autocommit 3.00 +0.36% 0.01
2.00 99.00 3.01 3.18
innodb insert_commit 2.00 -41.30% -0.58
1.00 3.00 1.42 0.50
innodb insert_duplicates 19.00 -20.61% -3.25
11.00 21.00 15.75 2.74
innodb insert_key 282.00 +6.34% 19.10
142.00 700.00 301.10 102.61
innodb insert_many_fields 6.00 -6.76% -0.38
3.00 17.00 5.62 1.71
innodb insert_rollback 2.00 -18.08% -0.31
1.00 3.00 1.69 0.52
innodb insert_select_1_key 4.00 -5.01% -0.19
2.00 10.00 3.81 0.88
innodb insert_select_2_keys 7.00 -15.14% -0.92
4.00 16.00 6.08 2.01
innodb min_max 8.00 -2.33% -0.18
6.00 110.00 7.82 4.37
innodb min_max_on_key 25.00 -19.91% -4.15
14.00 37.00 20.85 3.15
innodb multiple_value_insert 6.00 -8.55% -0.47
2.00 50.00 5.53 4.12
innodb once_prepared_select 29.00 -17.98% -4.42
18.00 32.00 24.58 3.66
innodb order_by_big 15.00 -4.89% -0.70
12.00 31.00 14.30 1.50
innodb order_by_big_key 13.00 +2.60% 0.35
11.00 32.00 13.35 1.64
innodb order_by_big_key2 13.00 -6.14% -0.75
10.00 33.00 12.25 1.52
innodb order_by_big_key_desc 14.00 -2.87% -0.39
11.00 32.00 13.61 1.69
innodb order_by_big_key_diff 13.00 -5.81% -0.71
10.00 31.00 12.29 1.48
innodb order_by_big_key_prefix 13.00 -4.46% -0.56
10.00 32.00 12.44 1.52
innodb order_by_key2_diff 1.00 +28.62% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -25.57% -0.20
0.00 2.00 0.80 0.41
innodb order_by_range 1.00 -19.46% -0.16
0.00 2.00 0.84 0.38
innodb outer_join 24.00 -22.74% -4.45
15.00 61.00 19.55 3.72
innodb outer_join_found 24.00 -26.63% -5.05
14.00 58.00 18.95 3.56
innodb outer_join_not_found 20.00 -19.91% -3.32
12.00 46.00 16.68 3.20
innodb outer_join_on_key 15.00 -15.00% -1.96
10.00 59.00 13.04 2.75
innodb prepared_select 37.00 -16.52% -5.25
22.00 40.00 31.75 4.58
innodb select_1_row 3.00 -3.35% -0.10
2.00 4.00 2.90 0.70
innodb select_1_row_cache 4.00 -45.87% -1.26
2.00 4.00 2.74 0.71
innodb select_2_rows 3.00 -2.26% -0.07
2.00 4.00 2.93 0.71
innodb select_big 13.00 -6.62% -0.81
0.00 31.00 12.19 1.52
innodb select_big_str 2.00 -69.50% -0.82
0.00 2.00 1.18 0.39
innodb select_cache 63.00 -5.13% -3.07
49.00 77.00 59.93 5.57
innodb select_cache2 64.00 -6.11% -3.69
49.00 76.00 60.31 6.21
innodb select_column+column 4.00 -33.81% -1.01
2.00 4.00 2.99 0.73
innodb select_diff_key 1.00 -350.72% -0.78
0.00 1.00 0.22 0.42
innodb select_distinct 5.00 -17.37% -0.74
3.00 8.00 4.26 0.55
innodb select_group 18.00 -10.43% -1.70
4.00 136.00 16.30 5.23
innodb select_group_when_MANY_tables 11.00 -13.94% -1.35
3.00 49.00 9.65 9.11
innodb select_join 1.00 -72.51% -0.42
0.00 1.00 0.58 0.49
innodb select_key 63.00 -17.53% -9.40
40.00 66.00 53.60 7.74
innodb select_key2 70.00 -16.09% -9.70
45.00 75.00 60.30 8.51
innodb select_key2_return_key 68.00 -17.98% -10.36
42.00 71.00 57.64 8.34
innodb select_key2_return_prim 68.00 -16.44% -9.60
42.00 72.00 58.40 8.48
innodb select_key_prefix 70.00 -17.48% -10.42
44.00 75.00 59.58 8.57
innodb select_key_prefix_join 5.00 -5.20% -0.25
3.00 10.00 4.75 0.65
innodb select_key_return_key 62.00 -17.83% -9.38
38.00 65.00 52.62 7.74
innodb select_many_fields 13.00 +12.26% 1.82
11.00 19.00 14.82 1.79
innodb select_range 46.00 +1.69% 0.79
38.00 76.00 46.79 4.06
innodb select_range_key2 9.00 -7.75% -0.65
6.00 11.00 8.35 1.07
innodb select_range_prefix 10.00 -25.84% -2.05
5.00 10.00 7.95 1.15
innodb select_simple 3.00 -78.78% -1.32
1.00 3.00 1.68 0.51
innodb select_simple_cache 2.00 -25.76% -0.41
1.00 3.00 1.59 0.51
innodb select_simple_join 1.00 -49.12% -0.33
0.00 3.00 0.67 0.48
innodb update_autocommit 4.00 -19.36% -0.65
2.00 16.00 3.35 0.99
innodb update_big 57.00 -10.46% -5.40
31.00 195.00 51.60 23.60
innodb update_commit 2.00 -25.62% -0.41
1.00 10.00 1.59 0.71
innodb update_of_key 22.00 +8.61% 2.07
18.00 100.00 24.07 5.96
innodb update_of_key_big 19.00 +31.91% 8.91
15.00 75.00 27.91 10.84
innodb update_of_primary_key_many_keys 1290.00 -3.36% -41.94
647.00 6065.00 1248.06 911.71
innodb update_rollback 2.00 -11.99% -0.21
1.00 31.00 1.79 1.83
innodb update_with_key 118.00 -6.61% -7.32
90.00 598.00 110.68 20.18
innodb update_with_key_prefix 44.00 -10.09% -4.03
33.00 202.00 39.97 6.68
innodb wisc_benchmark 2.00 +19.48% 0.48
2.00 5.00 2.48 0.52
=========================================================================================================================
FULL REVISION COMMENTARY:
2281.2.3: Brian Aker 2011-04-19 Argument cleanup on shutdown command.
2281.2.2: Brian Aker 2011-04-19 [merge] Merge in fix for shortcut for CLI
2279.3.1: Jay Janssen 2011-04-16 Changed client/drizzle 'shutdown' shortcut
to 'Q' (i.e., '\Q' on the drizzle command line).
2281.2.1: Brian Aker 2011-04-19 [merge] Merge in Andrew
2281.1.1: Andrew Hutchings 2011-04-19 Don't continue if we can't figure out
what the server is
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
