================================================================== SQLBENCH REGRESSION REPORT ================================================================== MACHINE: orisndriz05 RUN DATE: 2009-10-05T00:53:23.572774 VERSION: staging REVISION: 1164 COMMENT: 1164: Brian Aker 2009-10-04 Small cleanup. ================================================================== staging-1164 alter_table_add 14.00 0.01 0.00 0.01 staging-1164 alter_table_drop 16.00 0.00 0.01 0.01 staging-1164 connect 2.00 1.02 0.34 1.36 staging-1164 connect+select_1_row 2.00 1.02 0.68 1.70 staging-1164 connect+select_simple 2.00 1.24 0.51 1.75 staging-1164 count 16.00 0.01 0.01 0.02 staging-1164 count_distinct 5.00 0.14 0.03 0.17 staging-1164 count_distinct_2 11.00 0.19 0.02 0.21 staging-1164 count_distinct_big 21.00 4.55 0.02 4.57 staging-1164 count_distinct_group 14.00 0.59 0.08 0.67 staging-1164 count_distinct_group_on_key 8.00 0.17 0.03 0.20 staging-1164 count_distinct_group_on_key_parts 13.00 0.64 0.06 0.70 staging-1164 count_distinct_key_prefix 5.00 0.20 0.04 0.24 staging-1164 count_group_on_key_parts 8.00 0.49 0.01 0.50 staging-1164 count_on_key 81.00 5.86 0.87 6.73 staging-1164 create+drop 20.00 1.55 0.53 2.08 staging-1164 create_index 2.00 0.00 0.00 0.00 staging-1164 create_key+drop 22.00 1.93 0.51 2.44 staging-1164 create_MANY_tables 18.00 0.91 0.41 1.32 staging-1164 create_table 0.00 0.01 0.01 0.02 staging-1164 delete_all_many_keys 999.99 0.01 0.00 0.01 staging-1164 delete_autocommit 2.00 0.27 0.19 0.46 staging-1164 delete_big 0.00 0.00 0.00 0.00 staging-1164 delete_big_many_keys 999.99 0.01 0.00 0.01 staging-1164 delete_commit 2.00 0.24 0.22 0.46 staging-1164 delete_key 2.00 0.20 0.23 0.43 staging-1164 delete_range 9.00 0.00 0.00 0.00 staging-1164 delete_rollback 1.00 0.18 0.11 0.29 staging-1164 drop_index 2.00 0.01 0.00 0.01 staging-1164 drop_table 0.00 0.00 0.00 0.00 staging-1164 drop_table_when_MANY_tables 17.00 0.51 0.21 0.72 staging-1164 insert 94.00 7.33 5.95 13.28 staging-1164 insert_autocommit 2.00 0.41 0.20 0.61 staging-1164 insert_commit 2.00 0.27 0.22 0.49 staging-1164 insert_duplicates 14.00 2.97 1.99 4.96 staging-1164 insert_key 528.00 5.53 2.35 7.88 staging-1164 insert_many_fields 4.00 0.17 0.05 0.22 staging-1164 insert_rollback 1.00 0.26 0.21 0.47 staging-1164 insert_select_1_key 4.00 0.00 0.00 0.00 staging-1164 insert_select_2_keys 6.00 0.01 0.00 0.01 staging-1164 min_max 8.00 0.01 0.01 0.02 staging-1164 min_max_on_key 16.00 7.95 1.54 9.49 staging-1164 multiple_value_insert 3.00 0.22 0.00 0.22 staging-1164 once_prepared_select 20.00 4.75 3.22 7.97 staging-1164 order_by_big 14.00 10.30 0.08 10.38 staging-1164 order_by_big_key 13.00 11.50 0.16 11.66 staging-1164 order_by_big_key2 11.00 10.22 0.06 10.28 staging-1164 order_by_big_key_desc 13.00 11.39 0.14 11.53 staging-1164 order_by_big_key_diff 12.00 10.14 0.09 10.23 staging-1164 order_by_big_key_prefix 13.00 10.30 0.06 10.36 staging-1164 order_by_key2_diff 2.00 1.01 0.02 1.03 staging-1164 order_by_key_prefix 0.00 0.53 0.00 0.53 staging-1164 order_by_range 1.00 0.53 0.02 0.55 staging-1164 outer_join 21.00 0.00 0.00 0.00 staging-1164 outer_join_found 20.00 0.01 0.00 0.01 staging-1164 outer_join_not_found 19.00 0.00 0.00 0.00 staging-1164 outer_join_on_key 11.00 0.00 0.00 0.00 staging-1164 prepared_select 25.00 10.30 2.74 13.04 staging-1164 select_1_row 2.00 0.63 0.32 0.95 staging-1164 select_1_row_cache 3.00 0.67 0.38 1.05 staging-1164 select_2_rows 2.00 0.47 0.33 0.80 staging-1164 select_big 12.00 10.44 0.16 10.60 staging-1164 select_big_str 1.00 0.43 0.12 0.55 staging-1164 select_cache 53.00 0.82 0.13 0.95 staging-1164 select_cache2 54.00 1.00 0.18 1.18 staging-1164 select_column+column 3.00 0.42 0.31 0.73 staging-1164 select_diff_key 0.00 0.07 0.02 0.09 staging-1164 select_distinct 4.00 0.95 0.05 1.00 staging-1164 select_group 19.00 0.74 0.05 0.79 staging-1164 select_group_when_MANY_tables 10.00 0.32 0.18 0.50 staging-1164 select_join 0.00 0.27 0.00 0.27 staging-1164 select_key 44.00 23.68 2.92 26.60 staging-1164 select_key2 51.00 22.04 3.18 25.22 staging-1164 select_key2_return_key 47.00 22.20 3.32 25.52 staging-1164 select_key2_return_prim 51.00 27.05 2.69 29.74 staging-1164 select_key_prefix 53.00 26.33 4.80 31.13 staging-1164 select_key_prefix_join 5.00 2.23 0.00 2.23 staging-1164 select_key_return_key 45.00 22.99 3.48 26.47 staging-1164 select_many_fields 17.00 9.76 0.11 9.87 staging-1164 select_range 50.00 4.65 0.23 4.88 staging-1164 select_range_key2 7.00 2.75 0.24 2.99 staging-1164 select_range_prefix 8.00 2.77 0.30 3.07 staging-1164 select_simple 2.00 0.33 0.36 0.69 staging-1164 select_simple_cache 1.00 0.44 0.33 0.77 staging-1164 select_simple_join 1.00 0.32 0.01 0.33 staging-1164 TOTALS 999.99 330.53 57.85 388.38 staging-1164 update_autocommit 2.00 0.36 0.22 0.58 staging-1164 update_big 46.00 0.00 0.00 0.00 staging-1164 update_commit 2.00 0.26 0.17 0.43 staging-1164 update_of_key 30.00 1.31 0.91 2.22 staging-1164 update_of_key_big 37.00 0.03 0.02 0.05 staging-1164 update_of_primary_key_many_keys 999.99 0.02 0.01 0.03 staging-1164 update_rollback 2.00 0.32 0.09 0.41 staging-1164 update_with_key 92.00 8.45 5.83 14.28 staging-1164 update_with_key_prefix 36.00 5.15 2.02 7.17 staging-1164 wisc_benchmark 3.00 1.79 0.14 1.93 ==================================================================
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
