=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 953
RUN DATE: 2011-03-11T11:50:07.472705
SERVER: drizzled
VERSION: staging
REVISION: 2230
COMMENT: 2230: Monty Taylor 2011-03-11 [merge] Merged Andrew: drizzledump and
docs bug fixes
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 26.00 +20.25% 6.60
26.00 35.00 32.60 3.38
innodb alter_table_drop 23.00 +3.36% 0.80
23.00 25.00 23.80 0.75
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 2.00 +28.57% 0.80
2.00 3.00 2.80 0.40
innodb count 15.00 +5.06% 0.80
13.00 17.00 15.80 1.60
innodb count_distinct 8.00 -25.00% -1.60
5.00 8.00 6.40 1.02
innodb count_distinct_2 13.00 +8.45% 1.20
13.00 16.00 14.20 1.17
innodb count_distinct_big 24.00 -0.00% 0.00
21.00 25.00 24.00 1.55
innodb count_distinct_group 15.00 -1.35% -0.20
14.00 15.00 14.80 0.40
innodb count_distinct_group_on_key 8.00 +13.04% 1.20
8.00 11.00 9.20 0.98
innodb count_distinct_group_on_key_parts 14.00 -2.94% -0.40
13.00 14.00 13.60 0.49
innodb count_distinct_key_prefix 5.00 +10.71% 0.60
5.00 6.00 5.60 0.49
innodb count_group_on_key_parts 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_on_key 92.00 +2.95% 2.80
92.00 96.00 94.80 1.47
innodb create+drop 32.00 +2.44% 0.80
32.00 34.00 32.80 0.75
innodb create_index 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb create_key+drop 32.00 -1.27% -0.40
31.00 32.00 31.60 0.49
innodb create_MANY_tables 20.00 +4.76% 1.00
20.00 22.00 21.00 0.89
innodb delete_all_many_keys 650.00 -2.23% -14.20
609.00 655.00 635.80 17.06
innodb delete_autocommit 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb delete_big 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 649.00 -2.24% -14.20
608.00 654.00 634.80 17.06
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 7.00 +18.60% 1.60
7.00 10.00 8.60 1.02
innodb delete_rollback 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
innodb drop_index 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb drop_table_when_MANY_tables 19.00 +1.04% 0.20
18.00 20.00 19.20 0.75
innodb insert 115.00 -1.41% -1.60
112.00 115.00 113.40 1.02
innodb insert_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb insert_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_duplicates 19.00 +1.04% 0.20
19.00 20.00 19.20 0.40
innodb insert_key 278.00 +0.29% 0.80
265.00 296.00 278.80 10.03
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 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb insert_select_2_keys 6.00 +3.23% 0.20
6.00 7.00 6.20 0.40
innodb min_max 7.00 +10.26% 0.80
7.00 9.00 7.80 0.98
innodb min_max_on_key 24.00 +1.64% 0.40
24.00 25.00 24.40 0.49
innodb multiple_value_insert 7.00 -2.94% -0.20
6.00 7.00 6.80 0.40
innodb once_prepared_select 29.00 -0.00% 0.00
29.00 29.00 29.00 0.00
innodb order_by_big 13.00 +1.52% 0.20
12.00 15.00 13.20 0.98
innodb order_by_big_key 13.00 +4.41% 0.60
12.00 15.00 13.60 1.20
innodb order_by_big_key2 12.00 +1.64% 0.20
11.00 13.00 12.20 0.75
innodb order_by_big_key_desc 13.00 +10.96% 1.60
13.00 16.00 14.60 1.20
innodb order_by_big_key_diff 11.00 +8.33% 1.00
11.00 13.00 12.00 0.63
innodb order_by_big_key_prefix 12.00 +1.64% 0.20
12.00 13.00 12.20 0.40
innodb order_by_key2_diff 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
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 26.00 -17.12% -3.80
18.00 26.00 22.20 3.49
innodb outer_join_found 26.00 -20.37% -4.40
17.00 26.00 21.60 3.61
innodb outer_join_not_found 21.00 -10.53% -2.00
16.00 21.00 19.00 2.10
innodb outer_join_on_key 18.00 -16.88% -2.60
12.00 18.00 15.40 2.50
innodb prepared_select 38.00 -2.70% -1.00
36.00 38.00 37.00 0.63
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 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb select_2_rows 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_big 11.00 +9.84% 1.20
11.00 13.00 12.20 0.75
innodb select_big_str 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb select_cache 61.00 +2.87% 1.80
58.00 67.00 62.80 3.31
innodb select_cache2 61.00 +4.98% 3.20
61.00 70.00 64.20 3.06
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_diff_key 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb select_distinct 5.00 -4.17% -0.20
4.00 5.00 4.80 0.40
innodb select_group 15.00 +6.25% 1.00
15.00 18.00 16.00 1.10
innodb select_group_when_MANY_tables 12.00 +3.23% 0.40
12.00 14.00 12.40 0.80
innodb select_join 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb select_key 65.00 -1.56% -1.00
63.00 65.00 64.00 0.63
innodb select_key2 72.00 -1.41% -1.00
70.00 72.00 71.00 0.63
innodb select_key2_return_key 69.00 -0.29% -0.20
68.00 70.00 68.80 0.75
innodb select_key2_return_prim 71.00 -2.01% -1.40
69.00 71.00 69.60 0.80
innodb select_key_prefix 71.00 -0.00% 0.00
70.00 72.00 71.00 0.63
innodb select_key_prefix_join 5.00 -0.00% 0.00
4.00 6.00 5.00 0.63
innodb select_key_return_key 63.00 +0.32% 0.20
63.00 64.00 63.20 0.40
innodb select_many_fields 14.00 -4.48% -0.60
13.00 14.00 13.40 0.49
innodb select_range 45.00 -6.13% -2.60
38.00 47.00 42.40 3.20
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 0.00 +100.00% 0.80
0.00 1.00 0.80 0.40
innodb update_autocommit 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb update_big 57.00 +3.06% 1.80
57.00 61.00 58.80 1.47
innodb update_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb update_of_key 22.00 -2.80% -0.60
21.00 22.00 21.40 0.49
innodb update_of_key_big 36.00 +4.76% 1.80
33.00 46.00 37.80 4.35
innodb update_of_primary_key_many_keys 1341.00 -0.98% -13.00
1233.00 1400.00 1328.00 53.75
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 127.00 -3.76% -4.60
118.00 127.00 122.40 3.44
innodb update_with_key_prefix 44.00 +2.22% 1.00
44.00 47.00 45.00 1.10
innodb wisc_benchmark 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 26.00 +19.75% 6.40
25.00 35.00 32.40 2.54
innodb alter_table_drop 23.00 +3.97% 0.95
22.00 26.00 23.95 0.97
innodb connect 2.00 +11.11% 0.25
2.00 3.00 2.25 0.43
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 +21.57% 0.55
2.00 3.00 2.55 0.50
innodb count 15.00 +9.09% 1.50
13.00 18.00 16.50 1.72
innodb count_distinct 8.00 -18.52% -1.25
5.00 8.00 6.75 0.89
innodb count_distinct_2 13.00 +6.47% 0.90
12.00 16.00 13.90 1.30
innodb count_distinct_big 24.00 -3.00% -0.70
20.00 25.00 23.30 1.93
innodb count_distinct_group 15.00 -2.39% -0.35
13.00 16.00 14.65 0.65
innodb count_distinct_group_on_key 8.00 +14.89% 1.40
8.00 11.00 9.40 1.02
innodb count_distinct_group_on_key_parts 14.00 -5.26% -0.70
11.00 14.00 13.30 1.00
innodb count_distinct_key_prefix 5.00 +8.26% 0.45
5.00 6.00 5.45 0.50
innodb count_group_on_key_parts 11.00 -2.33% -0.25
10.00 11.00 10.75 0.43
innodb count_on_key 92.00 +0.70% 0.65
90.00 96.00 92.65 1.90
innodb create+drop 32.00 +3.18% 1.05
32.00 34.00 33.05 0.67
innodb create_index 3.00 +3.23% 0.10
3.00 4.00 3.10 0.30
innodb create_key+drop 32.00 -1.59% -0.50
30.00 33.00 31.50 0.74
innodb create_MANY_tables 20.00 +3.85% 0.80
20.00 22.00 20.80 0.75
innodb create_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb delete_all_many_keys 650.00 -0.49% -3.20
608.00 721.00 646.80 30.10
innodb delete_autocommit 4.00 -9.59% -0.35
3.00 5.00 3.65 0.57
innodb delete_big 0.00 +100.00% 0.45
0.00 1.00 0.45 0.50
innodb delete_big_many_keys 649.00 -0.49% -3.15
608.00 719.00 645.85 29.92
innodb delete_commit 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb delete_key 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb delete_range 7.00 +19.08% 1.65
7.00 10.00 8.65 0.79
innodb delete_rollback 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb drop_index 4.00 -33.33% -1.00
2.00 4.00 3.00 0.55
innodb drop_table_when_MANY_tables 19.00 -0.80% -0.15
18.00 22.00 18.85 1.06
innodb insert 115.00 -1.14% -1.30
111.00 116.00 113.70 1.35
innodb insert_autocommit 3.00 +3.23% 0.10
3.00 4.00 3.10 0.30
innodb insert_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb insert_duplicates 19.00 +0.78% 0.15
18.00 20.00 19.15 0.48
innodb insert_key 278.00 +0.54% 1.50
265.00 299.00 279.50 9.17
innodb insert_many_fields 6.00 -0.84% -0.05
5.00 7.00 5.95 0.38
innodb insert_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb insert_select_1_key 4.00 -2.56% -0.10
3.00 5.00 3.90 0.44
innodb insert_select_2_keys 6.00 +1.64% 0.10
5.00 8.00 6.10 0.62
innodb min_max 7.00 +11.39% 0.90
7.00 9.00 7.90 0.94
innodb min_max_on_key 24.00 +1.84% 0.45
23.00 25.00 24.45 0.59
innodb multiple_value_insert 7.00 -6.87% -0.45
5.00 8.00 6.55 0.67
innodb once_prepared_select 29.00 +0.17% 0.05
28.00 30.00 29.05 0.50
innodb order_by_big 13.00 +9.41% 1.35
12.00 16.00 14.35 1.15
innodb order_by_big_key 13.00 +6.81% 0.95
12.00 16.00 13.95 1.20
innodb order_by_big_key2 12.00 +5.51% 0.70
11.00 15.00 12.70 0.95
innodb order_by_big_key_desc 13.00 +11.26% 1.65
13.00 17.00 14.65 1.24
innodb order_by_big_key_diff 11.00 +12.70% 1.60
11.00 14.00 12.60 0.80
innodb order_by_big_key_prefix 12.00 +7.34% 0.95
12.00 14.00 12.95 0.67
innodb order_by_key2_diff 1.00 +23.08% 0.30
1.00 2.00 1.30 0.46
innodb order_by_key_prefix 1.00 -17.65% -0.15
0.00 1.00 0.85 0.36
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 26.00 -19.27% -4.20
17.00 26.00 21.80 2.68
innodb outer_join_found 26.00 -23.52% -4.95
17.00 26.00 21.05 2.71
innodb outer_join_not_found 21.00 -10.53% -2.00
15.00 22.00 19.00 2.12
innodb outer_join_on_key 18.00 -23.71% -3.45
12.00 18.00 14.55 1.86
innodb prepared_select 38.00 -2.70% -1.00
36.00 38.00 37.00 0.63
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 +11.76% 0.40
3.00 4.00 3.40 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 +10.20% 1.25
11.00 15.00 12.25 1.04
innodb select_big_str 1.00 +20.00% 0.25
1.00 2.00 1.25 0.43
innodb select_cache 61.00 +3.86% 2.45
57.00 67.00 63.45 2.69
innodb select_cache2 61.00 +4.84% 3.10
59.00 70.00 64.10 2.70
innodb select_column+column 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_diff_key 1.00 -233.33% -0.70
0.00 1.00 0.30 0.46
innodb select_distinct 5.00 -8.70% -0.40
4.00 5.00 4.60 0.49
innodb select_group 15.00 +8.26% 1.35
15.00 19.00 16.35 1.53
innodb select_group_when_MANY_tables 12.00 +1.23% 0.15
11.00 14.00 12.15 0.79
innodb select_join 1.00 -122.22% -0.55
0.00 1.00 0.45 0.50
innodb select_key 65.00 -1.64% -1.05
63.00 66.00 63.95 0.67
innodb select_key2 72.00 -1.62% -1.15
69.00 73.00 70.85 0.96
innodb select_key2_return_key 69.00 -1.02% -0.70
67.00 70.00 68.30 0.90
innodb select_key2_return_prim 71.00 -2.60% -1.80
67.00 71.00 69.20 0.98
innodb select_key_prefix 71.00 -0.57% -0.40
69.00 72.00 70.60 1.07
innodb select_key_prefix_join 5.00 +0.99% 0.05
4.00 6.00 5.05 0.38
innodb select_key_return_key 63.00 -0.08% -0.05
62.00 64.00 62.95 0.67
innodb select_many_fields 14.00 -6.06% -0.80
13.00 14.00 13.20 0.40
innodb select_range 45.00 -5.76% -2.45
38.00 47.00 42.55 2.97
innodb select_range_key2 10.00 -3.09% -0.30
9.00 10.00 9.70 0.46
innodb select_range_prefix 9.00 -0.00% 0.00
8.00 10.00 9.00 0.55
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
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.95
0.00 1.00 0.95 0.22
innodb update_autocommit 3.00 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb update_big 57.00 +3.31% 1.95
55.00 63.00 58.95 1.86
innodb update_commit 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb update_of_key 22.00 +1.57% 0.35
21.00 25.00 22.35 1.24
innodb update_of_key_big 36.00 +2.96% 1.10
31.00 46.00 37.10 3.83
innodb update_of_primary_key_many_keys 1341.00 -0.17% -2.30
1233.00 1465.00 1338.70 57.12
innodb update_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb update_with_key 127.00 -4.53% -5.50
115.00 127.00 121.50 3.34
innodb update_with_key_prefix 44.00 +0.45% 0.20
41.00 47.00 44.20 1.63
innodb wisc_benchmark 3.00 -15.38% -0.40
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 26.00 -21.75% -4.64
11.00 61.00 21.36 10.13
innodb alter_table_drop 23.00 -24.06% -4.46
10.00 57.00 18.54 6.92
innodb connect 2.00 +4.01% 0.08
1.00 3.00 2.08 0.42
innodb connect+select_1_row 3.00 -10.86% -0.29
2.00 5.00 2.71 0.47
innodb connect+select_simple 2.00 +15.03% 0.35
1.00 3.00 2.35 0.49
innodb count 15.00 +4.80% 0.76
12.00 193.00 15.76 8.71
innodb count_distinct 8.00 -21.72% -1.43
5.00 50.00 6.57 2.25
innodb count_distinct_2 13.00 +1.59% 0.21
11.00 63.00 13.21 2.92
innodb count_distinct_big 24.00 -9.29% -2.04
5.00 67.00 21.96 3.00
innodb count_distinct_group 15.00 -13.74% -1.81
10.00 68.00 13.19 3.06
innodb count_distinct_group_on_key 8.00 +15.79% 1.50
7.00 69.00 9.50 2.98
innodb count_distinct_group_on_key_parts 14.00 -13.34% -1.65
9.00 72.00 12.35 3.12
innodb count_distinct_key_prefix 5.00 +2.58% 0.13
3.00 52.00 5.13 2.35
innodb count_group_on_key_parts 11.00 -9.95% -1.00
7.00 72.00 10.00 3.11
innodb count_on_key 92.00 -6.76% -5.83
68.00 107.00 86.17 7.37
innodb create+drop 32.00 +1.41% 0.46
18.00 75.00 32.46 11.73
innodb create_index 3.00 -3.55% -0.10
1.00 8.00 2.90 1.13
innodb create_key+drop 32.00 -13.14% -3.72
21.00 50.00 28.28 4.88
innodb create_MANY_tables 20.00 +40.65% 13.70
14.00 121.00 33.70 17.00
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.36
innodb delete_all_many_keys 650.00 -38.50% -180.68
212.00 1888.00 469.32 360.77
innodb delete_autocommit 4.00 -15.97% -0.55
2.00 14.00 3.45 0.75
innodb delete_big 0.00 +100.00% 0.30
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 649.00 -36.57% -173.79
212.00 2293.00 475.21 374.65
innodb delete_commit 2.00 -31.45% -0.48
1.00 5.00 1.52 0.53
innodb delete_key 3.00 +1.49% 0.05
2.00 35.00 3.05 1.48
innodb delete_range 7.00 +15.88% 1.32
5.00 23.00 8.32 3.20
innodb delete_rollback 2.00 -14.36% -0.25
1.00 12.00 1.75 0.91
innodb drop_index 4.00 -35.48% -1.05
1.00 9.00 2.95 1.30
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.23
innodb drop_table_when_MANY_tables 19.00 +2.83% 0.55
11.00 90.00 19.55 7.43
innodb insert 115.00 -7.59% -8.11
3.00 343.00 106.89 14.44
innodb insert_autocommit 3.00 +0.08% 0.00
2.00 99.00 3.00 3.27
innodb insert_commit 2.00 -43.74% -0.61
1.00 3.00 1.39 0.50
innodb insert_duplicates 19.00 -22.13% -3.44
11.00 21.00 15.56 2.68
innodb insert_key 278.00 +8.09% 24.48
142.00 700.00 302.48 105.57
innodb insert_many_fields 6.00 -6.88% -0.39
3.00 17.00 5.61 1.75
innodb insert_rollback 2.00 -19.22% -0.32
1.00 3.00 1.68 0.53
innodb insert_select_1_key 4.00 -5.72% -0.22
2.00 10.00 3.78 0.88
innodb insert_select_2_keys 6.00 +1.23% 0.07
4.00 16.00 6.07 2.06
innodb min_max 7.00 +10.58% 0.83
6.00 110.00 7.83 4.49
innodb min_max_on_key 24.00 -16.26% -3.36
14.00 37.00 20.64 3.11
innodb multiple_value_insert 7.00 -27.71% -1.52
2.00 50.00 5.48 4.23
innodb once_prepared_select 29.00 -19.19% -4.67
18.00 32.00 24.33 3.61
innodb order_by_big 13.00 +9.18% 1.31
12.00 31.00 14.31 1.52
innodb order_by_big_key 13.00 +2.27% 0.30
11.00 32.00 13.30 1.64
innodb order_by_big_key2 12.00 +1.80% 0.22
10.00 33.00 12.22 1.54
innodb order_by_big_key_desc 13.00 +3.97% 0.54
11.00 32.00 13.54 1.69
innodb order_by_big_key_diff 11.00 +10.16% 1.24
10.00 31.00 12.24 1.49
innodb order_by_big_key_prefix 12.00 +3.37% 0.42
10.00 32.00 12.42 1.55
innodb order_by_key2_diff 1.00 +28.33% 0.40
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -25.96% -0.21
0.00 2.00 0.79 0.41
innodb order_by_range 1.00 -19.81% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 26.00 -34.03% -6.60
15.00 61.00 19.40 3.72
innodb outer_join_found 26.00 -38.15% -7.18
14.00 58.00 18.82 3.57
innodb outer_join_not_found 21.00 -27.09% -4.48
12.00 46.00 16.52 3.18
innodb outer_join_on_key 18.00 -39.02% -5.05
10.00 59.00 12.95 2.77
innodb prepared_select 38.00 -20.78% -6.54
22.00 40.00 31.46 4.54
innodb select_1_row 4.00 -39.48% -1.13
2.00 4.00 2.87 0.70
innodb select_1_row_cache 3.00 -11.09% -0.30
2.00 4.00 2.70 0.69
innodb select_2_rows 4.00 -38.12% -1.10
2.00 4.00 2.90 0.71
innodb select_big 11.00 +9.62% 1.17
0.00 31.00 12.17 1.54
innodb select_big_str 1.00 +14.40% 0.17
0.00 2.00 1.17 0.38
innodb select_cache 61.00 -2.14% -1.28
49.00 77.00 59.72 5.61
innodb select_cache2 61.00 -1.54% -0.93
49.00 75.00 60.07 6.24
innodb select_column+column 4.00 -35.89% -1.06
2.00 4.00 2.94 0.72
innodb select_diff_key 1.00 -350.51% -0.78
0.00 1.00 0.22 0.42
innodb select_distinct 5.00 -17.78% -0.75
3.00 8.00 4.25 0.55
innodb select_group 15.00 +7.78% 1.27
4.00 136.00 16.27 5.37
innodb select_group_when_MANY_tables 12.00 -25.90% -2.47
3.00 49.00 9.53 9.34
innodb select_join 1.00 -73.87% -0.42
0.00 1.00 0.58 0.49
innodb select_key 65.00 -22.59% -11.98
40.00 66.00 53.02 7.55
innodb select_key2 72.00 -20.57% -12.28
45.00 75.00 59.72 8.38
innodb select_key2_return_key 69.00 -20.94% -11.95
42.00 71.00 57.05 8.19
innodb select_key2_return_prim 71.00 -22.81% -13.19
42.00 72.00 57.81 8.33
innodb select_key_prefix 71.00 -20.37% -12.02
44.00 75.00 58.98 8.41
innodb select_key_prefix_join 5.00 -5.76% -0.27
3.00 10.00 4.73 0.65
innodb select_key_return_key 63.00 -21.04% -10.95
38.00 65.00 52.05 7.56
innodb select_many_fields 14.00 +6.04% 0.90
11.00 19.00 14.90 1.79
innodb select_range 45.00 +4.11% 1.93
38.00 76.00 46.93 4.05
innodb select_range_key2 10.00 -20.61% -1.71
6.00 11.00 8.29 1.06
innodb select_range_prefix 9.00 -14.38% -1.13
5.00 10.00 7.87 1.12
innodb select_simple 2.00 -20.82% -0.34
1.00 3.00 1.66 0.51
innodb select_simple_cache 2.00 -27.71% -0.43
1.00 3.00 1.57 0.51
innodb select_simple_join 0.00 +100.00% 0.66
0.00 3.00 0.66 0.48
innodb update_autocommit 3.00 +10.19% 0.34
2.00 16.00 3.34 1.00
innodb update_big 57.00 -11.36% -5.82
31.00 195.00 51.18 24.19
innodb update_commit 2.00 -27.29% -0.43
1.00 10.00 1.57 0.72
innodb update_of_key 22.00 +9.03% 2.18
18.00 100.00 24.18 6.10
innodb update_of_key_big 36.00 -30.09% -8.33
15.00 75.00 27.67 10.93
innodb update_of_primary_key_many_keys 1341.00 -7.84% -97.51
647.00 6065.00 1243.49 943.85
innodb update_rollback 2.00 -13.19% -0.23
1.00 31.00 1.77 1.88
innodb update_with_key 127.00 -15.30% -16.86
90.00 598.00 110.14 20.61
innodb update_with_key_prefix 44.00 -10.69% -4.25
33.00 202.00 39.75 6.78
innodb wisc_benchmark 3.00 -21.26% -0.53
2.00 5.00 2.47 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2228.1.8: Monty Taylor 2011-03-11 [merge] Merge Andrew: drizzledump bugfix
2228.3.2: Andrew Hutchings 2011-03-10 Add test case for drizzledump index
part handling
2228.3.1: Andrew Hutchings 2011-03-10 Fix multi-part index length
processing in drizzledump
2228.1.7: Monty Taylor 2011-03-11 [merge] Merge Andrew: drizzledump bugfix
2228.2.1: Andrew Hutchings 2011-03-11 Add REPLICATE=FALSE support to
drizzledump
2228.1.6: Monty Taylor 2011-03-11 [merge] Merge Andrew: Slave Bugfix
2227.3.1: Andrew Hutchings 2011-03-10 Fix TIME type comparators
2228.1.5: Monty Taylor 2011-03-11 [merge] Merge Andrew: Doc Fix Bug
2227.2.1: Andrew Hutchings 2011-03-10 Add a note in installing/from_source
to use contributing/code if you plan on contributing (to avoid a confusion from
earlier today).
2228.1.4: Monty Taylor 2011-03-10 [merge] Merged pbms bug fixes.
1919.3.47: Barry.Leslie@Prim... 2011-03-04 Added back in schema event
observer list cleanup.
1919.3.46: Barry.Leslie@Prim... 2011-03-04 [merge] Merged with lp:drizzle.
1919.3.45: Barry.Leslie@Prim... 2011-02-21 Fixed bug in merged code.
1919.3.44: Barry.Leslie@Prim... 2011-02-21 [merge] Merged with trunk.
1919.3.43: Barry.Leslie@Prim... 2011-02-11 [merge] Merged with lp:drizzle.
1919.3.42: Barry.Leslie@Prim... 2011-01-21 [merge] Merged with lp:drizzle.
1919.3.41: Barry.Leslie@Prim... 2011-01-21 Fixed a possible crash cause
when shutting down.
1919.3.40: Barry.Leslie@Prim... 2011-01-21 Fixed 2 bugs in the S3 protocol
code. One caused a jumpstack overflow and the other
1919.3.39: Barry.Leslie@Prim... 2011-01-21 Restoring original pbms tests.
1919.3.38: Barry.Leslie@Prim... 2011-01-10 A test
1919.3.37: Barry.Leslie@Prim... 2011-01-10 A test
1919.3.36: Barry.Leslie@Prim... 2011-01-07 Testing
1919.3.35: Barry.Leslie@Prim... 2011-01-04 testing
1919.3.34: Barry.Leslie@Prim... 2011-01-04 Norrowing down valgrid problems.
1919.3.33: Barry.Leslie@Prim... 2011-01-03 More testing.
1919.3.32: Barry.Leslie@Prim... 2011-01-03 Changes for valgrind testing.
1919.3.31: Barry.Leslie@Prim... 2011-01-03 Temporary change to isolate
valgrind problem.
1919.3.30: Barry.Leslie@Prim... 2010-12-15 An other valgrind test.
1919.3.29: Barry.Leslie@Prim... 2010-12-15 More valgrind pbms testing.
1919.3.28: Barry.Leslie@Prim... 2010-12-14 Teporarily remove pbms tests.
1919.3.27: Barry.Leslie@Prim... 2010-12-14 A check to see if valgrind
problem has something to do with pbms being loaded but not used.
1919.3.26: Barry.Leslie@Prim... 2010-12-14 Fix some questionable code.
1919.3.25: Barry.Leslie@Prim... 2010-12-12 Added testcase to see if
valgrind problem is reproducable with a simple events plugin.
1919.3.24: Barry.Leslie@Prim... 2010-12-08 Removed unneeded valgrind
include.
1919.3.23: Barry.Leslie@Prim... 2010-12-07 [merge] Merged with trunk
1919.3.22: Barry.Leslie@Prim... 2010-12-02 Switched the signal used for
internal thread signalling fron SIGUSR2 to SIGUSR1 to avoid
1919.3.21: Barry.Leslie@Prim... 2010-11-29 [merge] merge with trunk
1919.3.20: Barry.Leslie@Prim... 2010-11-29 [merge] merge with trunk
1919.3.19: Barry.Leslie@Prim... 2010-11-17 Fixed PBMS test case.
1919.3.18: Barry.Leslie@Prim... 2010-11-16 Fixed merge error.
1919.3.17: Barry.Leslie@Prim... 2010-11-16 Fixed bug where MD5_Checksum was
truncated when selected from the pbms_reference table.
1919.3.16: Barry.Leslie@Prim... 2010-11-16 [merge] Merged in trunck changes.
1919.3.15: Barry.Leslie@Prim... 2010-11-16 Fixed a couple of bugs related
to metadata updates and inserts.
1919.3.14: Barry.Leslie@Prim... 2010-11-16 Made it possible to test if a
database exists via its id number.
1919.3.13: Barry.Leslie@Prim... 2010-11-16 Added some basic PBMS tests.
1919.3.12: Barry.Leslie@Prim... 2010-11-16 PBMS transaction error logging
now ignores transaction errors for non existent databases or tables.
1919.3.11: Barry.Leslie@Prim... 2010-11-16 Added some debug code to help
detect unexpected locks.
1919.3.10: Barry.Leslie@Prim... 2010-11-12 Fixed some stack size problems
for stack > 32K.
1919.3.9: Barry.Leslie@Prim... 2010-11-10 [merge] Merge with trunk.
1919.3.8: Barry.Leslie@Prim... 2010-11-10 Fixed problem that was the result
of confusion caused by an unreferences file object pool list.
1919.3.7: Barry.Leslie@Prim... 2010-11-10 Fixed object leak.
1919.3.6: Barry.Leslie@Prim... 2010-11-10 Fix broken code caused by changes
to Field_blob::store_length()
1919.3.5: Barry.Leslie@Prim... 2010-11-10 Improved cleanup for session and
schema event lists.
1919.3.4: Barry.Leslie@Prim... 2010-11-10 Fixed PBMS object reference leak
problem.
1919.3.3: Barry.Leslie@Prim... 2010-11-09 Cleaned up some incorrect
parameter types used when scanning system tables.
1919.3.2: Barry.Leslie@Prim... 2010-11-09 Fix for possible access of
uninitialised value in blob_url if it was not null terminated.
1919.3.1: Barry.Leslie@Prim... 2010-11-09 Fix for leaked schema event
observers.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
