=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 1059
RUN DATE: 2011-11-30T10:12:17.845199
SERVER: drizzled
VERSION: staging
REVISION: 2465
COMMENT: 2465: Mark Atwood 2011-11-29 [merge] merge
lp:~brianaker/drizzle/libdrizzle-2.0-not-install
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 34.00 -12.58% -3.80
25.00 34.00 30.20 3.25
innodb alter_table_drop 25.00 -2.46% -0.60
23.00 25.00 24.40 0.80
innodb connect 3.00 -15.38% -0.40
2.00 3.00 2.60 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 13.00 +18.75% 3.00
13.00 18.00 16.00 2.10
innodb count_distinct 8.00 -8.11% -0.60
6.00 8.00 7.40 0.80
innodb count_distinct_2 12.00 +10.45% 1.40
12.00 15.00 13.40 1.02
innodb count_distinct_big 21.00 +7.08% 1.60
21.00 24.00 22.60 1.36
innodb count_distinct_group 15.00 -4.17% -0.60
13.00 15.00 14.40 0.80
innodb count_distinct_group_on_key 9.00 +11.76% 1.20
9.00 11.00 10.20 0.98
innodb count_distinct_group_on_key_parts 13.00 +4.41% 0.60
12.00 15.00 13.60 1.02
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 11.00 +1.79% 0.20
11.00 12.00 11.20 0.40
innodb count_on_key 94.00 +1.67% 1.60
92.00 100.00 95.60 2.94
innodb create+drop 34.00 -1.80% -0.60
33.00 34.00 33.40 0.49
innodb create_index 3.00 -25.00% -0.60
2.00 3.00 2.40 0.49
innodb create_key+drop 33.00 -3.13% -1.00
31.00 33.00 32.00 0.63
innodb create_MANY_tables 20.00 -1.01% -0.20
19.00 20.00 19.80 0.40
innodb delete_all_many_keys 867.00 -5.35% -44.00
749.00 867.00 823.00 45.27
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 867.00 -5.45% -44.80
748.00 867.00 822.20 45.46
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb delete_range 8.00 -2.56% -0.20
7.00 8.00 7.80 0.40
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 2.00 +37.50% 1.20
2.00 4.00 3.20 0.75
innodb drop_table_when_MANY_tables 17.00 +7.61% 1.40
17.00 19.00 18.40 0.80
innodb insert 115.00 -0.70% -0.80
112.00 116.00 114.20 1.33
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_duplicates 20.00 -1.01% -0.20
19.00 20.00 19.80 0.40
innodb insert_key 290.00 +0.21% 0.60
288.00 295.00 290.60 2.33
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 6.00 -11.11% -0.60
4.00 6.00 5.40 0.80
innodb insert_select_2_keys 5.00 +19.35% 1.20
5.00 7.00 6.20 0.75
innodb min_max 7.00 +14.63% 1.20
7.00 9.00 8.20 0.98
innodb min_max_on_key 25.00 -0.81% -0.20
24.00 25.00 24.80 0.40
innodb multiple_value_insert 6.00 -0.00% 0.00
5.00 7.00 6.00 0.63
innodb once_prepared_select 29.00 +1.36% 0.40
29.00 30.00 29.40 0.49
innodb order_by_big 14.00 -1.45% -0.20
13.00 15.00 13.80 0.75
innodb order_by_big_key 14.00 +4.11% 0.60
13.00 16.00 14.60 1.02
innodb order_by_big_key2 12.00 -0.00% 0.00
11.00 13.00 12.00 0.89
innodb order_by_big_key_desc 16.00 -1.27% -0.20
15.00 16.00 15.80 0.40
innodb order_by_big_key_diff 13.00 -1.56% -0.20
12.00 13.00 12.80 0.40
innodb order_by_big_key_prefix 13.00 +4.41% 0.60
13.00 15.00 13.60 0.80
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 -13.21% -2.80
19.00 25.00 21.20 2.71
innodb outer_join_found 22.00 -11.11% -2.20
17.00 23.00 19.80 2.32
innodb outer_join_not_found 21.00 -14.13% -2.60
16.00 21.00 18.40 2.15
innodb outer_join_on_key 15.00 -13.64% -1.80
12.00 15.00 13.20 1.47
innodb prepared_select 37.00 -0.00% 0.00
37.00 37.00 37.00 0.00
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 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb select_2_rows 3.00 +21.05% 0.80
3.00 4.00 3.80 0.40
innodb select_big 11.00 +9.84% 1.20
11.00 14.00 12.20 1.17
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 66.00 -3.77% -2.40
61.00 66.00 63.60 2.06
innodb select_cache2 65.00 +0.31% 0.20
63.00 67.00 65.20 1.33
innodb select_column+column 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_distinct 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb select_group 16.00 -0.00% 0.00
16.00 16.00 16.00 0.00
innodb select_group_when_MANY_tables 12.00 -0.00% 0.00
11.00 13.00 12.00 0.63
innodb select_join 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb select_key 65.00 -0.31% -0.20
63.00 66.00 64.80 0.98
innodb select_key2 72.00 -0.00% 0.00
71.00 73.00 72.00 0.63
innodb select_key2_return_key 69.00 +0.86% 0.60
68.00 71.00 69.60 1.02
innodb select_key2_return_prim 70.00 -0.00% 0.00
69.00 71.00 70.00 0.63
innodb select_key_prefix 72.00 -0.56% -0.40
71.00 72.00 71.60 0.49
innodb select_key_prefix_join 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb select_key_return_key 64.00 -0.00% 0.00
63.00 65.00 64.00 0.63
innodb select_many_fields 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb select_range 44.00 +3.93% 1.80
42.00 49.00 45.80 2.56
innodb select_range_key2 10.00 -4.17% -0.40
9.00 10.00 9.60 0.49
innodb select_range_prefix 9.00 +4.26% 0.40
9.00 10.00 9.40 0.49
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 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb update_big 59.00 -1.37% -0.80
54.00 60.00 58.20 2.23
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 24.00 -6.19% -1.40
21.00 24.00 22.60 1.02
innodb update_of_key_big 20.00 -4.17% -0.80
18.00 20.00 19.20 0.75
innodb update_of_primary_key_many_keys 1352.00 -5.08% -65.40
1259.00 1352.00 1286.60 33.22
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 121.00 -2.72% -3.20
115.00 121.00 117.80 2.40
innodb update_with_key_prefix 43.00 -0.00% 0.00
40.00 46.00 43.00 2.00
innodb wisc_benchmark 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 34.00 -8.80% -2.75
25.00 34.00 31.25 2.05
innodb alter_table_drop 25.00 -1.83% -0.45
23.00 27.00 24.55 0.97
innodb connect 3.00 -27.66% -0.65
2.00 3.00 2.35 0.48
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 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb count 13.00 +19.25% 3.10
13.00 18.00 16.10 1.97
innodb count_distinct 8.00 -8.84% -0.65
6.00 8.00 7.35 0.73
innodb count_distinct_2 12.00 +12.73% 1.75
12.00 16.00 13.75 1.13
innodb count_distinct_big 21.00 +8.30% 1.90
20.00 26.00 22.90 1.95
innodb count_distinct_group 15.00 -3.09% -0.45
12.00 16.00 14.55 1.12
innodb count_distinct_group_on_key 9.00 +14.69% 1.55
9.00 12.00 10.55 1.07
innodb count_distinct_group_on_key_parts 13.00 +4.41% 0.60
10.00 15.00 13.60 1.39
innodb count_distinct_key_prefix 6.00 -12.15% -0.65
4.00 7.00 5.35 0.73
innodb count_group_on_key_parts 11.00 +1.79% 0.20
10.00 12.00 11.20 0.60
innodb count_on_key 94.00 +1.10% 1.05
91.00 101.00 95.05 2.52
innodb create+drop 34.00 -2.10% -0.70
32.00 35.00 33.30 0.95
innodb create_index 3.00 -3.45% -0.10
2.00 4.00 2.90 0.54
innodb create_key+drop 33.00 -3.94% -1.25
29.00 34.00 31.75 1.34
innodb create_MANY_tables 20.00 +6.32% 1.35
19.00 25.00 21.35 1.42
innodb create_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb delete_all_many_keys 867.00 -4.66% -38.60
735.00 1051.00 828.40 79.84
innodb delete_autocommit 3.00 +18.92% 0.70
3.00 4.00 3.70 0.46
innodb delete_big 1.00 -185.71% -0.65
0.00 1.00 0.35 0.48
innodb delete_big_many_keys 867.00 -4.72% -39.05
735.00 1050.00 827.95 79.61
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -5.26% -0.15
2.00 3.00 2.85 0.36
innodb delete_range 8.00 +4.19% 0.35
7.00 10.00 8.35 0.79
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 2.00 +34.43% 1.05
2.00 4.00 3.05 0.50
innodb drop_table_when_MANY_tables 17.00 +11.92% 2.30
17.00 21.00 19.30 1.10
innodb insert 115.00 -1.86% -2.10
110.00 116.00 112.90 1.48
innodb insert_autocommit 3.00 +4.76% 0.15
3.00 4.00 3.15 0.36
innodb insert_commit 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb insert_duplicates 20.00 -3.90% -0.75
19.00 20.00 19.25 0.43
innodb insert_key 290.00 -1.65% -4.70
276.00 305.00 285.30 6.51
innodb insert_many_fields 6.00 -7.14% -0.40
5.00 6.00 5.60 0.49
innodb insert_rollback 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb insert_select_1_key 6.00 -21.21% -1.05
4.00 6.00 4.95 0.67
innodb insert_select_2_keys 5.00 +23.08% 1.50
5.00 7.00 6.50 0.59
innodb min_max 7.00 +15.15% 1.25
7.00 10.00 8.25 0.99
innodb min_max_on_key 25.00 -1.42% -0.35
24.00 25.00 24.65 0.48
innodb multiple_value_insert 6.00 -2.56% -0.15
5.00 7.00 5.85 0.65
innodb once_prepared_select 29.00 -0.52% -0.15
28.00 30.00 28.85 0.65
innodb order_by_big 14.00 +0.36% 0.05
12.00 16.00 14.05 0.97
innodb order_by_big_key 14.00 +4.11% 0.60
12.00 16.00 14.60 1.20
innodb order_by_big_key2 12.00 +2.83% 0.35
11.00 14.00 12.35 0.73
innodb order_by_big_key_desc 16.00 -5.96% -0.90
13.00 16.00 15.10 0.99
innodb order_by_big_key_diff 13.00 -1.17% -0.15
11.00 14.00 12.85 0.79
innodb order_by_big_key_prefix 13.00 +0.38% 0.05
12.00 15.00 13.05 0.86
innodb order_by_key2_diff 1.00 +31.03% 0.45
1.00 2.00 1.45 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 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 24.00 -10.34% -2.25
18.00 25.00 21.75 2.28
innodb outer_join_found 22.00 -6.80% -1.40
17.00 24.00 20.60 2.50
innodb outer_join_not_found 21.00 -12.60% -2.35
15.00 21.00 18.65 2.29
innodb outer_join_on_key 15.00 -10.70% -1.45
12.00 15.00 13.55 1.24
innodb prepared_select 37.00 -0.27% -0.10
36.00 38.00 36.90 0.54
innodb select_1_row 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_1_row_cache 3.00 +13.04% 0.45
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 11.00 +13.73% 1.75
11.00 14.00 12.75 0.99
innodb select_big_str 1.00 +23.08% 0.30
1.00 2.00 1.30 0.46
innodb select_cache 66.00 +0.68% 0.45
58.00 78.00 66.45 5.23
innodb select_cache2 65.00 +4.55% 3.10
62.00 84.00 68.10 5.53
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 5.00 -5.26% -0.25
4.00 5.00 4.75 0.43
innodb select_group 16.00 +6.43% 1.10
15.00 19.00 17.10 1.34
innodb select_group_when_MANY_tables 12.00 +0.41% 0.05
11.00 13.00 12.05 0.67
innodb select_join 1.00 -42.86% -0.30
0.00 1.00 0.70 0.46
innodb select_key 65.00 -2.12% -1.35
62.00 66.00 63.65 1.11
innodb select_key2 72.00 -1.84% -1.30
69.00 73.00 70.70 1.14
innodb select_key2_return_key 69.00 -0.88% -0.60
67.00 71.00 68.40 1.20
innodb select_key2_return_prim 70.00 -1.52% -1.05
67.00 71.00 68.95 1.02
innodb select_key_prefix 72.00 -2.27% -1.60
69.00 72.00 70.40 1.02
innodb select_key_prefix_join 6.00 -9.09% -0.50
5.00 6.00 5.50 0.50
innodb select_key_return_key 64.00 -1.91% -1.20
61.00 65.00 62.80 0.93
innodb select_many_fields 13.00 +1.89% 0.25
13.00 14.00 13.25 0.43
innodb select_range 44.00 +2.65% 1.20
41.00 49.00 45.20 2.80
innodb select_range_key2 10.00 -5.26% -0.50
9.00 10.00 9.50 0.50
innodb select_range_prefix 9.00 +2.70% 0.25
8.00 10.00 9.25 0.54
innodb select_simple 2.00 +2.44% 0.05
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 0.00 +100.00% 0.65
0.00 1.00 0.65 0.48
innodb update_autocommit 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb update_big 59.00 -1.11% -0.65
54.00 60.00 58.35 1.56
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 24.00 -6.19% -1.40
21.00 24.00 22.60 1.02
innodb update_of_key_big 20.00 -2.30% -0.45
18.00 21.00 19.55 0.67
innodb update_of_primary_key_many_keys 1352.00 -3.90% -50.75
1226.00 1442.00 1301.25 46.53
innodb update_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb update_with_key 121.00 -0.17% -0.20
115.00 128.00 120.80 3.83
innodb update_with_key_prefix 43.00 +0.92% 0.40
40.00 48.00 43.40 2.03
innodb wisc_benchmark 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 34.00 -51.61% -11.57
11.00 61.00 22.43 10.14
innodb alter_table_drop 25.00 -30.96% -5.91
10.00 57.00 19.09 6.77
innodb connect 3.00 -42.68% -0.90
1.00 3.00 2.10 0.42
innodb connect+select_1_row 3.00 -9.81% -0.27
2.00 5.00 2.73 0.46
innodb connect+select_simple 2.00 +15.88% 0.38
1.00 3.00 2.38 0.49
innodb count 13.00 +17.55% 2.77
12.00 193.00 15.77 8.28
innodb count_distinct 8.00 -21.00% -1.39
5.00 50.00 6.61 2.15
innodb count_distinct_2 12.00 +9.52% 1.26
11.00 63.00 13.26 2.81
innodb count_distinct_big 21.00 +4.82% 1.06
5.00 67.00 22.06 2.92
innodb count_distinct_group 15.00 -12.71% -1.69
10.00 68.00 13.31 2.95
innodb count_distinct_group_on_key 9.00 +5.65% 0.54
7.00 69.00 9.54 2.85
innodb count_distinct_group_on_key_parts 13.00 -4.61% -0.57
9.00 72.00 12.43 3.00
innodb count_distinct_key_prefix 6.00 -16.36% -0.84
3.00 52.00 5.16 2.24
innodb count_group_on_key_parts 11.00 -8.71% -0.88
7.00 72.00 10.12 2.98
innodb count_on_key 94.00 -7.92% -6.90
68.00 107.00 87.10 7.55
innodb create+drop 34.00 -4.55% -1.48
18.00 75.00 32.52 11.12
innodb create_index 3.00 -3.07% -0.09
1.00 8.00 2.91 1.08
innodb create_key+drop 33.00 -15.39% -4.40
21.00 50.00 28.60 4.74
innodb create_MANY_tables 20.00 +38.24% 12.38
14.00 121.00 32.38 16.59
innodb create_table 0.00 +100.00% 0.10
0.00 3.00 0.10 0.34
innodb delete_all_many_keys 867.00 -72.65% -364.83
212.00 1888.00 502.17 357.46
innodb delete_autocommit 3.00 +13.38% 0.46
2.00 14.00 3.46 0.73
innodb delete_big 1.00 -223.68% -0.69
0.00 3.00 0.31 0.47
innodb delete_big_many_keys 867.00 -70.92% -359.73
212.00 2293.00 507.27 369.51
innodb delete_commit 2.00 -28.46% -0.44
1.00 5.00 1.56 0.52
innodb delete_key 3.00 +0.91% 0.03
2.00 35.00 3.03 1.41
innodb delete_range 8.00 +3.87% 0.32
5.00 23.00 8.32 3.04
innodb delete_rollback 2.00 -12.33% -0.22
1.00 12.00 1.78 0.87
innodb drop_index 2.00 +32.42% 0.96
1.00 9.00 2.96 1.25
innodb drop_table 0.00 +100.00% 0.04
0.00 2.00 0.04 0.22
innodb drop_table_when_MANY_tables 17.00 +12.69% 2.47
11.00 90.00 19.47 7.05
innodb insert 115.00 -6.99% -7.52
3.00 343.00 107.48 13.81
innodb insert_autocommit 3.00 +0.54% 0.02
2.00 99.00 3.02 3.10
innodb insert_commit 2.00 -39.08% -0.56
1.00 3.00 1.44 0.50
innodb insert_duplicates 20.00 -25.57% -4.07
11.00 21.00 15.93 2.77
innodb insert_key 290.00 +3.34% 10.01
142.00 700.00 300.01 99.86
innodb insert_many_fields 6.00 -6.60% -0.37
3.00 17.00 5.63 1.67
innodb insert_rollback 2.00 -17.00% -0.29
1.00 3.00 1.71 0.52
innodb insert_select_1_key 6.00 -55.21% -2.13
2.00 10.00 3.87 0.90
innodb insert_select_2_keys 5.00 +17.96% 1.09
4.00 16.00 6.09 1.97
innodb min_max 7.00 +10.74% 0.84
6.00 110.00 7.84 4.27
innodb min_max_on_key 25.00 -18.81% -3.96
14.00 37.00 21.04 3.18
innodb multiple_value_insert 6.00 -8.40% -0.46
2.00 50.00 5.54 4.02
innodb once_prepared_select 29.00 -16.93% -4.20
18.00 32.00 24.80 3.70
innodb order_by_big 14.00 +2.04% 0.29
12.00 31.00 14.29 1.48
innodb order_by_big_key 14.00 -4.46% -0.60
11.00 32.00 13.40 1.64
innodb order_by_big_key2 12.00 +2.33% 0.29
10.00 33.00 12.29 1.50
innodb order_by_big_key_desc 16.00 -16.91% -2.31
11.00 32.00 13.69 1.69
innodb order_by_big_key_diff 13.00 -5.52% -0.68
10.00 31.00 12.32 1.46
innodb order_by_big_key_prefix 13.00 -4.15% -0.52
10.00 32.00 12.48 1.50
innodb order_by_key2_diff 1.00 +28.66% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -24.59% -0.20
0.00 2.00 0.80 0.40
innodb order_by_range 1.00 -18.86% -0.16
0.00 2.00 0.84 0.37
innodb outer_join 24.00 -21.99% -4.33
15.00 61.00 19.67 3.70
innodb outer_join_found 22.00 -15.49% -2.95
14.00 58.00 19.05 3.54
innodb outer_join_not_found 21.00 -25.06% -4.21
12.00 46.00 16.79 3.20
innodb outer_join_on_key 15.00 -14.60% -1.91
10.00 59.00 13.09 2.71
innodb prepared_select 37.00 -15.58% -4.99
22.00 40.00 32.01 4.61
innodb select_1_row 4.00 -36.05% -1.06
2.00 4.00 2.94 0.71
innodb select_1_row_cache 3.00 -8.00% -0.22
2.00 4.00 2.78 0.71
innodb select_2_rows 3.00 -0.92% -0.03
2.00 4.00 2.97 0.72
innodb select_big 11.00 +10.01% 1.22
0.00 31.00 12.22 1.51
innodb select_big_str 1.00 +15.85% 0.19
0.00 2.00 1.19 0.39
innodb select_cache 66.00 -9.58% -5.77
49.00 78.00 60.23 5.66
innodb select_cache2 65.00 -7.17% -4.35
49.00 84.00 60.65 6.31
innodb select_column+column 4.00 -32.04% -0.97
2.00 4.00 3.03 0.74
innodb select_diff_key 0.00 +100.00% 0.22
0.00 1.00 0.22 0.42
innodb select_distinct 5.00 -16.82% -0.72
3.00 8.00 4.28 0.55
innodb select_group 16.00 +2.09% 0.34
4.00 136.00 16.34 5.11
innodb select_group_when_MANY_tables 12.00 -22.83% -2.23
3.00 49.00 9.77 8.89
innodb select_join 1.00 -69.83% -0.41
0.00 1.00 0.59 0.49
innodb select_key 65.00 -20.10% -10.88
40.00 66.00 54.12 7.87
innodb select_key2 72.00 -18.37% -11.17
45.00 75.00 60.83 8.60
innodb select_key2_return_key 69.00 -18.60% -10.82
42.00 71.00 58.18 8.46
innodb select_key2_return_prim 70.00 -18.77% -11.06
42.00 72.00 58.94 8.58
innodb select_key_prefix 72.00 -19.75% -11.87
44.00 75.00 60.13 8.67
innodb select_key_prefix_join 6.00 -25.50% -1.22
3.00 10.00 4.78 0.65
innodb select_key_return_key 64.00 -20.45% -10.87
38.00 65.00 53.13 7.86
innodb select_many_fields 13.00 +11.78% 1.74
11.00 19.00 14.74 1.78
innodb select_range 44.00 +5.73% 2.68
38.00 76.00 46.68 4.04
innodb select_range_key2 10.00 -18.81% -1.58
6.00 11.00 8.42 1.08
innodb select_range_prefix 9.00 -12.34% -0.99
5.00 10.00 8.01 1.16
innodb select_simple 2.00 -17.75% -0.30
1.00 3.00 1.70 0.51
innodb select_simple_cache 2.00 -23.98% -0.39
1.00 3.00 1.61 0.51
innodb select_simple_join 0.00 +100.00% 0.67
0.00 3.00 0.67 0.48
innodb update_autocommit 4.00 -19.31% -0.65
2.00 16.00 3.35 0.97
innodb update_big 59.00 -13.59% -7.06
31.00 195.00 51.94 23.04
innodb update_commit 2.00 -24.16% -0.39
1.00 10.00 1.61 0.70
innodb update_of_key 24.00 -0.08% -0.02
18.00 100.00 23.98 5.82
innodb update_of_key_big 20.00 +27.17% 7.46
15.00 75.00 27.46 10.74
innodb update_of_primary_key_many_keys 1352.00 -8.12% -101.50
647.00 6065.00 1250.50 882.58
innodb update_rollback 2.00 -11.25% -0.20
1.00 31.00 1.80 1.78
innodb update_with_key 121.00 -8.89% -9.88
90.00 598.00 111.12 19.77
innodb update_with_key_prefix 43.00 -7.20% -2.89
33.00 202.00 40.11 6.55
innodb wisc_benchmark 2.00 +19.58% 0.49
2.00 5.00 2.49 0.52
=========================================================================================================================
FULL REVISION COMMENTARY:
2463.1.6: Brian Aker 2011-11-29 Remove support for installing libdrizzle-2.0
until we get it stabalized
2463.1.5: Brian Aker 2011-11-26 Move result over to being behind API.
2463.1.4: Brian Aker 2011-11-26 Remove con from being passed object.
2463.1.3: Brian Aker 2011-11-23 Redo the way options are handled.
2463.1.2: Brian Aker 2011-11-23 First pass, drizzle_create() no longer takes
an argument. This means that we can now change drizzle_st without being
concerned about ABI.
2463.1.1: Brian Aker 2011-11-23 [merge] Break out options, first pass.
2461.1.4: Brian Aker 2011-11-20 More updates to libdrizzle-2.0
2461.1.3: Brian Aker 2011-11-20 Small correction to style.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
