================================================================== SQLBENCH REGRESSION REPORT ================================================================== MACHINE: orisndriz05 RUN DATE: 2009-10-11T21:23:32.154043 VERSION: staging REVISION: 1178 COMMENT: 1178: Brian Aker 2009-10-09 [merge] Merge Diego ================================================================== staging-1176 alter_table_add 13.00 0.03 0.01 0.04 staging-1178 alter_table_add 17.00 0.02 0.02 0.04 staging-1176 alter_table_drop 15.00 0.01 0.01 0.02 staging-1178 alter_table_drop 17.00 0.02 0.00 0.02 staging-1176 connect 2.00 0.97 0.33 1.30 staging-1178 connect 2.00 0.88 0.38 1.26 staging-1176 connect+select_1_row 2.00 0.92 0.68 1.60 staging-1178 connect+select_1_row 2.00 1.14 0.57 1.71 staging-1176 connect+select_simple 2.00 1.01 0.70 1.71 staging-1178 connect+select_simple 2.00 0.97 0.69 1.66 staging-1176 count 17.00 0.03 0.01 0.04 staging-1178 count 20.00 0.03 0.00 0.03 staging-1176 count_distinct 6.00 0.12 0.01 0.13 staging-1178 count_distinct 5.00 0.09 0.03 0.12 staging-1176 count_distinct_2 11.00 0.30 0.05 0.35 staging-1178 count_distinct_2 14.00 0.26 0.07 0.33 staging-1176 count_distinct_big 21.00 4.42 0.04 4.46 staging-1178 count_distinct_big 24.00 4.40 0.01 4.41 staging-1176 count_distinct_group 13.00 0.53 0.07 0.60 staging-1178 count_distinct_group 13.00 0.75 0.05 0.80 staging-1176 count_distinct_group_on_key 9.00 0.14 0.03 0.17 staging-1178 count_distinct_group_on_key 10.00 0.27 0.03 0.30 staging-1176 count_distinct_group_on_key_parts 13.00 0.55 0.02 0.57 staging-1178 count_distinct_group_on_key_parts 13.00 0.30 0.06 0.36 staging-1176 count_distinct_key_prefix 4.00 0.24 0.04 0.28 staging-1178 count_distinct_key_prefix 5.00 0.08 0.03 0.11 staging-1176 count_group_on_key_parts 8.00 0.92 0.06 0.98 staging-1178 count_group_on_key_parts 9.00 0.18 0.01 0.19 staging-1176 count_on_key 76.00 5.62 0.91 6.53 staging-1178 count_on_key 79.00 5.90 0.97 6.87 staging-1176 create+drop 19.00 1.10 0.62 1.72 staging-1178 create+drop 20.00 1.16 0.61 1.77 staging-1176 create_index 3.00 0.00 0.00 0.00 staging-1178 create_index 3.00 0.00 0.00 0.00 staging-1176 create_key+drop 25.00 1.55 0.69 2.24 staging-1178 create_key+drop 24.00 1.58 0.62 2.20 staging-1176 create_MANY_tables 18.00 1.07 0.39 1.46 staging-1178 create_MANY_tables 18.00 1.06 0.42 1.48 staging-1176 create_table 0.00 0.01 0.00 0.01 staging-1178 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-1178 delete_all_many_keys 999.99 0.00 0.00 0.00 staging-1176 delete_autocommit 3.00 0.34 0.18 0.52 staging-1178 delete_autocommit 2.00 0.37 0.25 0.62 staging-1176 delete_big 0.00 0.00 0.00 0.00 staging-1178 delete_big 1.00 0.00 0.00 0.00 staging-1176 delete_big_many_keys 999.99 0.01 0.00 0.01 staging-1178 delete_big_many_keys 999.99 0.00 0.00 0.00 staging-1176 delete_commit 1.00 0.17 0.13 0.30 staging-1178 delete_commit 2.00 0.27 0.16 0.43 staging-1176 delete_key 2.00 0.20 0.22 0.42 staging-1178 delete_key 3.00 0.21 0.19 0.40 staging-1176 delete_range 8.00 0.00 0.00 0.00 staging-1178 delete_range 10.00 0.00 0.00 0.00 staging-1176 delete_rollback 1.00 0.24 0.16 0.40 staging-1178 delete_rollback 1.00 0.23 0.09 0.32 staging-1176 drop_index 2.00 0.00 0.00 0.00 staging-1178 drop_index 4.00 0.00 0.00 0.00 staging-1176 drop_table 0.00 0.00 0.00 0.00 staging-1178 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-1178 drop_table_when_MANY_tables 15.00 0.55 0.12 0.67 staging-1176 insert 94.00 8.02 6.10 14.12 staging-1178 insert 92.00 7.48 6.60 14.08 staging-1176 insert_autocommit 2.00 0.32 0.24 0.56 staging-1178 insert_autocommit 3.00 0.40 0.22 0.62 staging-1176 insert_commit 2.00 0.33 0.13 0.46 staging-1178 insert_commit 1.00 0.32 0.17 0.49 staging-1176 insert_duplicates 15.00 3.10 1.79 4.89 staging-1178 insert_duplicates 15.00 3.17 1.79 4.96 staging-1176 insert_key 531.00 5.63 2.34 7.97 staging-1178 insert_key 546.00 5.84 2.03 7.87 staging-1176 insert_many_fields 4.00 0.14 0.08 0.22 staging-1178 insert_many_fields 4.00 0.17 0.04 0.21 staging-1176 insert_rollback 1.00 0.30 0.23 0.53 staging-1178 insert_rollback 1.00 0.21 0.18 0.39 staging-1176 insert_select_1_key 5.00 0.00 0.00 0.00 staging-1178 insert_select_1_key 4.00 0.00 0.00 0.00 staging-1176 insert_select_2_keys 6.00 0.00 0.00 0.00 staging-1178 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-1178 min_max 10.00 0.00 0.02 0.02 staging-1176 min_max_on_key 18.00 9.80 1.52 11.32 staging-1178 min_max_on_key 17.00 8.15 1.45 9.60 staging-1176 multiple_value_insert 4.00 0.15 0.00 0.15 staging-1178 multiple_value_insert 4.00 0.13 0.01 0.14 staging-1176 once_prepared_select 20.00 5.38 3.19 8.57 staging-1178 once_prepared_select 21.00 4.99 3.27 8.26 staging-1176 order_by_big 14.00 9.66 0.07 9.73 staging-1178 order_by_big 16.00 12.10 0.04 12.14 staging-1176 order_by_big_key 12.00 10.93 0.16 11.09 staging-1178 order_by_big_key 14.00 13.33 0.10 13.43 staging-1176 order_by_big_key2 11.00 9.47 0.06 9.53 staging-1178 order_by_big_key2 12.00 11.93 0.10 12.03 staging-1176 order_by_big_key_desc 13.00 10.97 0.26 11.23 staging-1178 order_by_big_key_desc 15.00 13.26 0.16 13.42 staging-1176 order_by_big_key_diff 10.00 9.59 0.02 9.61 staging-1178 order_by_big_key_diff 13.00 11.72 0.07 11.79 staging-1176 order_by_big_key_prefix 12.00 9.91 0.08 9.99 staging-1178 order_by_big_key_prefix 14.00 12.13 0.10 12.23 staging-1176 order_by_key2_diff 2.00 1.08 0.02 1.10 staging-1178 order_by_key2_diff 1.00 0.84 0.01 0.85 staging-1176 order_by_key_prefix 0.00 0.59 0.00 0.59 staging-1178 order_by_key_prefix 1.00 0.46 0.02 0.48 staging-1176 order_by_range 1.00 0.54 0.02 0.56 staging-1178 order_by_range 0.00 0.49 0.00 0.49 staging-1176 outer_join 26.00 0.00 0.01 0.01 staging-1178 outer_join 27.00 0.00 0.00 0.00 staging-1176 outer_join_found 27.00 0.01 0.00 0.01 staging-1178 outer_join_found 26.00 0.00 0.00 0.00 staging-1176 outer_join_not_found 24.00 0.01 0.00 0.01 staging-1178 outer_join_not_found 23.00 0.00 0.00 0.00 staging-1176 outer_join_on_key 15.00 0.00 0.00 0.00 staging-1178 outer_join_on_key 14.00 0.00 0.00 0.00 staging-1176 prepared_select 26.00 11.03 2.54 13.57 staging-1178 prepared_select 24.00 11.01 2.87 13.88 staging-1176 select_1_row 2.00 0.46 0.29 0.75 staging-1178 select_1_row 3.00 0.53 0.31 0.84 staging-1176 select_1_row_cache 3.00 0.62 0.32 0.94 staging-1178 select_1_row_cache 2.00 0.51 0.34 0.85 staging-1176 select_2_rows 2.00 0.58 0.32 0.90 staging-1178 select_2_rows 2.00 0.64 0.36 1.00 staging-1176 select_big 11.00 9.84 0.20 10.04 staging-1178 select_big 13.00 11.94 0.22 12.16 staging-1176 select_big_str 1.00 0.46 0.07 0.53 staging-1178 select_big_str 2.00 0.36 0.10 0.46 staging-1176 select_cache 68.00 1.32 0.27 1.59 staging-1178 select_cache 52.00 0.84 0.15 0.99 staging-1176 select_cache2 58.00 1.27 0.23 1.50 staging-1178 select_cache2 53.00 1.04 0.14 1.18 staging-1176 select_column+column 2.00 0.38 0.36 0.74 staging-1178 select_column+column 2.00 0.36 0.40 0.76 staging-1176 select_diff_key 0.00 0.07 0.01 0.08 staging-1178 select_diff_key 0.00 0.04 0.02 0.06 staging-1176 select_distinct 3.00 1.11 0.03 1.14 staging-1178 select_distinct 4.00 0.88 0.01 0.89 staging-1176 select_group 18.00 0.64 0.08 0.72 staging-1178 select_group 15.00 0.62 0.03 0.65 staging-1176 select_group_when_MANY_tables 7.00 0.30 0.12 0.42 staging-1178 select_group_when_MANY_tables 8.00 0.38 0.20 0.58 staging-1176 select_join 0.00 0.27 0.00 0.27 staging-1178 select_join 1.00 0.28 0.00 0.28 staging-1176 select_key 47.00 26.16 3.41 29.57 staging-1178 select_key 45.00 21.89 3.85 25.74 staging-1176 select_key2 48.00 21.70 3.34 25.04 staging-1178 select_key2 49.00 22.02 3.23 25.25 staging-1176 select_key2_return_key 46.00 19.57 3.62 23.19 staging-1178 select_key2_return_key 52.00 25.00 3.60 28.60 staging-1176 select_key2_return_prim 43.00 19.49 3.04 22.53 staging-1178 select_key2_return_prim 50.00 23.79 2.89 26.68 staging-1176 select_key_prefix 49.00 23.42 3.08 26.50 staging-1178 select_key_prefix 47.00 22.34 3.20 25.54 staging-1176 select_key_prefix_join 5.00 2.43 0.03 2.46 staging-1178 select_key_prefix_join 4.00 2.41 0.00 2.41 staging-1176 select_key_return_key 49.00 26.69 3.94 30.63 staging-1178 select_key_return_key 42.00 21.76 3.43 25.19 staging-1176 select_many_fields 16.00 9.26 0.12 9.38 staging-1178 select_many_fields 17.00 9.61 0.19 9.80 staging-1176 select_range 48.00 4.70 0.32 5.02 staging-1178 select_range 48.00 4.84 0.30 5.14 staging-1176 select_range_key2 7.00 2.38 0.23 2.61 staging-1178 select_range_key2 8.00 2.80 0.22 3.02 staging-1176 select_range_prefix 8.00 2.64 0.30 2.94 staging-1178 select_range_prefix 7.00 2.63 0.18 2.81 staging-1176 select_simple 1.00 0.38 0.37 0.75 staging-1178 select_simple 2.00 0.38 0.37 0.75 staging-1176 select_simple_cache 2.00 0.37 0.34 0.71 staging-1178 select_simple_cache 1.00 0.33 0.27 0.60 staging-1176 select_simple_join 1.00 0.36 0.02 0.38 staging-1178 select_simple_join 0.00 0.35 0.00 0.35 staging-1176 TOTALS 999.99 322.46 58.39 380.85 staging-1178 TOTALS 999.99 336.20 58.23 394.43 staging-1176 update_autocommit 3.00 0.27 0.27 0.54 staging-1178 update_autocommit 3.00 0.27 0.21 0.48 staging-1176 update_big 45.00 0.00 0.00 0.00 staging-1178 update_big 53.00 0.00 0.00 0.00 staging-1176 update_commit 1.00 0.25 0.16 0.41 staging-1178 update_commit 1.00 0.29 0.19 0.48 staging-1176 update_of_key 30.00 1.83 0.98 2.81 staging-1178 update_of_key 31.00 1.68 0.89 2.57 staging-1176 update_of_key_big 36.00 0.00 0.02 0.02 staging-1178 update_of_key_big 45.00 0.01 0.00 0.01 staging-1176 update_of_primary_key_many_keys 999.99 0.01 0.01 0.02 staging-1178 update_of_primary_key_many_keys 999.99 0.00 0.00 0.00 staging-1176 update_rollback 2.00 0.20 0.20 0.40 staging-1178 update_rollback 2.00 0.22 0.14 0.36 staging-1176 update_with_key 93.00 8.04 5.93 13.97 staging-1178 update_with_key 91.00 9.13 6.13 15.26 staging-1176 update_with_key_prefix 36.00 5.26 1.82 7.08 staging-1178 update_with_key_prefix 36.00 5.35 1.91 7.26 staging-1176 wisc_benchmark 2.00 1.78 0.12 1.90 staging-1178 wisc_benchmark 2.00 1.82 0.12 1.94 ================================================================== FULL REVISION COMMENTARY:
1124.2.16: Diego Medina 2009-10-05 uncommented a call to reset_diagnostics... 1124.2.15: Diego Medina 2009-10-05 [merge] resolved small merge issue 1124.2.14: Diego Medina 2009-10-04 * On certain UPDATE and DELETE statemen... _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
