=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 979
RUN DATE: 2011-03-28T11:44:27.061856
SERVER: drizzled
VERSION: staging
REVISION: 2255
COMMENT: 2255: Lee Bieber 2011-03-28 [merge] Merge Patrick - Tweaked dbqp so
that the existing slave tests work.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 +0.62% 0.20
32.00 33.00 32.20 0.40
innodb alter_table_drop 22.00 +5.98% 1.40
22.00 24.00 23.40 0.80
innodb connect 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
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 17.00 -8.97% -1.40
13.00 17.00 15.60 1.74
innodb count_distinct 6.00 +14.29% 1.00
6.00 8.00 7.00 0.63
innodb count_distinct_2 13.00 +7.14% 1.00
12.00 17.00 14.00 2.10
innodb count_distinct_big 24.00 -4.35% -1.00
21.00 25.00 23.00 1.67
innodb count_distinct_group 14.00 +4.11% 0.60
14.00 16.00 14.60 0.80
innodb count_distinct_group_on_key 8.00 +9.09% 0.80
8.00 10.00 8.80 0.75
innodb count_distinct_group_on_key_parts 11.00 +11.29% 1.40
11.00 14.00 12.40 1.20
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 95.00 -0.64% -0.60
93.00 96.00 94.40 1.20
innodb create+drop 33.00 +1.20% 0.40
32.00 34.00 33.40 0.80
innodb create_index 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
innodb create_key+drop 31.00 +0.64% 0.20
30.00 32.00 31.20 0.75
innodb create_MANY_tables 20.00 -0.00% 0.00
20.00 20.00 20.00 0.00
innodb delete_all_many_keys 627.00 +3.00% 19.40
627.00 663.00 646.40 13.75
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.40
0.00 1.00 0.40 0.49
innodb delete_big_many_keys 626.00 +3.04% 19.60
626.00 662.00 645.60 13.95
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -0.00% 0.00
2.00 4.00 3.00 0.63
innodb delete_range 7.00 +16.67% 1.40
7.00 9.00 8.40 0.80
innodb delete_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb drop_index 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb drop_table_when_MANY_tables 19.00 -3.26% -0.60
18.00 19.00 18.40 0.49
innodb insert 114.00 -0.88% -1.00
111.00 114.00 113.00 1.10
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.00% 0.00
19.00 19.00 19.00 0.00
innodb insert_key 276.00 +1.36% 3.80
271.00 289.00 279.80 6.24
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 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb insert_select_2_keys 6.00 -3.45% -0.20
5.00 7.00 5.80 0.75
innodb min_max 8.00 -5.26% -0.40
6.00 9.00 7.60 1.02
innodb min_max_on_key 25.00 -1.63% -0.40
24.00 25.00 24.60 0.49
innodb multiple_value_insert 7.00 -6.06% -0.40
6.00 7.00 6.60 0.49
innodb once_prepared_select 29.00 +1.36% 0.40
29.00 30.00 29.40 0.49
innodb order_by_big 15.00 -4.17% -0.60
13.00 15.00 14.40 0.80
innodb order_by_big_key 13.00 +1.52% 0.20
12.00 14.00 13.20 0.75
innodb order_by_big_key2 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb order_by_big_key_desc 14.00 +4.11% 0.60
14.00 16.00 14.60 0.80
innodb order_by_big_key_diff 15.00 -11.94% -1.60
11.00 15.00 13.40 1.36
innodb order_by_big_key_prefix 12.00 +10.45% 1.40
12.00 15.00 13.40 1.02
innodb order_by_key2_diff 2.00 -42.86% -0.60
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 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb outer_join 22.00 +4.35% 1.00
22.00 24.00 23.00 0.89
innodb outer_join_found 22.00 +0.90% 0.20
21.00 23.00 22.20 0.75
innodb outer_join_not_found 18.00 +7.22% 1.40
18.00 21.00 19.40 1.02
innodb outer_join_on_key 14.00 +7.89% 1.20
14.00 16.00 15.20 0.75
innodb prepared_select 38.00 -2.70% -1.00
36.00 38.00 37.00 0.63
innodb select_1_row 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb select_1_row_cache 3.00 +21.05% 0.80
3.00 4.00 3.80 0.40
innodb select_2_rows 4.00 -25.00% -0.80
3.00 4.00 3.20 0.40
innodb select_big 12.00 -1.69% -0.20
11.00 13.00 11.80 0.75
innodb select_big_str 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb select_cache 60.00 +1.32% 0.80
60.00 64.00 60.80 1.60
innodb select_cache2 58.00 +5.23% 3.20
58.00 63.00 61.20 1.72
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.60
0.00 1.00 0.60 0.49
innodb select_distinct 5.00 -19.05% -0.80
4.00 5.00 4.20 0.40
innodb select_group 15.00 +5.06% 0.80
15.00 18.00 15.80 1.17
innodb select_group_when_MANY_tables 10.00 +15.25% 1.80
10.00 13.00 11.80 1.17
innodb select_join 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_key 66.00 -2.80% -1.80
63.00 66.00 64.20 0.98
innodb select_key2 71.00 -0.28% -0.20
70.00 72.00 70.80 0.75
innodb select_key2_return_key 69.00 -0.88% -0.60
67.00 70.00 68.40 1.02
innodb select_key2_return_prim 70.00 -0.57% -0.40
69.00 71.00 69.60 0.80
innodb select_key_prefix 71.00 -0.57% -0.40
70.00 71.00 70.60 0.49
innodb select_key_prefix_join 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb select_key_return_key 64.00 -1.27% -0.80
63.00 64.00 63.20 0.40
innodb select_many_fields 14.00 -6.06% -0.80
13.00 14.00 13.20 0.40
innodb select_range 40.00 +3.38% 1.40
39.00 44.00 41.40 1.85
innodb select_range_key2 9.00 +6.25% 0.60
9.00 10.00 9.60 0.49
innodb select_range_prefix 10.00 -11.11% -1.00
8.00 10.00 9.00 0.89
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 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb update_big 58.00 +2.03% 1.20
58.00 60.00 59.20 0.75
innodb update_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb update_of_key 24.00 -8.11% -1.80
21.00 24.00 22.20 0.98
innodb update_of_key_big 42.00 -10.53% -4.00
33.00 42.00 38.00 2.90
innodb update_of_primary_key_many_keys 1318.00 +1.10% 14.60
1307.00 1374.00 1332.60 23.77
innodb update_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_with_key 122.00 -0.33% -0.40
119.00 124.00 121.60 1.85
innodb update_with_key_prefix 44.00 -0.92% -0.40
42.00 45.00 43.60 1.02
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 32.00 +0.31% 0.10
29.00 34.00 32.10 1.09
innodb alter_table_drop 22.00 +6.78% 1.60
22.00 25.00 23.60 0.86
innodb connect 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
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 17.00 -10.39% -1.60
13.00 19.00 15.40 1.98
innodb count_distinct 6.00 +13.04% 0.90
6.00 8.00 6.90 0.62
innodb count_distinct_2 13.00 +5.45% 0.75
11.00 17.00 13.75 1.55
innodb count_distinct_big 24.00 -5.96% -1.35
21.00 25.00 22.65 1.77
innodb count_distinct_group 14.00 +5.08% 0.75
13.00 16.00 14.75 0.89
innodb count_distinct_group_on_key 8.00 +17.10% 1.65
8.00 12.00 9.65 0.96
innodb count_distinct_group_on_key_parts 11.00 +16.03% 2.10
11.00 15.00 13.10 1.26
innodb count_distinct_key_prefix 5.00 +9.91% 0.55
4.00 6.00 5.55 0.59
innodb count_group_on_key_parts 11.00 -0.92% -0.10
10.00 12.00 10.90 0.54
innodb count_on_key 95.00 -1.06% -1.00
91.00 97.00 94.00 1.90
innodb create+drop 33.00 +0.30% 0.10
31.00 35.00 33.10 0.99
innodb create_index 2.00 +33.33% 1.00
2.00 4.00 3.00 0.45
innodb create_key+drop 31.00 +0.48% 0.15
30.00 34.00 31.15 1.01
innodb create_MANY_tables 20.00 +5.21% 1.10
20.00 24.00 21.10 1.34
innodb delete_all_many_keys 627.00 +1.96% 12.55
582.00 705.00 639.55 24.19
innodb delete_autocommit 4.00 -11.11% -0.40
3.00 5.00 3.60 0.58
innodb delete_big 0.00 +100.00% 0.45
0.00 1.00 0.45 0.50
innodb delete_big_many_keys 626.00 +2.00% 12.75
581.00 704.00 638.75 24.18
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 4.00 2.85 0.57
innodb delete_range 7.00 +17.16% 1.45
7.00 10.00 8.45 0.67
innodb delete_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb drop_index 4.00 -31.15% -0.95
2.00 4.00 3.05 0.50
innodb drop_table_when_MANY_tables 19.00 -2.43% -0.45
17.00 21.00 18.55 0.86
innodb insert 114.00 -0.53% -0.60
111.00 116.00 113.40 1.24
innodb insert_autocommit 3.00 +7.69% 0.25
3.00 4.00 3.25 0.43
innodb insert_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb insert_duplicates 19.00 +0.78% 0.15
19.00 20.00 19.15 0.36
innodb insert_key 276.00 +0.88% 2.45
267.00 296.00 278.45 6.58
innodb insert_many_fields 6.00 -2.56% -0.15
5.00 7.00 5.85 0.48
innodb insert_rollback 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb insert_select_1_key 4.00 -0.00% 0.00
3.00 5.00 4.00 0.71
innodb insert_select_2_keys 6.00 +1.64% 0.10
5.00 8.00 6.10 0.83
innodb min_max 8.00 -3.23% -0.25
6.00 10.00 7.75 0.99
innodb min_max_on_key 25.00 -2.04% -0.50
24.00 25.00 24.50 0.50
innodb multiple_value_insert 7.00 -6.06% -0.40
6.00 7.00 6.60 0.49
innodb once_prepared_select 29.00 +0.85% 0.25
28.00 31.00 29.25 0.70
innodb order_by_big 15.00 -6.76% -0.95
13.00 16.00 14.05 1.12
innodb order_by_big_key 13.00 +6.14% 0.85
12.00 16.00 13.85 1.31
innodb order_by_big_key2 13.00 -2.77% -0.35
11.00 14.00 12.65 0.85
innodb order_by_big_key_desc 14.00 +3.78% 0.55
13.00 16.00 14.55 1.12
innodb order_by_big_key_diff 15.00 -13.64% -1.80
11.00 15.00 13.20 0.93
innodb order_by_big_key_prefix 12.00 +8.05% 1.05
12.00 15.00 13.05 0.97
innodb order_by_key2_diff 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb order_by_key_prefix 1.00 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb order_by_range 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb outer_join 22.00 -0.92% -0.20
18.00 25.00 21.80 2.38
innodb outer_join_found 22.00 -5.52% -1.15
17.00 24.00 20.85 2.33
innodb outer_join_not_found 18.00 +5.76% 1.10
16.00 23.00 19.10 2.17
innodb outer_join_on_key 14.00 +3.45% 0.50
12.00 17.00 14.50 1.75
innodb prepared_select 38.00 -2.43% -0.90
36.00 39.00 37.10 0.54
innodb select_1_row 4.00 -12.68% -0.45
3.00 4.00 3.55 0.50
innodb select_1_row_cache 3.00 +13.04% 0.45
3.00 4.00 3.45 0.50
innodb select_2_rows 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb select_big 12.00 +3.23% 0.40
11.00 14.00 12.40 1.11
innodb select_big_str 1.00 +23.08% 0.30
1.00 2.00 1.30 0.46
innodb select_cache 60.00 +4.53% 2.85
59.00 71.00 62.85 3.02
innodb select_cache2 58.00 +9.02% 5.75
58.00 71.00 63.75 3.28
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.30
0.00 1.00 0.30 0.46
innodb select_distinct 5.00 -9.89% -0.45
4.00 5.00 4.55 0.50
innodb select_group 15.00 +9.64% 1.60
15.00 19.00 16.60 1.46
innodb select_group_when_MANY_tables 10.00 +13.79% 1.60
10.00 13.00 11.60 0.92
innodb select_join 1.00 -81.82% -0.45
0.00 1.00 0.55 0.50
innodb select_key 66.00 -3.13% -2.00
63.00 66.00 64.00 0.71
innodb select_key2 71.00 -0.07% -0.05
70.00 72.00 70.95 0.67
innodb select_key2_return_key 69.00 -1.25% -0.85
67.00 70.00 68.15 0.85
innodb select_key2_return_prim 70.00 -1.23% -0.85
68.00 71.00 69.15 0.73
innodb select_key_prefix 71.00 -0.64% -0.45
69.00 72.00 70.55 0.74
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.67% -1.05
61.00 64.00 62.95 0.74
innodb select_many_fields 14.00 -6.87% -0.90
12.00 14.00 13.10 0.44
innodb select_range 40.00 +6.32% 2.70
39.00 47.00 42.70 2.72
innodb select_range_key2 9.00 +4.76% 0.45
9.00 10.00 9.45 0.50
innodb select_range_prefix 10.00 -7.53% -0.70
8.00 10.00 9.30 0.64
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 0.00 +100.00% 0.85
0.00 1.00 0.85 0.36
innodb update_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb update_big 58.00 +1.86% 1.10
56.00 62.00 59.10 1.37
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 24.00 -8.11% -1.80
21.00 24.00 22.20 0.87
innodb update_of_key_big 42.00 -13.82% -5.10
30.00 46.00 36.90 4.30
innodb update_of_primary_key_many_keys 1318.00 +0.80% 10.60
1232.00 1469.00 1328.60 42.99
innodb update_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb update_with_key 122.00 -0.87% -1.05
117.00 127.00 120.95 2.38
innodb update_with_key_prefix 44.00 -0.11% -0.05
42.00 47.00 43.95 1.53
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 32.00 -47.83% -10.35
11.00 61.00 21.65 10.16
innodb alter_table_drop 22.00 -17.83% -3.33
10.00 57.00 18.67 6.88
innodb connect 3.00 -43.75% -0.91
1.00 3.00 2.09 0.42
innodb connect+select_1_row 3.00 -10.54% -0.29
2.00 5.00 2.71 0.47
innodb connect+select_simple 2.00 +15.36% 0.36
1.00 3.00 2.36 0.49
innodb count 17.00 -7.97% -1.25
12.00 193.00 15.75 8.60
innodb count_distinct 6.00 +8.80% 0.58
5.00 50.00 6.58 2.22
innodb count_distinct_2 13.00 +1.68% 0.22
11.00 63.00 13.22 2.89
innodb count_distinct_big 24.00 -9.19% -2.02
5.00 67.00 21.98 2.98
innodb count_distinct_group 14.00 -5.86% -0.78
10.00 68.00 13.22 3.03
innodb count_distinct_group_on_key 8.00 +15.82% 1.50
7.00 69.00 9.50 2.95
innodb count_distinct_group_on_key_parts 11.00 +11.08% 1.37
9.00 72.00 12.37 3.09
innodb count_distinct_key_prefix 5.00 +2.76% 0.14
3.00 52.00 5.14 2.33
innodb count_group_on_key_parts 11.00 -9.70% -0.97
7.00 72.00 10.03 3.08
innodb count_on_key 95.00 -9.98% -8.62
68.00 107.00 86.38 7.38
innodb create+drop 33.00 -1.61% -0.52
18.00 75.00 32.48 11.57
innodb create_index 2.00 +31.06% 0.90
1.00 8.00 2.90 1.12
innodb create_key+drop 31.00 -9.32% -2.64
21.00 50.00 28.36 4.83
innodb create_MANY_tables 20.00 +40.05% 13.36
14.00 121.00 33.36 16.90
innodb create_table 0.00 +100.00% 0.10
0.00 3.00 0.10 0.35
innodb delete_all_many_keys 627.00 -32.27% -152.98
212.00 1888.00 474.02 356.86
innodb delete_autocommit 4.00 -15.85% -0.55
2.00 14.00 3.45 0.74
innodb delete_big 0.00 +100.00% 0.30
0.00 3.00 0.30 0.47
innodb delete_big_many_keys 626.00 -30.50% -146.29
212.00 2293.00 479.71 370.44
innodb delete_commit 2.00 -30.74% -0.47
1.00 5.00 1.53 0.53
innodb delete_key 3.00 +1.31% 0.04
2.00 35.00 3.04 1.46
innodb delete_range 7.00 +15.92% 1.33
5.00 23.00 8.33 3.15
innodb delete_rollback 2.00 -13.71% -0.24
1.00 12.00 1.76 0.90
innodb drop_index 4.00 -35.42% -1.05
1.00 9.00 2.95 1.29
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.69% 0.52
11.00 90.00 19.52 7.33
innodb insert 114.00 -6.48% -6.94
3.00 343.00 107.06 14.29
innodb insert_autocommit 3.00 +0.26% 0.01
2.00 99.00 3.01 3.23
innodb insert_commit 2.00 -42.54% -0.60
1.00 3.00 1.40 0.50
innodb insert_duplicates 19.00 -21.38% -3.35
11.00 21.00 15.65 2.71
innodb insert_key 276.00 +8.54% 25.79
142.00 700.00 301.79 104.11
innodb insert_many_fields 6.00 -6.77% -0.38
3.00 17.00 5.62 1.73
innodb insert_rollback 2.00 -18.69% -0.31
1.00 3.00 1.69 0.53
innodb insert_select_1_key 4.00 -5.59% -0.21
2.00 10.00 3.79 0.87
innodb insert_select_2_keys 6.00 +1.23% 0.07
4.00 16.00 6.07 2.04
innodb min_max 8.00 -2.27% -0.18
6.00 110.00 7.82 4.43
innodb min_max_on_key 25.00 -20.51% -4.25
14.00 37.00 20.75 3.13
innodb multiple_value_insert 7.00 -27.03% -1.49
2.00 50.00 5.51 4.18
innodb once_prepared_select 29.00 -18.57% -4.54
18.00 32.00 24.46 3.64
innodb order_by_big 15.00 -4.85% -0.69
12.00 31.00 14.31 1.51
innodb order_by_big_key 13.00 +2.39% 0.32
11.00 32.00 13.32 1.64
innodb order_by_big_key2 13.00 -6.30% -0.77
10.00 33.00 12.23 1.52
innodb order_by_big_key_desc 14.00 -3.19% -0.43
11.00 32.00 13.57 1.69
innodb order_by_big_key_diff 15.00 -22.27% -2.73
10.00 31.00 12.27 1.49
innodb order_by_big_key_prefix 12.00 +3.48% 0.43
10.00 32.00 12.43 1.54
innodb order_by_key2_diff 2.00 -43.29% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -25.62% -0.20
0.00 2.00 0.80 0.41
innodb order_by_range 1.00 -19.82% -0.17
0.00 2.00 0.83 0.38
innodb outer_join 22.00 -12.99% -2.53
15.00 61.00 19.47 3.71
innodb outer_join_found 22.00 -16.51% -3.12
14.00 58.00 18.88 3.57
innodb outer_join_not_found 18.00 -8.46% -1.40
12.00 46.00 16.60 3.18
innodb outer_join_on_key 14.00 -7.72% -1.00
10.00 59.00 13.00 2.76
innodb prepared_select 38.00 -20.21% -6.39
22.00 40.00 31.61 4.57
innodb select_1_row 4.00 -38.67% -1.12
2.00 4.00 2.88 0.70
innodb select_1_row_cache 3.00 -10.23% -0.28
2.00 4.00 2.72 0.70
innodb select_2_rows 4.00 -37.26% -1.09
2.00 4.00 2.91 0.71
innodb select_big 12.00 +1.47% 0.18
0.00 31.00 12.18 1.53
innodb select_big_str 1.00 +14.65% 0.17
0.00 2.00 1.17 0.38
innodb select_cache 60.00 -0.33% -0.20
49.00 77.00 59.80 5.58
innodb select_cache2 58.00 +3.61% 2.17
49.00 75.00 60.17 6.21
innodb select_column+column 4.00 -34.82% -1.03
2.00 4.00 2.97 0.73
innodb select_diff_key 0.00 +100.00% 0.22
0.00 1.00 0.22 0.42
innodb select_distinct 5.00 -17.59% -0.75
3.00 8.00 4.25 0.55
innodb select_group 15.00 +7.86% 1.28
4.00 136.00 16.28 5.30
innodb select_group_when_MANY_tables 10.00 -4.29% -0.41
3.00 49.00 9.59 9.23
innodb select_join 1.00 -73.47% -0.42
0.00 1.00 0.58 0.49
innodb select_key 66.00 -23.80% -12.69
40.00 66.00 53.31 7.65
innodb select_key2 71.00 -18.31% -10.99
45.00 75.00 60.01 8.46
innodb select_key2_return_key 69.00 -20.32% -11.65
42.00 71.00 57.35 8.28
innodb select_key2_return_prim 70.00 -20.46% -11.89
42.00 72.00 58.11 8.42
innodb select_key_prefix 71.00 -19.75% -11.71
44.00 75.00 59.29 8.51
innodb select_key_prefix_join 5.00 -5.48% -0.26
3.00 10.00 4.74 0.65
innodb select_key_return_key 64.00 -22.29% -11.66
38.00 65.00 52.34 7.66
innodb select_many_fields 14.00 +5.75% 0.85
11.00 19.00 14.85 1.79
innodb select_range 40.00 +14.56% 6.82
38.00 76.00 46.82 4.08
innodb select_range_key2 9.00 -8.15% -0.68
6.00 11.00 8.32 1.06
innodb select_range_prefix 10.00 -26.48% -2.09
5.00 10.00 7.91 1.13
innodb select_simple 2.00 -20.08% -0.33
1.00 3.00 1.67 0.51
innodb select_simple_cache 2.00 -26.78% -0.42
1.00 3.00 1.58 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.51% -0.65
2.00 16.00 3.35 0.99
innodb update_big 58.00 -12.86% -6.61
31.00 195.00 51.39 23.90
innodb update_commit 2.00 -26.46% -0.42
1.00 10.00 1.58 0.72
innodb update_of_key 24.00 +0.53% 0.13
18.00 100.00 24.13 6.03
innodb update_of_key_big 42.00 -50.53% -14.10
15.00 75.00 27.90 10.90
innodb update_of_primary_key_many_keys 1318.00 -5.75% -71.68
647.00 6065.00 1246.32 928.01
innodb update_rollback 2.00 -12.52% -0.22
1.00 31.00 1.78 1.85
innodb update_with_key 122.00 -10.48% -11.57
90.00 598.00 110.43 20.41
innodb update_with_key_prefix 44.00 -10.39% -4.14
33.00 202.00 39.86 6.73
innodb wisc_benchmark 3.00 -21.07% -0.52
2.00 5.00 2.48 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2254.1.2: Lee Bieber 2011-03-28 [merge] Merge Patrick - Tweaked dbqp so that
the existing slave tests work.
2239.7.4: patrick crews 2011-03-28 Tweaks to drizzled.py's slave.cnf file
to play with multi-master rpl
2239.7.3: patrick crews 2011-03-25 [merge] Merge trunk
2239.7.2: David Shrewsbury 2011-03-19 [merge] Merge trunk
2239.7.1: David Shrewsbury 2011-03-19 Initial beta version of multi-master
code.
2254.1.1: Lee Bieber 2011-03-28 [merge] Merge Stewart - remove over 1000
lines of mysys
2241.4.49: Stewart Smith 2011-03-29 [merge] merge trunk
2241.4.48: Stewart Smith 2011-03-28 remove internal/default.cc from
POTFILES.in
2241.4.47: Stewart Smith 2011-03-28 remove wf_*() functions and class
wild_file_pack from my_sys.h
2241.4.46: Stewart Smith 2011-03-28 just completely remove
drizzled/internal/default.cc - everything remaining is unused
2241.4.45: Stewart Smith 2011-03-28 struct handle_option_ctx in
internal/default.cc unused
2241.4.44: Stewart Smith 2011-03-28 the remaining functions in default.cc
were unused.
2241.4.43: Stewart Smith 2011-03-28 some variables declared in
internal/default.cc and extern in my_sys.h are unused
2241.4.42: Stewart Smith 2011-03-28 handle_default_option() in
internal/default.cc is unused
2241.4.41: Stewart Smith 2011-03-28 moving load_defaults() and
free_defaults() ouf ot my_sys.h and into being static in internal/default.cc
showed that they were unused. Not only that, this meant that a bunch of other
parts of default.cc are also unused. nice - remove them all.
2241.4.40: Stewart Smith 2011-03-28 move prototype for
get_defaults_options() just into internal/default.cc and out of my_sys.h
2241.4.39: Stewart Smith 2011-03-28 remove prototype of non-existant
my_sleep()
2241.4.38: Stewart Smith 2011-03-28 remove my_print_default_files() and
print_defaults() which turn out to be unused
2241.4.37: Stewart Smith 2011-03-28 remove the drizzled::internal namespace
prefix from teh typedef for ha_checksum - it's just for myisam now
2241.4.36: Stewart Smith 2011-03-28 move my_checksum() into myisam (only
used there). This patch keeps the internal namespace for the ha_checksum
typedef, which should possibly be changed
2241.4.35: Stewart Smith 2011-03-28 Process_option_func typedef and
my_search_option_files() can be moved to just be in internal/default.cc instead
of in my_sys.h
2241.4.34: Stewart Smith 2011-03-28 there is also check_if_legal_filename
2241.4.33: Stewart Smith 2011-03-28 we have no _sanity()
2241.4.32: Stewart Smith 2011-03-28 thd_increment_ functions no longer
exist, remove from my_sys.h
2241.4.31: Stewart Smith 2011-03-28 strlength() can be private to
mf_format.cc and not in my_sys header
2241.4.30: Stewart Smith 2011-03-28 remove my_filename() from my_sys - it's
unused
2241.4.29: Stewart Smith 2011-03-28 remove HAVE_AIOWAIT ifdefs around the
place - it turns out this wouldn't have compiled anyway (my_filename() was
called but is never defined). I think this is all old code that was meant to
use Solaris aiowait - certainly doesn't work now.
2241.4.28: Stewart Smith 2011-03-28 move DFLT_INIT_HITS define to
myisam_priv.h - only used by myisam
2241.4.27: Stewart Smith 2011-03-28 move MY_WAIT_FOR_USER_TO_FIX_PANIC and
MY_WAIT_GIVE_USER_A_MESSAGE to myisam/my_pread.cc as they are only used there.
2241.4.26: Stewart Smith 2011-03-28 remove mysys_uses_curses - unused
2241.4.25: Stewart Smith 2011-03-28 remove some safe malloc remnants
2241.4.24: Stewart Smith 2011-03-28 remove some remnats of soundex
2241.4.23: Stewart Smith 2011-03-28 remove the unused my_file_limit global
var in drizzled::internal
2241.4.22: Stewart Smith 2011-03-28 remove MY_ERRNO_EDOM and
MY_ERRNO_ERANGE. Instead, we should consistently use the system EDOM and
ERANGE. If on any platform, they weren't 33 and 34 respectively, we would have
had bugs.
2241.4.21: Stewart Smith 2011-03-28 remove trash_mem and TRASH - they are
unused
2241.4.20: Stewart Smith 2011-03-28 don't export my_init_done - it's only
checked by my_init() and my_end(). Also use true/false not 1/0
2241.4.19: Stewart Smith 2011-03-28 A few unused bits of mysys. Turns out
internal::get_date() was only used by one codepath of my_redel() which was
never called due to a flag never being set in MyISAM. Just rip it out. One
whole less file to build
2241.4.18: Stewart Smith 2011-03-28 add include of sys/types.h to my_sys.h
as it uses uint which is in sys/types.h on OSX
2241.4.17: Stewart Smith 2011-03-28 remove mysys_usage_id. it uses uint and
is unused anyway
2241.4.16: Stewart Smith 2011-03-28 fix charset_info includes
2241.4.15: Stewart Smith 2011-03-28 [merge] merge trunk
2241.4.14: Stewart Smith 2011-03-18 remove some includes from my_sys.h and
instead only include where needed. This helps reduce the number of files that
have to be rebuilt when you change some of the more widely included header
files (such as the drizzled::identifier ones)
2241.4.13: Stewart Smith 2011-03-18 fix my_bit.cc config.h include
2241.4.12: Stewart Smith 2011-03-18 fix my_bit.cc include file
2241.4.11: Stewart Smith 2011-03-18 my_bit.cc actually needs no include
files
2241.4.10: Stewart Smith 2011-03-18 myisam.h doesn't need charset_info
include
2241.4.9: Stewart Smith 2011-03-18 myisam.h acn just have forward decl of
table identifier
2241.4.8: Stewart Smith 2011-03-18 heap.h doesn't need common.h
2241.4.7: Stewart Smith 2011-03-18 heap.h doesn't neeed
drizzled/internal/my_pthread.h
2241.4.6: Stewart Smith 2011-03-18 heap.h doesn't neeed drizzled/tree.h
2241.4.5: Stewart Smith 2011-03-18 remove two #includes from heap_priv.h -
include error_t.h only where needed
2241.4.4: Stewart Smith 2011-03-18 heap_priv.h doesn't need
internal/my_pthread.h
2241.4.3: Stewart Smith 2011-03-18 heap_priv doesn't need drizzled/tree.h
2241.4.2: Stewart Smith 2011-03-18 forward decl of boost mutex works fine
for heap_priv mutex
2241.4.1: Stewart Smith 2011-03-18 hp_static.cc doesn't need heap_priv
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
