======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 973 RUN DATE: 2011-03-24T03:30:07.837370 SERVER: drizzled VERSION: elliott-staging REVISION: 2240 COMMENT: 2240: Brian Aker 2011-03-23 [merge] Fix for replication use of proto, and bad use of =.
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 31.00 -39.33% -8.75 13.00 32.00 22.25 9.26 innodb alter_table_drop 23.00 -19.48% -3.75 15.00 24.00 19.25 4.26 innodb connect 3.00 -50.00% -1.00 1.00 3.00 2.00 0.71 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 +11.11% 0.25 2.00 3.00 2.25 0.43 innodb count 14.00 +9.68% 1.50 13.00 18.00 15.50 2.06 innodb count_distinct 7.00 -12.00% -0.75 6.00 7.00 6.25 0.43 innodb count_distinct_2 12.00 -4.35% -0.50 11.00 12.00 11.50 0.50 innodb count_distinct_big 21.00 +5.62% 1.25 20.00 25.00 22.25 1.92 innodb count_distinct_group 14.00 -9.80% -1.25 11.00 15.00 12.75 1.79 innodb count_distinct_group_on_key 9.00 -2.86% -0.25 8.00 9.00 8.75 0.43 innodb count_distinct_group_on_key_parts 14.00 -21.74% -2.50 10.00 14.00 11.50 1.50 innodb count_distinct_key_prefix 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb count_group_on_key_parts 11.00 -2.33% -0.25 10.00 12.00 10.75 0.83 innodb count_on_key 95.00 -5.26% -4.75 85.00 96.00 90.25 5.26 innodb create+drop 34.00 -11.48% -3.50 24.00 34.00 30.50 3.91 innodb create_index 3.00 -0.00% 0.00 2.00 4.00 3.00 0.71 innodb create_key+drop 30.00 -5.26% -1.50 26.00 31.00 28.50 2.06 innodb create_MANY_tables 21.00 +8.70% 2.00 21.00 28.00 23.00 2.92 innodb delete_all_many_keys 650.00 -46.98% -207.75 220.00 650.00 442.25 203.25 innodb delete_autocommit 3.00 +14.29% 0.50 3.00 4.00 3.50 0.50 innodb delete_big 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb delete_big_many_keys 649.00 -47.00% -207.50 220.00 649.00 441.50 202.98 innodb delete_commit 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb delete_key 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb delete_range 8.00 -14.29% -1.00 6.00 8.00 7.00 1.00 innodb delete_rollback 3.00 -50.00% -1.00 1.00 3.00 2.00 0.71 innodb drop_index 3.00 -20.00% -0.50 2.00 3.00 2.50 0.50 innodb drop_table_when_MANY_tables 18.00 -7.46% -1.25 14.00 19.00 16.75 1.92 innodb insert 113.00 -1.57% -1.75 106.00 116.00 111.25 3.70 innodb insert_autocommit 3.00 +7.69% 0.25 3.00 4.00 3.25 0.43 innodb insert_commit 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb insert_duplicates 19.00 -16.92% -2.75 13.00 19.00 16.25 2.77 innodb insert_key 275.00 -22.91% -51.25 162.00 276.00 223.75 52.23 innodb insert_many_fields 6.00 -4.35% -0.25 5.00 6.00 5.75 0.43 innodb insert_rollback 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb insert_select_1_key 4.00 -6.67% -0.25 3.00 5.00 3.75 0.83 innodb insert_select_2_keys 6.00 -20.00% -1.00 4.00 6.00 5.00 0.71 innodb min_max 7.00 +9.68% 0.75 7.00 9.00 7.75 0.83 innodb min_max_on_key 25.00 -12.36% -2.75 19.00 25.00 22.25 2.77 innodb multiple_value_insert 6.00 -41.18% -1.75 3.00 6.00 4.25 1.30 innodb once_prepared_select 29.00 -10.48% -2.75 22.00 29.00 26.25 2.68 innodb order_by_big 13.00 -1.96% -0.25 12.00 13.00 12.75 0.43 innodb order_by_big_key 13.00 -6.12% -0.75 12.00 13.00 12.25 0.43 innodb order_by_big_key2 12.00 -6.67% -0.75 11.00 12.00 11.25 0.43 innodb order_by_big_key_desc 15.00 -11.11% -1.50 12.00 15.00 13.50 1.12 innodb order_by_big_key_diff 12.00 -6.67% -0.75 10.00 12.00 11.25 0.83 innodb order_by_big_key_prefix 13.00 -8.33% -1.00 11.00 13.00 12.00 0.71 innodb order_by_key2_diff 1.00 +20.00% 0.25 1.00 2.00 1.25 0.43 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 25.00 -29.87% -5.75 15.00 25.00 19.25 3.63 innodb outer_join_found 23.00 -21.05% -4.00 16.00 23.00 19.00 2.55 innodb outer_join_not_found 21.00 -23.53% -4.00 14.00 21.00 17.00 2.55 innodb outer_join_on_key 16.00 -18.52% -2.50 12.00 16.00 13.50 1.50 innodb prepared_select 38.00 -12.59% -4.25 27.00 38.00 33.75 4.32 innodb select_1_row 4.00 -23.08% -0.75 2.00 4.00 3.25 0.83 innodb select_1_row_cache 3.00 -0.00% 0.00 2.00 4.00 3.00 0.71 innodb select_2_rows 4.00 -33.33% -1.00 2.00 4.00 3.00 0.71 innodb select_big 12.00 -0.00% 0.00 11.00 14.00 12.00 1.22 innodb select_big_str 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb select_cache 63.00 -7.23% -4.25 53.00 66.00 58.75 5.85 innodb select_cache2 63.00 -5.00% -3.00 52.00 71.00 60.00 7.58 innodb select_column+column 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb select_diff_key 1.00 -300.00% -0.75 0.00 1.00 0.25 0.43 innodb select_distinct 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb select_group 15.00 +13.04% 2.25 15.00 18.00 17.25 1.30 innodb select_group_when_MANY_tables 11.00 -41.94% -3.25 4.00 11.00 7.75 3.27 innodb select_join 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb select_key 65.00 -12.55% -7.25 51.00 65.00 57.75 6.76 innodb select_key2 72.00 -9.09% -6.00 55.00 72.00 66.00 6.75 innodb select_key2_return_key 70.00 -11.11% -7.00 54.00 70.00 63.00 6.40 innodb select_key2_return_prim 70.00 -8.95% -5.75 55.00 70.00 64.25 5.97 innodb select_key_prefix 71.00 -12.70% -8.00 55.00 71.00 63.00 7.52 innodb select_key_prefix_join 5.00 -11.11% -0.50 4.00 5.00 4.50 0.50 innodb select_key_return_key 64.00 -13.78% -7.75 49.00 64.00 56.25 6.80 innodb select_many_fields 13.00 +10.34% 1.50 13.00 17.00 14.50 1.66 innodb select_range 46.00 -1.66% -0.75 45.00 46.00 45.25 0.43 innodb select_range_key2 10.00 -11.11% -1.00 8.00 10.00 9.00 1.00 innodb select_range_prefix 10.00 -17.65% -1.50 7.00 10.00 8.50 1.12 innodb select_simple 2.00 -0.00% 0.00 1.00 3.00 2.00 0.71 innodb select_simple_cache 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb select_simple_join 0.00 +100.00% 0.50 0.00 1.00 0.50 0.50 innodb update_autocommit 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb update_big 59.00 -24.21% -11.50 35.00 60.00 47.50 12.01 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 22.00 +2.22% 0.50 21.00 24.00 22.50 1.12 innodb update_of_key_big 36.00 -38.46% -10.00 18.00 36.00 26.00 7.35 innodb update_of_primary_key_many_keys 1337.00 -28.22% -294.25 699.00 1337.00 1042.75 288.30 innodb update_rollback 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb update_with_key 125.00 -8.70% -10.00 107.00 125.00 115.00 7.71 innodb update_with_key_prefix 47.00 -12.57% -5.25 36.00 47.00 41.75 4.44 innodb wisc_benchmark 2.00 +11.11% 0.25 2.00 3.00 2.25 0.43 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 31.00 -39.33% -8.75 13.00 32.00 22.25 9.26 innodb alter_table_drop 23.00 -19.48% -3.75 15.00 24.00 19.25 4.26 innodb connect 3.00 -50.00% -1.00 1.00 3.00 2.00 0.71 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 +11.11% 0.25 2.00 3.00 2.25 0.43 innodb count 14.00 +9.68% 1.50 13.00 18.00 15.50 2.06 innodb count_distinct 7.00 -12.00% -0.75 6.00 7.00 6.25 0.43 innodb count_distinct_2 12.00 -4.35% -0.50 11.00 12.00 11.50 0.50 innodb count_distinct_big 21.00 +5.62% 1.25 20.00 25.00 22.25 1.92 innodb count_distinct_group 14.00 -9.80% -1.25 11.00 15.00 12.75 1.79 innodb count_distinct_group_on_key 9.00 -2.86% -0.25 8.00 9.00 8.75 0.43 innodb count_distinct_group_on_key_parts 14.00 -21.74% -2.50 10.00 14.00 11.50 1.50 innodb count_distinct_key_prefix 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb count_group_on_key_parts 11.00 -2.33% -0.25 10.00 12.00 10.75 0.83 innodb count_on_key 95.00 -5.26% -4.75 85.00 96.00 90.25 5.26 innodb create+drop 34.00 -11.48% -3.50 24.00 34.00 30.50 3.91 innodb create_index 3.00 -0.00% 0.00 2.00 4.00 3.00 0.71 innodb create_key+drop 30.00 -5.26% -1.50 26.00 31.00 28.50 2.06 innodb create_MANY_tables 21.00 +8.70% 2.00 21.00 28.00 23.00 2.92 innodb delete_all_many_keys 650.00 -46.98% -207.75 220.00 650.00 442.25 203.25 innodb delete_autocommit 3.00 +14.29% 0.50 3.00 4.00 3.50 0.50 innodb delete_big 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb delete_big_many_keys 649.00 -47.00% -207.50 220.00 649.00 441.50 202.98 innodb delete_commit 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb delete_key 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb delete_range 8.00 -14.29% -1.00 6.00 8.00 7.00 1.00 innodb delete_rollback 3.00 -50.00% -1.00 1.00 3.00 2.00 0.71 innodb drop_index 3.00 -20.00% -0.50 2.00 3.00 2.50 0.50 innodb drop_table_when_MANY_tables 18.00 -7.46% -1.25 14.00 19.00 16.75 1.92 innodb insert 113.00 -1.57% -1.75 106.00 116.00 111.25 3.70 innodb insert_autocommit 3.00 +7.69% 0.25 3.00 4.00 3.25 0.43 innodb insert_commit 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb insert_duplicates 19.00 -16.92% -2.75 13.00 19.00 16.25 2.77 innodb insert_key 275.00 -22.91% -51.25 162.00 276.00 223.75 52.23 innodb insert_many_fields 6.00 -4.35% -0.25 5.00 6.00 5.75 0.43 innodb insert_rollback 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb insert_select_1_key 4.00 -6.67% -0.25 3.00 5.00 3.75 0.83 innodb insert_select_2_keys 6.00 -20.00% -1.00 4.00 6.00 5.00 0.71 innodb min_max 7.00 +9.68% 0.75 7.00 9.00 7.75 0.83 innodb min_max_on_key 25.00 -12.36% -2.75 19.00 25.00 22.25 2.77 innodb multiple_value_insert 6.00 -41.18% -1.75 3.00 6.00 4.25 1.30 innodb once_prepared_select 29.00 -10.48% -2.75 22.00 29.00 26.25 2.68 innodb order_by_big 13.00 -1.96% -0.25 12.00 13.00 12.75 0.43 innodb order_by_big_key 13.00 -6.12% -0.75 12.00 13.00 12.25 0.43 innodb order_by_big_key2 12.00 -6.67% -0.75 11.00 12.00 11.25 0.43 innodb order_by_big_key_desc 15.00 -11.11% -1.50 12.00 15.00 13.50 1.12 innodb order_by_big_key_diff 12.00 -6.67% -0.75 10.00 12.00 11.25 0.83 innodb order_by_big_key_prefix 13.00 -8.33% -1.00 11.00 13.00 12.00 0.71 innodb order_by_key2_diff 1.00 +20.00% 0.25 1.00 2.00 1.25 0.43 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 25.00 -29.87% -5.75 15.00 25.00 19.25 3.63 innodb outer_join_found 23.00 -21.05% -4.00 16.00 23.00 19.00 2.55 innodb outer_join_not_found 21.00 -23.53% -4.00 14.00 21.00 17.00 2.55 innodb outer_join_on_key 16.00 -18.52% -2.50 12.00 16.00 13.50 1.50 innodb prepared_select 38.00 -12.59% -4.25 27.00 38.00 33.75 4.32 innodb select_1_row 4.00 -23.08% -0.75 2.00 4.00 3.25 0.83 innodb select_1_row_cache 3.00 -0.00% 0.00 2.00 4.00 3.00 0.71 innodb select_2_rows 4.00 -33.33% -1.00 2.00 4.00 3.00 0.71 innodb select_big 12.00 -0.00% 0.00 11.00 14.00 12.00 1.22 innodb select_big_str 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb select_cache 63.00 -7.23% -4.25 53.00 66.00 58.75 5.85 innodb select_cache2 63.00 -5.00% -3.00 52.00 71.00 60.00 7.58 innodb select_column+column 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb select_diff_key 1.00 -300.00% -0.75 0.00 1.00 0.25 0.43 innodb select_distinct 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb select_group 15.00 +13.04% 2.25 15.00 18.00 17.25 1.30 innodb select_group_when_MANY_tables 11.00 -41.94% -3.25 4.00 11.00 7.75 3.27 innodb select_join 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb select_key 65.00 -12.55% -7.25 51.00 65.00 57.75 6.76 innodb select_key2 72.00 -9.09% -6.00 55.00 72.00 66.00 6.75 innodb select_key2_return_key 70.00 -11.11% -7.00 54.00 70.00 63.00 6.40 innodb select_key2_return_prim 70.00 -8.95% -5.75 55.00 70.00 64.25 5.97 innodb select_key_prefix 71.00 -12.70% -8.00 55.00 71.00 63.00 7.52 innodb select_key_prefix_join 5.00 -11.11% -0.50 4.00 5.00 4.50 0.50 innodb select_key_return_key 64.00 -13.78% -7.75 49.00 64.00 56.25 6.80 innodb select_many_fields 13.00 +10.34% 1.50 13.00 17.00 14.50 1.66 innodb select_range 46.00 -1.66% -0.75 45.00 46.00 45.25 0.43 innodb select_range_key2 10.00 -11.11% -1.00 8.00 10.00 9.00 1.00 innodb select_range_prefix 10.00 -17.65% -1.50 7.00 10.00 8.50 1.12 innodb select_simple 2.00 -0.00% 0.00 1.00 3.00 2.00 0.71 innodb select_simple_cache 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb select_simple_join 0.00 +100.00% 0.50 0.00 1.00 0.50 0.50 innodb update_autocommit 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb update_big 59.00 -24.21% -11.50 35.00 60.00 47.50 12.01 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 22.00 +2.22% 0.50 21.00 24.00 22.50 1.12 innodb update_of_key_big 36.00 -38.46% -10.00 18.00 36.00 26.00 7.35 innodb update_of_primary_key_many_keys 1337.00 -28.22% -294.25 699.00 1337.00 1042.75 288.30 innodb update_rollback 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb update_with_key 125.00 -8.70% -10.00 107.00 125.00 115.00 7.71 innodb update_with_key_prefix 47.00 -12.57% -5.25 36.00 47.00 41.75 4.44 innodb wisc_benchmark 2.00 +11.11% 0.25 2.00 3.00 2.25 0.43 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 31.00 -39.33% -8.75 13.00 32.00 22.25 9.26 innodb alter_table_drop 23.00 -19.48% -3.75 15.00 24.00 19.25 4.26 innodb connect 3.00 -50.00% -1.00 1.00 3.00 2.00 0.71 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 +11.11% 0.25 2.00 3.00 2.25 0.43 innodb count 14.00 +9.68% 1.50 13.00 18.00 15.50 2.06 innodb count_distinct 7.00 -12.00% -0.75 6.00 7.00 6.25 0.43 innodb count_distinct_2 12.00 -4.35% -0.50 11.00 12.00 11.50 0.50 innodb count_distinct_big 21.00 +5.62% 1.25 20.00 25.00 22.25 1.92 innodb count_distinct_group 14.00 -9.80% -1.25 11.00 15.00 12.75 1.79 innodb count_distinct_group_on_key 9.00 -2.86% -0.25 8.00 9.00 8.75 0.43 innodb count_distinct_group_on_key_parts 14.00 -21.74% -2.50 10.00 14.00 11.50 1.50 innodb count_distinct_key_prefix 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb count_group_on_key_parts 11.00 -2.33% -0.25 10.00 12.00 10.75 0.83 innodb count_on_key 95.00 -5.26% -4.75 85.00 96.00 90.25 5.26 innodb create+drop 34.00 -11.48% -3.50 24.00 34.00 30.50 3.91 innodb create_index 3.00 -0.00% 0.00 2.00 4.00 3.00 0.71 innodb create_key+drop 30.00 -5.26% -1.50 26.00 31.00 28.50 2.06 innodb create_MANY_tables 21.00 +8.70% 2.00 21.00 28.00 23.00 2.92 innodb delete_all_many_keys 650.00 -46.98% -207.75 220.00 650.00 442.25 203.25 innodb delete_autocommit 3.00 +14.29% 0.50 3.00 4.00 3.50 0.50 innodb delete_big 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb delete_big_many_keys 649.00 -47.00% -207.50 220.00 649.00 441.50 202.98 innodb delete_commit 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb delete_key 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb delete_range 8.00 -14.29% -1.00 6.00 8.00 7.00 1.00 innodb delete_rollback 3.00 -50.00% -1.00 1.00 3.00 2.00 0.71 innodb drop_index 3.00 -20.00% -0.50 2.00 3.00 2.50 0.50 innodb drop_table_when_MANY_tables 18.00 -7.46% -1.25 14.00 19.00 16.75 1.92 innodb insert 113.00 -1.57% -1.75 106.00 116.00 111.25 3.70 innodb insert_autocommit 3.00 +7.69% 0.25 3.00 4.00 3.25 0.43 innodb insert_commit 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb insert_duplicates 19.00 -16.92% -2.75 13.00 19.00 16.25 2.77 innodb insert_key 275.00 -22.91% -51.25 162.00 276.00 223.75 52.23 innodb insert_many_fields 6.00 -4.35% -0.25 5.00 6.00 5.75 0.43 innodb insert_rollback 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb insert_select_1_key 4.00 -6.67% -0.25 3.00 5.00 3.75 0.83 innodb insert_select_2_keys 6.00 -20.00% -1.00 4.00 6.00 5.00 0.71 innodb min_max 7.00 +9.68% 0.75 7.00 9.00 7.75 0.83 innodb min_max_on_key 25.00 -12.36% -2.75 19.00 25.00 22.25 2.77 innodb multiple_value_insert 6.00 -41.18% -1.75 3.00 6.00 4.25 1.30 innodb once_prepared_select 29.00 -10.48% -2.75 22.00 29.00 26.25 2.68 innodb order_by_big 13.00 -1.96% -0.25 12.00 13.00 12.75 0.43 innodb order_by_big_key 13.00 -6.12% -0.75 12.00 13.00 12.25 0.43 innodb order_by_big_key2 12.00 -6.67% -0.75 11.00 12.00 11.25 0.43 innodb order_by_big_key_desc 15.00 -11.11% -1.50 12.00 15.00 13.50 1.12 innodb order_by_big_key_diff 12.00 -6.67% -0.75 10.00 12.00 11.25 0.83 innodb order_by_big_key_prefix 13.00 -8.33% -1.00 11.00 13.00 12.00 0.71 innodb order_by_key2_diff 1.00 +20.00% 0.25 1.00 2.00 1.25 0.43 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 25.00 -29.87% -5.75 15.00 25.00 19.25 3.63 innodb outer_join_found 23.00 -21.05% -4.00 16.00 23.00 19.00 2.55 innodb outer_join_not_found 21.00 -23.53% -4.00 14.00 21.00 17.00 2.55 innodb outer_join_on_key 16.00 -18.52% -2.50 12.00 16.00 13.50 1.50 innodb prepared_select 38.00 -12.59% -4.25 27.00 38.00 33.75 4.32 innodb select_1_row 4.00 -23.08% -0.75 2.00 4.00 3.25 0.83 innodb select_1_row_cache 3.00 -0.00% 0.00 2.00 4.00 3.00 0.71 innodb select_2_rows 4.00 -33.33% -1.00 2.00 4.00 3.00 0.71 innodb select_big 12.00 -0.00% 0.00 11.00 14.00 12.00 1.22 innodb select_big_str 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb select_cache 63.00 -7.23% -4.25 53.00 66.00 58.75 5.85 innodb select_cache2 63.00 -5.00% -3.00 52.00 71.00 60.00 7.58 innodb select_column+column 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb select_diff_key 1.00 -300.00% -0.75 0.00 1.00 0.25 0.43 innodb select_distinct 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb select_group 15.00 +13.04% 2.25 15.00 18.00 17.25 1.30 innodb select_group_when_MANY_tables 11.00 -41.94% -3.25 4.00 11.00 7.75 3.27 innodb select_join 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb select_key 65.00 -12.55% -7.25 51.00 65.00 57.75 6.76 innodb select_key2 72.00 -9.09% -6.00 55.00 72.00 66.00 6.75 innodb select_key2_return_key 70.00 -11.11% -7.00 54.00 70.00 63.00 6.40 innodb select_key2_return_prim 70.00 -8.95% -5.75 55.00 70.00 64.25 5.97 innodb select_key_prefix 71.00 -12.70% -8.00 55.00 71.00 63.00 7.52 innodb select_key_prefix_join 5.00 -11.11% -0.50 4.00 5.00 4.50 0.50 innodb select_key_return_key 64.00 -13.78% -7.75 49.00 64.00 56.25 6.80 innodb select_many_fields 13.00 +10.34% 1.50 13.00 17.00 14.50 1.66 innodb select_range 46.00 -1.66% -0.75 45.00 46.00 45.25 0.43 innodb select_range_key2 10.00 -11.11% -1.00 8.00 10.00 9.00 1.00 innodb select_range_prefix 10.00 -17.65% -1.50 7.00 10.00 8.50 1.12 innodb select_simple 2.00 -0.00% 0.00 1.00 3.00 2.00 0.71 innodb select_simple_cache 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb select_simple_join 0.00 +100.00% 0.50 0.00 1.00 0.50 0.50 innodb update_autocommit 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb update_big 59.00 -24.21% -11.50 35.00 60.00 47.50 12.01 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 22.00 +2.22% 0.50 21.00 24.00 22.50 1.12 innodb update_of_key_big 36.00 -38.46% -10.00 18.00 36.00 26.00 7.35 innodb update_of_primary_key_many_keys 1337.00 -28.22% -294.25 699.00 1337.00 1042.75 288.30 innodb update_rollback 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb update_with_key 125.00 -8.70% -10.00 107.00 125.00 115.00 7.71 innodb update_with_key_prefix 47.00 -12.57% -5.25 36.00 47.00 41.75 4.44 innodb wisc_benchmark 2.00 +11.11% 0.25 2.00 3.00 2.25 0.43 ========================================================================================================================= FULL REVISION COMMENTARY: 2239.1.2: Brian Aker 2011-03-22 Fix issue where the wrong sort of "=" could be used in some cases. 2239.1.1: Brian Aker 2011-03-22 This fix the case where we were still referring to the dead replicate option _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
