================================================================== SQLBENCH REGRESSION REPORT ================================================================== MACHINE: orisndriz05 RUN DATE: 2009-10-09T00:31:18.895573 VERSION: staging REVISION: 1176 COMMENT: 1176: Brian Aker 2009-10-08 [merge] Merge 32bit failures ================================================================== staging-1176 alter_table_add 13.00 0.03 0.01 0.04 staging-1176 alter_table_drop 15.00 0.01 0.01 0.02 staging-1176 connect 2.00 0.97 0.33 1.30 staging-1176 connect+select_1_row 2.00 0.92 0.68 1.60 staging-1176 connect+select_simple 2.00 1.01 0.70 1.71 staging-1176 count 17.00 0.03 0.01 0.04 staging-1176 count_distinct 6.00 0.12 0.01 0.13 staging-1176 count_distinct_2 11.00 0.30 0.05 0.35 staging-1176 count_distinct_big 21.00 4.42 0.04 4.46 staging-1176 count_distinct_group 13.00 0.53 0.07 0.60 staging-1176 count_distinct_group_on_key 9.00 0.14 0.03 0.17 staging-1176 count_distinct_group_on_key_parts 13.00 0.55 0.02 0.57 staging-1176 count_distinct_key_prefix 4.00 0.24 0.04 0.28 staging-1176 count_group_on_key_parts 8.00 0.92 0.06 0.98 staging-1176 count_on_key 76.00 5.62 0.91 6.53 staging-1176 create+drop 19.00 1.10 0.62 1.72 staging-1176 create_index 3.00 0.00 0.00 0.00 staging-1176 create_key+drop 25.00 1.55 0.69 2.24 staging-1176 create_MANY_tables 18.00 1.07 0.39 1.46 staging-1176 create_table 0.00 0.01 0.00 0.01 staging-1176 delete_all_many_keys 999.99 0.01 0.00 0.01 staging-1176 delete_autocommit 3.00 0.34 0.18 0.52 staging-1176 delete_big 0.00 0.00 0.00 0.00 staging-1176 delete_big_many_keys 999.99 0.01 0.00 0.01 staging-1176 delete_commit 1.00 0.17 0.13 0.30 staging-1176 delete_key 2.00 0.20 0.22 0.42 staging-1176 delete_range 8.00 0.00 0.00 0.00 staging-1176 delete_rollback 1.00 0.24 0.16 0.40 staging-1176 drop_index 2.00 0.00 0.00 0.00 staging-1176 drop_table 0.00 0.00 0.00 0.00 staging-1176 drop_table_when_MANY_tables 18.00 0.46 0.20 0.66 staging-1176 insert 94.00 8.02 6.10 14.12 staging-1176 insert_autocommit 2.00 0.32 0.24 0.56 staging-1176 insert_commit 2.00 0.33 0.13 0.46 staging-1176 insert_duplicates 15.00 3.10 1.79 4.89 staging-1176 insert_key 531.00 5.63 2.34 7.97 staging-1176 insert_many_fields 4.00 0.14 0.08 0.22 staging-1176 insert_rollback 1.00 0.30 0.23 0.53 staging-1176 insert_select_1_key 5.00 0.00 0.00 0.00 staging-1176 insert_select_2_keys 6.00 0.00 0.00 0.00 staging-1176 min_max 9.00 0.02 0.00 0.02 staging-1176 min_max_on_key 18.00 9.80 1.52 11.32 staging-1176 multiple_value_insert 4.00 0.15 0.00 0.15 staging-1176 once_prepared_select 20.00 5.38 3.19 8.57 staging-1176 order_by_big 14.00 9.66 0.07 9.73 staging-1176 order_by_big_key 12.00 10.93 0.16 11.09 staging-1176 order_by_big_key2 11.00 9.47 0.06 9.53 staging-1176 order_by_big_key_desc 13.00 10.97 0.26 11.23 staging-1176 order_by_big_key_diff 10.00 9.59 0.02 9.61 staging-1176 order_by_big_key_prefix 12.00 9.91 0.08 9.99 staging-1176 order_by_key2_diff 2.00 1.08 0.02 1.10 staging-1176 order_by_key_prefix 0.00 0.59 0.00 0.59 staging-1176 order_by_range 1.00 0.54 0.02 0.56 staging-1176 outer_join 26.00 0.00 0.01 0.01 staging-1176 outer_join_found 27.00 0.01 0.00 0.01 staging-1176 outer_join_not_found 24.00 0.01 0.00 0.01 staging-1176 outer_join_on_key 15.00 0.00 0.00 0.00 staging-1176 prepared_select 26.00 11.03 2.54 13.57 staging-1176 select_1_row 2.00 0.46 0.29 0.75 staging-1176 select_1_row_cache 3.00 0.62 0.32 0.94 staging-1176 select_2_rows 2.00 0.58 0.32 0.90 staging-1176 select_big 11.00 9.84 0.20 10.04 staging-1176 select_big_str 1.00 0.46 0.07 0.53 staging-1176 select_cache 68.00 1.32 0.27 1.59 staging-1176 select_cache2 58.00 1.27 0.23 1.50 staging-1176 select_column+column 2.00 0.38 0.36 0.74 staging-1176 select_diff_key 0.00 0.07 0.01 0.08 staging-1176 select_distinct 3.00 1.11 0.03 1.14 staging-1176 select_group 18.00 0.64 0.08 0.72 staging-1176 select_group_when_MANY_tables 7.00 0.30 0.12 0.42 staging-1176 select_join 0.00 0.27 0.00 0.27 staging-1176 select_key 47.00 26.16 3.41 29.57 staging-1176 select_key2 48.00 21.70 3.34 25.04 staging-1176 select_key2_return_key 46.00 19.57 3.62 23.19 staging-1176 select_key2_return_prim 43.00 19.49 3.04 22.53 staging-1176 select_key_prefix 49.00 23.42 3.08 26.50 staging-1176 select_key_prefix_join 5.00 2.43 0.03 2.46 staging-1176 select_key_return_key 49.00 26.69 3.94 30.63 staging-1176 select_many_fields 16.00 9.26 0.12 9.38 staging-1176 select_range 48.00 4.70 0.32 5.02 staging-1176 select_range_key2 7.00 2.38 0.23 2.61 staging-1176 select_range_prefix 8.00 2.64 0.30 2.94 staging-1176 select_simple 1.00 0.38 0.37 0.75 staging-1176 select_simple_cache 2.00 0.37 0.34 0.71 staging-1176 select_simple_join 1.00 0.36 0.02 0.38 staging-1176 TOTALS 999.99 322.46 58.39 380.85 staging-1176 update_autocommit 3.00 0.27 0.27 0.54 staging-1176 update_big 45.00 0.00 0.00 0.00 staging-1176 update_commit 1.00 0.25 0.16 0.41 staging-1176 update_of_key 30.00 1.83 0.98 2.81 staging-1176 update_of_key_big 36.00 0.00 0.02 0.02 staging-1176 update_of_primary_key_many_keys 999.99 0.01 0.01 0.02 staging-1176 update_rollback 2.00 0.20 0.20 0.40 staging-1176 update_with_key 93.00 8.04 5.93 13.97 staging-1176 update_with_key_prefix 36.00 5.26 1.82 7.08 staging-1176 wisc_benchmark 2.00 1.78 0.12 1.90 ================================================================== FULL REVISION COMMENTARY:
1175.1.1: Jay Pipes 2009-10-08 Fix build failures on solaris and PPC for b... _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
