=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 548
RUN DATE: 2010-10-11T15:53:37.419361
SERVER: drizzled
VERSION: elliott-staging
REVISION: 1839
COMMENT: 1839: lbieber 2010-10-11 [merge] Merge Shrews - Fix bug 656971:
Replication stream should send server events
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb alter_table_drop 15.00 -0.00% 0.00
15.00 15.00 15.00 0.00
innodb connect 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb connect+select_1_row 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb connect+select_simple 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb count 18.00 -16.13% -2.50
13.00 18.00 15.50 2.50
innodb count_distinct 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb count_distinct_2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_distinct_big 23.00 -6.98% -1.50
20.00 23.00 21.50 1.50
innodb count_distinct_group 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_distinct_group_on_key 9.00 -5.88% -0.50
8.00 9.00 8.50 0.50
innodb count_distinct_group_on_key_parts 10.00 +4.76% 0.50
10.00 11.00 10.50 0.50
innodb count_distinct_key_prefix 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb count_group_on_key_parts 10.00 -0.00% 0.00
10.00 10.00 10.00 0.00
innodb count_on_key 85.00 -0.00% 0.00
85.00 85.00 85.00 0.00
innodb create+drop 24.00 +12.73% 3.50
24.00 31.00 27.50 3.50
innodb create_index 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb create_key+drop 27.00 -1.89% -0.50
26.00 27.00 26.50 0.50
innodb create_MANY_tables 22.00 +12.00% 3.00
22.00 28.00 25.00 3.00
innodb create_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb delete_all_many_keys 220.00 +8.14% 19.50
220.00 259.00 239.50 19.50
innodb delete_autocommit 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb delete_big 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb delete_big_many_keys 220.00 +7.95% 19.00
220.00 258.00 239.00 19.00
innodb delete_commit 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb delete_rollback 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb drop_index 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 14.00 +6.67% 1.00
14.00 16.00 15.00 1.00
innodb insert 106.00 +1.85% 2.00
106.00 110.00 108.00 2.00
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb insert_duplicates 14.00 -3.70% -0.50
13.00 14.00 13.50 0.50
innodb insert_key 162.00 +5.81% 10.00
162.00 182.00 172.00 10.00
innodb insert_many_fields 6.00 -9.09% -0.50
5.00 6.00 5.50 0.50
innodb insert_rollback 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb insert_select_1_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_select_2_keys 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb min_max 9.00 -12.50% -1.00
7.00 9.00 8.00 1.00
innodb min_max_on_key 19.00 +2.56% 0.50
19.00 20.00 19.50 0.50
innodb multiple_value_insert 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb once_prepared_select 22.00 +8.33% 2.00
22.00 26.00 24.00 2.00
innodb order_by_big 12.00 +4.00% 0.50
12.00 13.00 12.50 0.50
innodb order_by_big_key 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb order_by_big_key2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb order_by_big_key_desc 13.00 -4.00% -0.50
12.00 13.00 12.50 0.50
innodb order_by_big_key_diff 11.00 -4.76% -0.50
10.00 11.00 10.50 0.50
innodb order_by_big_key_prefix 12.00 -4.35% -0.50
11.00 12.00 11.50 0.50
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
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 15.00 +11.76% 2.00
15.00 19.00 17.00 2.00
innodb outer_join_found 16.00 +8.57% 1.50
16.00 19.00 17.50 1.50
innodb outer_join_not_found 14.00 +6.67% 1.00
14.00 16.00 15.00 1.00
innodb outer_join_on_key 12.00 +4.00% 0.50
12.00 13.00 12.50 0.50
innodb prepared_select 27.00 +10.00% 3.00
27.00 33.00 30.00 3.00
innodb select_1_row 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb select_1_row_cache 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb select_2_rows 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb select_big 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 53.00 -0.00% 0.00
53.00 53.00 53.00 0.00
innodb select_cache2 52.00 +1.89% 1.00
52.00 54.00 53.00 1.00
innodb select_column+column 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb select_diff_key 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb select_distinct 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_group 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb select_group_when_MANY_tables 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_join 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb select_key 51.00 -0.00% 0.00
51.00 51.00 51.00 0.00
innodb select_key2 66.00 -9.09% -5.50
55.00 66.00 60.50 5.50
innodb select_key2_return_key 54.00 +5.26% 3.00
54.00 60.00 57.00 3.00
innodb select_key2_return_prim 55.00 +6.78% 4.00
55.00 63.00 59.00 4.00
innodb select_key_prefix 56.00 -0.90% -0.50
55.00 56.00 55.50 0.50
innodb select_key_prefix_join 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_key_return_key 50.00 -1.01% -0.50
49.00 50.00 49.50 0.50
innodb select_many_fields 15.00 +6.25% 1.00
15.00 17.00 16.00 1.00
innodb select_range 45.00 -0.00% 0.00
45.00 45.00 45.00 0.00
innodb select_range_key2 8.00 -0.00% 0.00
8.00 8.00 8.00 0.00
innodb select_range_prefix 7.00 +6.67% 0.50
7.00 8.00 7.50 0.50
innodb select_simple 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb select_simple_cache 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb select_simple_join 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb TOTALS 2779.00 +4.27% 124.00
2779.00 3027.00 2903.00 124.00
innodb update_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb update_big 36.00 -1.41% -0.50
35.00 36.00 35.50 0.50
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 21.00 +6.67% 1.50
21.00 24.00 22.50 1.50
innodb update_of_key_big 18.00 +5.26% 1.00
18.00 20.00 19.00 1.00
innodb update_of_primary_key_many_keys 699.00 +7.72% 58.50
699.00 816.00 757.50 58.50
innodb update_rollback 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb update_with_key 108.00 -0.47% -0.50
107.00 108.00 107.50 0.50
innodb update_with_key_prefix 36.00 +4.00% 1.50
36.00 39.00 37.50 1.50
innodb wisc_benchmark 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb alter_table_drop 15.00 -0.00% 0.00
15.00 15.00 15.00 0.00
innodb connect 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb connect+select_1_row 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb connect+select_simple 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb count 18.00 -16.13% -2.50
13.00 18.00 15.50 2.50
innodb count_distinct 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb count_distinct_2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_distinct_big 23.00 -6.98% -1.50
20.00 23.00 21.50 1.50
innodb count_distinct_group 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_distinct_group_on_key 9.00 -5.88% -0.50
8.00 9.00 8.50 0.50
innodb count_distinct_group_on_key_parts 10.00 +4.76% 0.50
10.00 11.00 10.50 0.50
innodb count_distinct_key_prefix 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb count_group_on_key_parts 10.00 -0.00% 0.00
10.00 10.00 10.00 0.00
innodb count_on_key 85.00 -0.00% 0.00
85.00 85.00 85.00 0.00
innodb create+drop 24.00 +12.73% 3.50
24.00 31.00 27.50 3.50
innodb create_index 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb create_key+drop 27.00 -1.89% -0.50
26.00 27.00 26.50 0.50
innodb create_MANY_tables 22.00 +12.00% 3.00
22.00 28.00 25.00 3.00
innodb create_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb delete_all_many_keys 220.00 +8.14% 19.50
220.00 259.00 239.50 19.50
innodb delete_autocommit 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb delete_big 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb delete_big_many_keys 220.00 +7.95% 19.00
220.00 258.00 239.00 19.00
innodb delete_commit 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb delete_rollback 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb drop_index 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 14.00 +6.67% 1.00
14.00 16.00 15.00 1.00
innodb insert 106.00 +1.85% 2.00
106.00 110.00 108.00 2.00
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb insert_duplicates 14.00 -3.70% -0.50
13.00 14.00 13.50 0.50
innodb insert_key 162.00 +5.81% 10.00
162.00 182.00 172.00 10.00
innodb insert_many_fields 6.00 -9.09% -0.50
5.00 6.00 5.50 0.50
innodb insert_rollback 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb insert_select_1_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_select_2_keys 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb min_max 9.00 -12.50% -1.00
7.00 9.00 8.00 1.00
innodb min_max_on_key 19.00 +2.56% 0.50
19.00 20.00 19.50 0.50
innodb multiple_value_insert 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb once_prepared_select 22.00 +8.33% 2.00
22.00 26.00 24.00 2.00
innodb order_by_big 12.00 +4.00% 0.50
12.00 13.00 12.50 0.50
innodb order_by_big_key 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb order_by_big_key2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb order_by_big_key_desc 13.00 -4.00% -0.50
12.00 13.00 12.50 0.50
innodb order_by_big_key_diff 11.00 -4.76% -0.50
10.00 11.00 10.50 0.50
innodb order_by_big_key_prefix 12.00 -4.35% -0.50
11.00 12.00 11.50 0.50
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
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 15.00 +11.76% 2.00
15.00 19.00 17.00 2.00
innodb outer_join_found 16.00 +8.57% 1.50
16.00 19.00 17.50 1.50
innodb outer_join_not_found 14.00 +6.67% 1.00
14.00 16.00 15.00 1.00
innodb outer_join_on_key 12.00 +4.00% 0.50
12.00 13.00 12.50 0.50
innodb prepared_select 27.00 +10.00% 3.00
27.00 33.00 30.00 3.00
innodb select_1_row 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb select_1_row_cache 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb select_2_rows 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb select_big 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 53.00 -0.00% 0.00
53.00 53.00 53.00 0.00
innodb select_cache2 52.00 +1.89% 1.00
52.00 54.00 53.00 1.00
innodb select_column+column 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb select_diff_key 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb select_distinct 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_group 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb select_group_when_MANY_tables 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_join 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb select_key 51.00 -0.00% 0.00
51.00 51.00 51.00 0.00
innodb select_key2 66.00 -9.09% -5.50
55.00 66.00 60.50 5.50
innodb select_key2_return_key 54.00 +5.26% 3.00
54.00 60.00 57.00 3.00
innodb select_key2_return_prim 55.00 +6.78% 4.00
55.00 63.00 59.00 4.00
innodb select_key_prefix 56.00 -0.90% -0.50
55.00 56.00 55.50 0.50
innodb select_key_prefix_join 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_key_return_key 50.00 -1.01% -0.50
49.00 50.00 49.50 0.50
innodb select_many_fields 15.00 +6.25% 1.00
15.00 17.00 16.00 1.00
innodb select_range 45.00 -0.00% 0.00
45.00 45.00 45.00 0.00
innodb select_range_key2 8.00 -0.00% 0.00
8.00 8.00 8.00 0.00
innodb select_range_prefix 7.00 +6.67% 0.50
7.00 8.00 7.50 0.50
innodb select_simple 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb select_simple_cache 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb select_simple_join 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb TOTALS 2779.00 +4.27% 124.00
2779.00 3027.00 2903.00 124.00
innodb update_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb update_big 36.00 -1.41% -0.50
35.00 36.00 35.50 0.50
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 21.00 +6.67% 1.50
21.00 24.00 22.50 1.50
innodb update_of_key_big 18.00 +5.26% 1.00
18.00 20.00 19.00 1.00
innodb update_of_primary_key_many_keys 699.00 +7.72% 58.50
699.00 816.00 757.50 58.50
innodb update_rollback 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb update_with_key 108.00 -0.47% -0.50
107.00 108.00 107.50 0.50
innodb update_with_key_prefix 36.00 +4.00% 1.50
36.00 39.00 37.50 1.50
innodb wisc_benchmark 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb alter_table_drop 15.00 -0.00% 0.00
15.00 15.00 15.00 0.00
innodb connect 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb connect+select_1_row 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb connect+select_simple 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb count 18.00 -16.13% -2.50
13.00 18.00 15.50 2.50
innodb count_distinct 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb count_distinct_2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_distinct_big 23.00 -6.98% -1.50
20.00 23.00 21.50 1.50
innodb count_distinct_group 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb count_distinct_group_on_key 9.00 -5.88% -0.50
8.00 9.00 8.50 0.50
innodb count_distinct_group_on_key_parts 10.00 +4.76% 0.50
10.00 11.00 10.50 0.50
innodb count_distinct_key_prefix 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb count_group_on_key_parts 10.00 -0.00% 0.00
10.00 10.00 10.00 0.00
innodb count_on_key 85.00 -0.00% 0.00
85.00 85.00 85.00 0.00
innodb create+drop 24.00 +12.73% 3.50
24.00 31.00 27.50 3.50
innodb create_index 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb create_key+drop 27.00 -1.89% -0.50
26.00 27.00 26.50 0.50
innodb create_MANY_tables 22.00 +12.00% 3.00
22.00 28.00 25.00 3.00
innodb create_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb delete_all_many_keys 220.00 +8.14% 19.50
220.00 259.00 239.50 19.50
innodb delete_autocommit 4.00 -14.29% -0.50
3.00 4.00 3.50 0.50
innodb delete_big 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb delete_big_many_keys 220.00 +7.95% 19.00
220.00 258.00 239.00 19.00
innodb delete_commit 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb delete_rollback 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb drop_index 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 14.00 +6.67% 1.00
14.00 16.00 15.00 1.00
innodb insert 106.00 +1.85% 2.00
106.00 110.00 108.00 2.00
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb insert_duplicates 14.00 -3.70% -0.50
13.00 14.00 13.50 0.50
innodb insert_key 162.00 +5.81% 10.00
162.00 182.00 172.00 10.00
innodb insert_many_fields 6.00 -9.09% -0.50
5.00 6.00 5.50 0.50
innodb insert_rollback 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb insert_select_1_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_select_2_keys 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb min_max 9.00 -12.50% -1.00
7.00 9.00 8.00 1.00
innodb min_max_on_key 19.00 +2.56% 0.50
19.00 20.00 19.50 0.50
innodb multiple_value_insert 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb once_prepared_select 22.00 +8.33% 2.00
22.00 26.00 24.00 2.00
innodb order_by_big 12.00 +4.00% 0.50
12.00 13.00 12.50 0.50
innodb order_by_big_key 12.00 -0.00% 0.00
12.00 12.00 12.00 0.00
innodb order_by_big_key2 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb order_by_big_key_desc 13.00 -4.00% -0.50
12.00 13.00 12.50 0.50
innodb order_by_big_key_diff 11.00 -4.76% -0.50
10.00 11.00 10.50 0.50
innodb order_by_big_key_prefix 12.00 -4.35% -0.50
11.00 12.00 11.50 0.50
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
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 15.00 +11.76% 2.00
15.00 19.00 17.00 2.00
innodb outer_join_found 16.00 +8.57% 1.50
16.00 19.00 17.50 1.50
innodb outer_join_not_found 14.00 +6.67% 1.00
14.00 16.00 15.00 1.00
innodb outer_join_on_key 12.00 +4.00% 0.50
12.00 13.00 12.50 0.50
innodb prepared_select 27.00 +10.00% 3.00
27.00 33.00 30.00 3.00
innodb select_1_row 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb select_1_row_cache 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb select_2_rows 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb select_big 11.00 -0.00% 0.00
11.00 11.00 11.00 0.00
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 53.00 -0.00% 0.00
53.00 53.00 53.00 0.00
innodb select_cache2 52.00 +1.89% 1.00
52.00 54.00 53.00 1.00
innodb select_column+column 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb select_diff_key 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb select_distinct 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_group 18.00 -0.00% 0.00
18.00 18.00 18.00 0.00
innodb select_group_when_MANY_tables 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_join 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb select_key 51.00 -0.00% 0.00
51.00 51.00 51.00 0.00
innodb select_key2 66.00 -9.09% -5.50
55.00 66.00 60.50 5.50
innodb select_key2_return_key 54.00 +5.26% 3.00
54.00 60.00 57.00 3.00
innodb select_key2_return_prim 55.00 +6.78% 4.00
55.00 63.00 59.00 4.00
innodb select_key_prefix 56.00 -0.90% -0.50
55.00 56.00 55.50 0.50
innodb select_key_prefix_join 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_key_return_key 50.00 -1.01% -0.50
49.00 50.00 49.50 0.50
innodb select_many_fields 15.00 +6.25% 1.00
15.00 17.00 16.00 1.00
innodb select_range 45.00 -0.00% 0.00
45.00 45.00 45.00 0.00
innodb select_range_key2 8.00 -0.00% 0.00
8.00 8.00 8.00 0.00
innodb select_range_prefix 7.00 +6.67% 0.50
7.00 8.00 7.50 0.50
innodb select_simple 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb select_simple_cache 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb select_simple_join 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb TOTALS 2779.00 +4.27% 124.00
2779.00 3027.00 2903.00 124.00
innodb update_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb update_big 36.00 -1.41% -0.50
35.00 36.00 35.50 0.50
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 21.00 +6.67% 1.50
21.00 24.00 22.50 1.50
innodb update_of_key_big 18.00 +5.26% 1.00
18.00 20.00 19.00 1.00
innodb update_of_primary_key_many_keys 699.00 +7.72% 58.50
699.00 816.00 757.50 58.50
innodb update_rollback 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb update_with_key 108.00 -0.47% -0.50
107.00 108.00 107.50 0.50
innodb update_with_key_prefix 36.00 +4.00% 1.50
36.00 39.00 37.50 1.50
innodb wisc_benchmark 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
=========================================================================================================================
FULL REVISION COMMENTARY:
1838.1.2: lbieber 2010-10-11 [merge] Merge Shrews - Fix bug 656971:
Replication stream should send server events
1819.4.4: David Shrewsbury 2010-10-11 [merge] Merge from trunk and resolve
conflicts
1819.4.3: David Shrewsbury 2010-10-10 Added event.proto
1819.4.2: David Shrewsbury 2010-10-10 [merge] Merged from trunk
1819.4.1: David Shrewsbury 2010-10-10 Add server startup and shutdown
events to the replication stream.
1838.1.1: lbieber 2010-10-11 [merge] Merge Andrew - Fix bug 655954:
Drizzledump conversion of '0000-00-00' date values to NULL can be problematic
on NOT NULL columns
1836.1.1: Andrew Hutchings 2010-10-11 The MySQL date/time schema convert
was not run when there was no default value
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
