=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 775
RUN DATE: 2010-12-30T10:15:51.716634
SERVER: drizzled
VERSION: staging
REVISION: 2041
COMMENT: 2041: Brian Aker 2010-12-30 [merge] Rollup of assert(), etc.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 44.00 -11.68% -4.60
29.00 50.00 39.40 7.79
innodb alter_table_drop 31.00 +7.74% 2.60
28.00 45.00 33.60 6.02
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 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb count 17.00 -7.59% -1.20
14.00 17.00 15.80 1.47
innodb count_distinct 6.00 +9.09% 0.60
6.00 8.00 6.60 0.80
innodb count_distinct_2 12.00 +1.64% 0.20
12.00 13.00 12.20 0.40
innodb count_distinct_big 25.00 -17.92% -3.80
19.00 25.00 21.20 2.14
innodb count_distinct_group 15.00 -1.35% -0.20
14.00 15.00 14.80 0.40
innodb count_distinct_group_on_key 10.00 -4.17% -0.40
8.00 12.00 9.60 1.36
innodb count_distinct_group_on_key_parts 14.00 -0.00% 0.00
14.00 14.00 14.00 0.00
innodb count_distinct_key_prefix 6.00 -15.38% -0.80
4.00 6.00 5.20 0.75
innodb count_group_on_key_parts 10.00 +9.09% 1.00
10.00 12.00 11.00 0.63
innodb count_on_key 91.00 +1.52% 1.40
90.00 95.00 92.40 1.85
innodb create+drop 69.00 -16.16% -9.60
46.00 71.00 59.40 10.78
innodb create_index 6.00 -7.14% -0.40
4.00 6.00 5.60 0.80
innodb create_key+drop 39.00 -4.84% -1.80
32.00 43.00 37.20 4.45
innodb create_MANY_tables 59.00 -7.27% -4.00
43.00 61.00 55.00 6.57
innodb delete_all_many_keys 1443.00 -29.37% -327.60
415.00 1884.00 1115.40 590.63
innodb delete_autocommit 14.00 -150.00% -8.40
3.00 14.00 5.60 4.22
innodb delete_big 3.00 -114.29% -1.60
1.00 3.00 1.40 0.80
innodb delete_big_many_keys 1441.00 -29.40% -327.40
415.00 1881.00 1113.60 589.57
innodb delete_commit 2.00 -0.00% 0.00
1.00 3.00 2.00 0.63
innodb delete_key 3.00 +21.05% 0.80
3.00 5.00 3.80 0.75
innodb delete_range 20.00 -17.65% -3.00
12.00 22.00 17.00 3.90
innodb delete_rollback 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb drop_index 5.00 +24.24% 1.60
5.00 9.00 6.60 1.62
innodb drop_table 0.00 +100.00% 0.40
0.00 2.00 0.40 0.80
innodb drop_table_when_MANY_tables 32.00 -0.63% -0.20
21.00 40.00 31.80 7.19
innodb insert 124.00 -4.55% -5.40
112.00 124.00 118.60 4.45
innodb insert_autocommit 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb insert_commit 1.00 +37.50% 0.60
1.00 2.00 1.60 0.49
innodb insert_duplicates 19.00 +1.04% 0.20
18.00 20.00 19.20 0.75
innodb insert_key 737.00 -22.71% -136.40
310.00 876.00 600.60 235.00
innodb insert_many_fields 8.00 +2.44% 0.20
7.00 9.00 8.20 0.75
innodb insert_rollback 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
innodb insert_select_1_key 5.00 -13.64% -0.60
3.00 6.00 4.40 1.20
innodb insert_select_2_keys 11.00 -1.85% -0.20
9.00 13.00 10.80 1.60
innodb min_max 9.00 -12.50% -1.00
6.00 9.00 8.00 1.26
innodb min_max_on_key 25.00 -3.31% -0.80
23.00 25.00 24.20 0.75
innodb multiple_value_insert 13.00 -22.64% -2.40
5.00 16.00 10.60 4.32
innodb once_prepared_select 30.00 -1.35% -0.40
29.00 30.00 29.60 0.49
innodb order_by_big 16.00 -9.59% -1.40
13.00 16.00 14.60 1.36
innodb order_by_big_key 14.00 -6.06% -0.80
12.00 14.00 13.20 0.98
innodb order_by_big_key2 13.00 -4.84% -0.60
11.00 14.00 12.40 1.20
innodb order_by_big_key_desc 14.00 -0.00% 0.00
13.00 15.00 14.00 0.89
innodb order_by_big_key_diff 12.00 +1.64% 0.20
11.00 14.00 12.20 1.17
innodb order_by_big_key_prefix 14.00 -9.38% -1.20
11.00 14.00 12.80 1.17
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 18.00 +13.46% 2.80
18.00 23.00 20.80 1.94
innodb outer_join_found 17.00 +16.67% 3.40
17.00 24.00 20.40 2.87
innodb outer_join_not_found 15.00 +13.79% 2.40
15.00 20.00 17.40 1.74
innodb outer_join_on_key 12.00 +14.29% 2.00
12.00 17.00 14.00 1.90
innodb prepared_select 37.00 +0.54% 0.20
37.00 38.00 37.20 0.40
innodb select_1_row 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_1_row_cache 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb select_2_rows 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_big 13.00 -4.84% -0.60
11.00 14.00 12.40 1.20
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 58.00 +9.09% 5.80
58.00 71.00 63.80 4.40
innodb select_cache2 59.00 +8.10% 5.20
58.00 71.00 64.20 5.19
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.20
0.00 1.00 0.20 0.40
innodb select_distinct 4.00 +13.04% 0.60
4.00 5.00 4.60 0.49
innodb select_group 16.00 -3.90% -0.60
15.00 16.00 15.40 0.49
innodb select_group_when_MANY_tables 42.00 -19.32% -6.80
23.00 46.00 35.20 9.70
innodb select_join 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb select_key 64.00 -0.63% -0.40
63.00 64.00 63.60 0.49
innodb select_key2 71.00 -0.57% -0.40
69.00 72.00 70.60 1.02
innodb select_key2_return_key 68.00 -0.29% -0.20
67.00 68.00 67.80 0.40
innodb select_key2_return_prim 69.00 -0.58% -0.40
67.00 70.00 68.60 1.02
innodb select_key_prefix 70.00 +0.28% 0.20
69.00 72.00 70.20 0.98
innodb select_key_prefix_join 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb select_key_return_key 62.00 +0.64% 0.40
62.00 63.00 62.40 0.49
innodb select_many_fields 12.00 +3.23% 0.40
11.00 13.00 12.40 0.80
innodb select_range 45.00 -6.13% -2.60
40.00 45.00 42.40 2.06
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
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 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb update_autocommit 5.00 -25.00% -1.00
3.00 5.00 4.00 0.63
innodb update_big 152.00 -9.04% -12.60
95.00 195.00 139.40 36.62
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 23.00 -2.68% -0.60
22.00 23.00 22.40 0.49
innodb update_of_key_big 51.00 -7.59% -3.60
41.00 56.00 47.40 5.39
innodb update_of_primary_key_many_keys 3032.00 -28.43% -671.20
945.00 3761.00 2360.80 1,153.65
innodb update_rollback 4.00 -53.85% -1.40
2.00 4.00 2.60 0.80
innodb update_with_key 138.00 -5.50% -7.20
119.00 141.00 130.80 9.04
innodb update_with_key_prefix 46.00 -1.77% -0.80
41.00 49.00 45.20 2.86
innodb wisc_benchmark 3.00 -15.38% -0.40
2.00 4.00 2.60 0.80
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 44.00 -31.93% -10.65
18.00 50.00 33.35 8.96
innodb alter_table_drop 31.00 -13.35% -3.65
15.00 45.00 27.35 7.89
innodb connect 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
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 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb count 17.00 -4.29% -0.70
13.00 18.00 16.30 1.79
innodb count_distinct 6.00 +11.76% 0.80
6.00 8.00 6.80 0.81
innodb count_distinct_2 12.00 +9.77% 1.30
12.00 16.00 13.30 1.31
innodb count_distinct_big 25.00 -10.62% -2.40
19.00 25.00 22.60 2.03
innodb count_distinct_group 15.00 -1.01% -0.15
13.00 17.00 14.85 0.91
innodb count_distinct_group_on_key 10.00 -0.50% -0.05
8.00 12.00 9.95 1.28
innodb count_distinct_group_on_key_parts 14.00 -1.08% -0.15
12.00 15.00 13.85 1.01
innodb count_distinct_key_prefix 6.00 -13.21% -0.70
4.00 7.00 5.30 0.71
innodb count_group_on_key_parts 10.00 +9.09% 1.00
10.00 12.00 11.00 0.55
innodb count_on_key 91.00 +3.81% 3.60
90.00 100.00 94.60 2.24
innodb create+drop 69.00 -35.69% -18.15
33.00 71.00 50.85 11.96
innodb create_index 6.00 -27.66% -1.30
3.00 7.00 4.70 1.23
innodb create_key+drop 39.00 -15.38% -5.20
28.00 43.00 33.80 4.97
innodb create_MANY_tables 59.00 -34.24% -15.05
22.00 64.00 43.95 12.46
innodb create_table 0.00 +100.00% 0.20
0.00 2.00 0.20 0.51
innodb delete_all_many_keys 1443.00 -84.95% -662.80
276.00 1884.00 780.20 524.54
innodb delete_autocommit 14.00 -204.35% -9.40
3.00 14.00 4.60 2.62
innodb delete_big 3.00 -233.33% -2.10
0.00 3.00 0.90 0.70
innodb delete_big_many_keys 1441.00 -84.95% -661.85
276.00 1881.00 779.15 523.71
innodb delete_commit 2.00 +6.98% 0.15
1.00 5.00 2.15 0.73
innodb delete_key 3.00 +7.69% 0.25
2.00 5.00 3.25 0.94
innodb delete_range 20.00 -48.15% -6.50
8.00 22.00 13.50 4.09
innodb delete_rollback 3.00 -27.66% -0.65
2.00 3.00 2.35 0.48
innodb drop_index 5.00 -7.53% -0.35
2.00 9.00 4.65 1.88
innodb drop_table 0.00 +100.00% 0.15
0.00 2.00 0.15 0.48
innodb drop_table_when_MANY_tables 32.00 -22.14% -5.80
16.00 40.00 26.20 7.94
innodb insert 124.00 -6.76% -7.85
110.00 129.00 116.15 5.33
innodb insert_autocommit 3.00 +9.09% 0.30
3.00 4.00 3.30 0.46
innodb insert_commit 1.00 +37.50% 0.60
1.00 2.00 1.60 0.49
innodb insert_duplicates 19.00 +2.06% 0.40
18.00 21.00 19.40 0.73
innodb insert_key 737.00 -61.46% -280.55
181.00 876.00 456.45 225.22
innodb insert_many_fields 8.00 -5.26% -0.40
5.00 11.00 7.60 1.36
innodb insert_rollback 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
innodb insert_select_1_key 5.00 -29.87% -1.15
3.00 6.00 3.85 0.96
innodb insert_select_2_keys 11.00 -20.88% -1.90
6.00 13.00 9.10 2.28
innodb min_max 9.00 -10.43% -0.85
6.00 9.00 8.15 1.06
innodb min_max_on_key 25.00 -2.25% -0.55
23.00 25.00 24.45 0.59
innodb multiple_value_insert 13.00 -74.50% -5.55
3.00 16.00 7.45 4.38
innodb once_prepared_select 30.00 -1.69% -0.50
29.00 30.00 29.50 0.50
innodb order_by_big 16.00 -12.28% -1.75
12.00 16.00 14.25 1.51
innodb order_by_big_key 14.00 -8.53% -1.10
11.00 14.00 12.90 1.14
innodb order_by_big_key2 13.00 -8.33% -1.00
10.00 14.00 12.00 1.26
innodb order_by_big_key_desc 14.00 -1.08% -0.15
12.00 15.00 13.85 1.19
innodb order_by_big_key_diff 12.00 -0.84% -0.10
10.00 14.00 11.90 1.26
innodb order_by_big_key_prefix 14.00 -12.00% -1.50
11.00 14.00 12.50 1.16
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 -11.11% -0.10
0.00 1.00 0.90 0.30
innodb order_by_range 1.00 -11.11% -0.10
0.00 1.00 0.90 0.30
innodb outer_join 18.00 +18.18% 4.00
17.00 25.00 22.00 2.21
innodb outer_join_found 17.00 +19.62% 4.15
17.00 24.00 21.15 2.24
innodb outer_join_not_found 15.00 +20.42% 3.85
15.00 22.00 18.85 2.08
innodb outer_join_on_key 12.00 +17.81% 2.60
11.00 17.00 14.60 1.71
innodb prepared_select 37.00 +0.94% 0.35
36.00 38.00 37.35 0.57
innodb select_1_row 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_1_row_cache 3.00 +9.09% 0.30
3.00 4.00 3.30 0.46
innodb select_2_rows 4.00 -2.56% -0.10
3.00 4.00 3.90 0.30
innodb select_big 13.00 -7.00% -0.85
11.00 14.00 12.15 1.11
innodb select_big_str 1.00 +13.04% 0.15
1.00 2.00 1.15 0.36
innodb select_cache 58.00 +7.20% 4.50
57.00 71.00 62.50 3.04
innodb select_cache2 59.00 +8.10% 5.20
58.00 71.00 64.20 3.41
innodb select_column+column 4.00 -3.90% -0.15
3.00 4.00 3.85 0.36
innodb select_diff_key 0.00 +100.00% 0.20
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 16.00 +3.32% 0.55
15.00 20.00 16.55 1.63
innodb select_group_when_MANY_tables 42.00 -46.85% -13.40
13.00 46.00 28.60 9.57
innodb select_join 1.00 -42.86% -0.30
0.00 1.00 0.70 0.46
innodb select_key 64.00 +0.31% 0.20
63.00 66.00 64.20 0.87
innodb select_key2 71.00 +0.28% 0.20
69.00 73.00 71.20 1.03
innodb select_key2_return_key 68.00 +0.15% 0.10
66.00 70.00 68.10 0.89
innodb select_key2_return_prim 69.00 +0.07% 0.05
67.00 71.00 69.05 0.97
innodb select_key_prefix 70.00 +0.99% 0.70
69.00 72.00 70.70 0.95
innodb select_key_prefix_join 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb select_key_return_key 62.00 +1.27% 0.80
62.00 65.00 62.80 0.81
innodb select_many_fields 12.00 +9.43% 1.25
11.00 16.00 13.25 0.99
innodb select_range 45.00 -6.76% -2.85
39.00 46.00 42.15 2.08
innodb select_range_key2 10.00 -3.63% -0.35
9.00 10.00 9.65 0.48
innodb select_range_prefix 9.00 +2.17% 0.20
8.00 10.00 9.20 0.68
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 -17.65% -0.15
0.00 1.00 0.85 0.36
innodb update_autocommit 5.00 -28.21% -1.10
3.00 7.00 3.90 0.89
innodb update_big 152.00 -39.07% -42.70
55.00 195.00 109.30 37.84
innodb update_commit 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb update_of_key 23.00 -5.75% -1.25
20.00 24.00 21.75 0.94
innodb update_of_key_big 51.00 -20.14% -8.55
26.00 56.00 42.45 7.72
innodb update_of_primary_key_many_keys 3032.00 -77.20% -1320.90
666.00 3761.00 1711.10 1,039.40
innodb update_rollback 4.00 -77.78% -1.75
2.00 4.00 2.25 0.54
innodb update_with_key 138.00 -11.38% -14.10
113.00 141.00 123.90 8.27
innodb update_with_key_prefix 46.00 -5.38% -2.35
40.00 49.00 43.65 2.80
innodb wisc_benchmark 3.00 -13.21% -0.35
2.00 4.00 2.65 0.65
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 44.00 -137.36% -25.46
11.00 61.00 18.54 9.34
innodb alter_table_drop 31.00 -81.14% -13.89
10.00 57.00 17.11 6.97
innodb connect 2.00 +2.27% 0.05
1.00 3.00 2.05 0.41
innodb connect+select_1_row 3.00 -12.90% -0.34
2.00 5.00 2.66 0.49
innodb connect+select_simple 3.00 -30.73% -0.71
1.00 3.00 2.29 0.47
innodb count 17.00 -8.09% -1.27
12.00 193.00 15.73 9.68
innodb count_distinct 6.00 +7.73% 0.50
5.00 50.00 6.50 2.48
innodb count_distinct_2 12.00 +7.95% 1.04
11.00 63.00 13.04 3.18
innodb count_distinct_big 25.00 -14.93% -3.25
5.00 67.00 21.75 3.19
innodb count_distinct_group 15.00 -17.21% -2.20
10.00 68.00 12.80 3.21
innodb count_distinct_group_on_key 10.00 -6.63% -0.62
7.00 69.00 9.38 3.26
innodb count_distinct_group_on_key_parts 14.00 -16.32% -1.96
9.00 72.00 12.04 3.30
innodb count_distinct_key_prefix 6.00 -18.46% -0.94
3.00 52.00 5.06 2.61
innodb count_group_on_key_parts 10.00 -2.80% -0.27
7.00 72.00 9.73 3.41
innodb count_on_key 91.00 -8.00% -6.74
68.00 203.00 84.26 8.01
innodb create+drop 69.00 -112.28% -36.50
18.00 81.00 32.50 13.33
innodb create_index 6.00 -114.20% -3.20
1.00 8.00 2.80 1.19
innodb create_key+drop 39.00 -40.91% -11.32
21.00 50.00 27.68 4.99
innodb create_MANY_tables 59.00 -61.88% -22.55
14.00 121.00 36.45 17.47
innodb create_table 0.00 +100.00% 0.12
0.00 3.00 0.12 0.38
innodb delete_all_many_keys 1443.00 -237.63% -1015.61
212.00 2293.00 427.39 400.92
innodb delete_autocommit 14.00 -312.14% -10.60
2.00 14.00 3.40 0.78
innodb delete_big 3.00 -1086.59% -2.75
0.00 3.00 0.25 0.45
innodb delete_big_many_keys 1441.00 -237.31% -1013.80
212.00 2293.00 427.20 400.67
innodb delete_commit 2.00 -38.42% -0.56
1.00 5.00 1.44 0.53
innodb delete_key 3.00 +3.24% 0.10
2.00 35.00 3.10 1.63
innodb delete_range 20.00 -144.55% -11.82
5.00 23.00 8.18 3.45
innodb delete_rollback 3.00 -87.30% -1.40
1.00 4.00 1.60 0.59
innodb drop_index 5.00 -72.67% -2.10
1.00 9.00 2.90 1.41
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.23
innodb drop_table_when_MANY_tables 32.00 -63.26% -12.40
11.00 49.00 19.60 6.61
innodb insert 124.00 -18.05% -18.96
3.00 343.00 105.04 15.54
innodb insert_autocommit 3.00 -2.07% -0.06
2.00 99.00 2.94 3.64
innodb insert_commit 1.00 +22.54% 0.29
1.00 3.00 1.29 0.46
innodb insert_duplicates 19.00 -29.57% -4.34
11.00 21.00 14.66 2.22
innodb insert_key 737.00 -113.44% -391.71
142.00 959.00 345.29 172.82
innodb insert_many_fields 8.00 -44.11% -2.45
3.00 17.00 5.55 1.92
innodb insert_rollback 3.00 -88.46% -1.41
1.00 3.00 1.59 0.54
innodb insert_select_1_key 5.00 -33.45% -1.25
2.00 10.00 3.75 0.92
innodb insert_select_2_keys 11.00 -83.98% -5.02
4.00 16.00 5.98 2.21
innodb min_max 9.00 -15.17% -1.19
6.00 110.00 7.81 4.98
innodb min_max_on_key 25.00 -27.05% -5.32
14.00 37.00 19.68 2.70
innodb multiple_value_insert 13.00 -150.03% -7.80
2.00 50.00 5.20 4.64
innodb once_prepared_select 30.00 -29.76% -6.88
18.00 32.00 23.12 2.97
innodb order_by_big 16.00 -12.19% -1.74
12.00 31.00 14.26 1.59
innodb order_by_big_key 14.00 -7.38% -0.96
11.00 32.00 13.04 1.61
innodb order_by_big_key2 13.00 -8.21% -0.99
10.00 33.00 12.01 1.59
innodb order_by_big_key_desc 14.00 -6.64% -0.87
11.00 32.00 13.13 1.55
innodb order_by_big_key_diff 12.00 +0.27% 0.03
10.00 31.00 12.03 1.54
innodb order_by_big_key_prefix 14.00 -14.87% -1.81
10.00 32.00 12.19 1.61
innodb order_by_key2_diff 1.00 +28.94% 0.41
1.00 3.00 1.41 0.50
innodb order_by_key_prefix 1.00 -29.01% -0.22
0.00 2.00 0.78 0.42
innodb order_by_range 1.00 -24.47% -0.20
0.00 2.00 0.80 0.40
innodb outer_join 18.00 +4.14% 0.78
15.00 61.00 18.78 3.70
innodb outer_join_found 17.00 +6.87% 1.25
14.00 58.00 18.25 3.57
innodb outer_join_not_found 15.00 +5.85% 0.93
12.00 46.00 15.93 3.10
innodb outer_join_on_key 12.00 +4.12% 0.52
10.00 59.00 12.52 2.80
innodb prepared_select 37.00 -23.19% -6.96
22.00 40.00 30.04 3.93
innodb select_1_row 4.00 -48.64% -1.31
2.00 4.00 2.69 0.62
innodb select_1_row_cache 3.00 -19.29% -0.49
2.00 4.00 2.51 0.60
innodb select_2_rows 4.00 -47.94% -1.30
2.00 4.00 2.70 0.62
innodb select_big 13.00 -8.52% -1.02
0.00 31.00 11.98 1.58
innodb select_big_str 1.00 +10.99% 0.12
0.00 2.00 1.12 0.33
innodb select_cache 58.00 +3.90% 2.35
49.00 676.00 60.35 29.77
innodb select_cache2 59.00 +3.09% 1.88
49.00 677.00 60.88 31.42
innodb select_column+column 4.00 -45.81% -1.26
2.00 4.00 2.74 0.63
innodb select_diff_key 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_distinct 4.00 +4.32% 0.18
3.00 8.00 4.18 0.54
innodb select_group 16.00 +0.51% 0.08
4.00 136.00 16.08 5.94
innodb select_group_when_MANY_tables 42.00 -393.99% -33.50
3.00 47.00 8.50 9.61
innodb select_join 1.00 -77.69% -0.44
0.00 1.00 0.56 0.50
innodb select_key 64.00 -27.10% -13.64
40.00 66.00 50.36 5.94
innodb select_key2 71.00 -24.68% -14.05
45.00 75.00 56.95 6.99
innodb select_key2_return_key 68.00 -25.33% -13.74
42.00 70.00 54.26 6.66
innodb select_key2_return_prim 69.00 -25.44% -13.99
42.00 72.00 55.01 6.85
innodb select_key_prefix 70.00 -24.74% -13.88
44.00 75.00 56.12 6.85
innodb select_key_prefix_join 5.00 -8.18% -0.38
3.00 10.00 4.62 0.66
innodb select_key_return_key 62.00 -25.55% -12.62
38.00 65.00 49.38 5.96
innodb select_many_fields 12.00 +21.70% 3.33
11.00 19.00 15.33 1.75
innodb select_range 45.00 +6.26% 3.01
39.00 76.00 48.01 3.61
innodb select_range_key2 10.00 -25.20% -2.01
6.00 10.00 7.99 0.92
innodb select_range_prefix 9.00 -19.45% -1.47
5.00 10.00 7.53 0.95
innodb select_simple 2.00 -27.75% -0.43
1.00 3.00 1.57 0.53
innodb select_simple_cache 2.00 -37.40% -0.54
1.00 3.00 1.46 0.51
innodb select_simple_join 1.00 -57.91% -0.37
0.00 3.00 0.63 0.49
innodb update_autocommit 5.00 -57.05% -1.82
2.00 7.00 3.18 0.52
innodb update_big 152.00 -214.38% -103.65
31.00 195.00 48.35 25.17
innodb update_commit 2.00 -38.55% -0.56
1.00 3.00 1.44 0.50
innodb update_of_key 23.00 +6.55% 1.61
18.00 100.00 24.61 6.73
innodb update_of_key_big 51.00 -100.41% -25.55
15.00 75.00 25.45 10.88
innodb update_of_primary_key_many_keys 3032.00 -152.69% -1832.12
647.00 6065.00 1199.88 1,075.43
innodb update_rollback 4.00 -159.10% -2.46
1.00 4.00 1.54 0.58
innodb update_with_key 138.00 -28.74% -30.81
90.00 598.00 107.19 22.01
innodb update_with_key_prefix 46.00 -19.05% -7.36
33.00 202.00 38.64 7.08
innodb wisc_benchmark 3.00 -22.42% -0.55
2.00 5.00 2.45 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2040.2.3: Brian Aker 2010-12-30 Update support since we support this syntax
now.
2040.2.2: Brian Aker 2010-12-30 Update assert test, additional my_error.
2040.2.1: Brian Aker 2010-12-29 [merge] Mege in dangling call to ptr() and
utility functions from catalogs.
2040.1.2: Brian Aker 2010-12-29 [merge] Merge in the utility functions I
have been using in catalogs.
2039.3.4: Brian Aker 2010-12-29 Adding typeof() method to determine
drizzle type returns
2039.3.3: Brian Aker 2010-12-29 result_type() to display the internal
type.
2039.3.2: Brian Aker 2010-12-29 Update assert() to display what was being
evaluated.
2039.3.1: Brian Aker 2010-12-29 Create a user available assert() function.
2040.1.1: Brian Aker 2010-12-29 Remove case where we called ptr() and
instead call c_ptr() (safer this way).
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
