================================================================== SQLBENCH REGRESSION REPORT ================================================================== MACHINE: orisndriz05 RUN DATE: 2009-10-12T23:59:27.171622 VERSION: staging REVISION: 1182 COMMENT: 1182: Brian Aker 2009-10-12 [merge] Minor Merge ================================================================== staging-1182 alter_table_add 13.00 0.04 0.02 0.06 staging-1182 alter_table_drop 12.00 0.01 0.00 0.01 staging-1182 connect 1.00 0.87 0.53 1.40 staging-1182 connect+select_1_row 2.00 1.27 0.51 1.78 staging-1182 connect+select_simple 2.00 0.94 0.62 1.56 staging-1182 count 17.00 0.01 0.00 0.01 staging-1182 count_distinct 6.00 0.10 0.00 0.10 staging-1182 count_distinct_2 11.00 0.22 0.03 0.25 staging-1182 count_distinct_big 22.00 4.33 0.01 4.34 staging-1182 count_distinct_group 14.00 0.77 0.05 0.82 staging-1182 count_distinct_group_on_key 8.00 0.19 0.04 0.23 staging-1182 count_distinct_group_on_key_parts 13.00 0.68 0.07 0.75 staging-1182 count_distinct_key_prefix 4.00 0.17 0.01 0.18 staging-1182 count_group_on_key_parts 8.00 0.57 0.01 0.58 staging-1182 count_on_key 75.00 5.55 0.74 6.29 staging-1182 create+drop 19.00 1.50 0.48 1.98 staging-1182 create_index 2.00 0.00 0.00 0.00 staging-1182 create_key+drop 24.00 1.76 0.56 2.32 staging-1182 create_MANY_tables 20.00 1.18 0.44 1.62 staging-1182 create_table 0.00 0.00 0.00 0.00 staging-1182 delete_all_many_keys 999.99 0.01 0.01 0.02 staging-1182 delete_autocommit 3.00 0.45 0.14 0.59 staging-1182 delete_big 1.00 0.00 0.00 0.00 staging-1182 delete_big_many_keys 999.99 0.01 0.01 0.02 staging-1182 delete_commit 2.00 0.20 0.13 0.33 staging-1182 delete_key 2.00 0.18 0.21 0.39 staging-1182 delete_range 9.00 0.01 0.00 0.01 staging-1182 delete_rollback 2.00 0.19 0.12 0.31 staging-1182 drop_index 2.00 0.00 0.00 0.00 staging-1182 drop_table 0.00 0.00 0.00 0.00 staging-1182 drop_table_when_MANY_tables 17.00 0.42 0.22 0.64 staging-1182 insert 93.00 8.08 5.91 13.99 staging-1182 insert_autocommit 3.00 0.50 0.16 0.66 staging-1182 insert_commit 1.00 0.29 0.27 0.56 staging-1182 insert_duplicates 14.00 2.89 1.60 4.49 staging-1182 insert_key 517.00 5.39 2.06 7.45 staging-1182 insert_many_fields 4.00 0.12 0.03 0.15 staging-1182 insert_rollback 1.00 0.35 0.14 0.49 staging-1182 insert_select_1_key 4.00 0.00 0.00 0.00 staging-1182 insert_select_2_keys 5.00 0.00 0.00 0.00 staging-1182 min_max 9.00 0.01 0.00 0.01 staging-1182 min_max_on_key 15.00 8.57 1.19 9.76 staging-1182 multiple_value_insert 3.00 0.13 0.00 0.13 staging-1182 once_prepared_select 21.00 4.80 3.03 7.83 staging-1182 order_by_big 13.00 10.00 0.03 10.03 staging-1182 order_by_big_key 12.00 11.33 0.12 11.45 staging-1182 order_by_big_key2 11.00 9.84 0.05 9.89 staging-1182 order_by_big_key_desc 13.00 11.38 0.17 11.55 staging-1182 order_by_big_key_diff 11.00 10.01 0.11 10.12 staging-1182 order_by_big_key_prefix 12.00 10.18 0.08 10.26 staging-1182 order_by_key2_diff 1.00 0.84 0.01 0.85 staging-1182 order_by_key_prefix 0.00 0.42 0.01 0.43 staging-1182 order_by_range 1.00 0.54 0.01 0.55 staging-1182 outer_join 26.00 0.00 0.00 0.00 staging-1182 outer_join_found 26.00 0.00 0.00 0.00 staging-1182 outer_join_not_found 23.00 0.00 0.00 0.00 staging-1182 outer_join_on_key 14.00 0.00 0.00 0.00 staging-1182 prepared_select 27.00 11.10 3.53 14.63 staging-1182 select_1_row 3.00 0.48 0.28 0.76 staging-1182 select_1_row_cache 2.00 0.57 0.41 0.98 staging-1182 select_2_rows 2.00 0.57 0.25 0.82 staging-1182 select_big 12.00 10.12 0.23 10.35 staging-1182 select_big_str 1.00 0.51 0.11 0.62 staging-1182 select_cache 75.00 1.09 0.16 1.25 staging-1182 select_cache2 62.00 1.23 0.16 1.39 staging-1182 select_column+column 3.00 0.32 0.41 0.73 staging-1182 select_diff_key 0.00 0.05 0.00 0.05 staging-1182 select_distinct 3.00 0.92 0.02 0.94 staging-1182 select_group 16.00 0.64 0.04 0.68 staging-1182 select_group_when_MANY_tables 7.00 0.28 0.12 0.40 staging-1182 select_join 1.00 0.29 0.00 0.29 staging-1182 select_key 43.00 22.04 3.11 25.15 staging-1182 select_key2 50.00 24.65 3.02 27.67 staging-1182 select_key2_return_key 46.00 20.55 3.24 23.79 staging-1182 select_key2_return_prim 47.00 22.12 2.98 25.10 staging-1182 select_key_prefix 48.00 22.07 3.45 25.52 staging-1182 select_key_prefix_join 5.00 2.46 0.01 2.47 staging-1182 select_key_return_key 46.00 23.32 3.25 26.57 staging-1182 select_many_fields 17.00 8.72 0.21 8.93 staging-1182 select_range 49.00 4.66 0.18 4.84 staging-1182 select_range_key2 7.00 2.34 0.26 2.60 staging-1182 select_range_prefix 7.00 2.29 0.30 2.59 staging-1182 select_simple 2.00 0.42 0.26 0.68 staging-1182 select_simple_cache 1.00 0.28 0.19 0.47 staging-1182 select_simple_join 1.00 0.36 0.03 0.39 staging-1182 TOTALS 999.99 318.53 54.87 373.40 staging-1182 update_autocommit 2.00 0.38 0.20 0.58 staging-1182 update_big 46.00 0.00 0.00 0.00 staging-1182 update_commit 1.00 0.27 0.21 0.48 staging-1182 update_of_key 30.00 1.14 0.85 1.99 staging-1182 update_of_key_big 43.00 0.00 0.02 0.02 staging-1182 update_of_primary_key_many_keys 999.99 0.03 0.02 0.05 staging-1182 update_rollback 1.00 0.22 0.16 0.38 staging-1182 update_with_key 92.00 7.51 5.32 12.83 staging-1182 update_with_key_prefix 35.00 5.51 1.86 7.37 staging-1182 wisc_benchmark 3.00 1.72 0.08 1.80 ================================================================== FULL REVISION COMMENTARY:
1166.4.3: Diego Medina 2009-10-12 * Fixed comment format _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
