================================================================== SQLBENCH REGRESSION REPORT ================================================================== MACHINE: orisndriz05 RUN ID: 60 RUN DATE: 2009-10-20T00:28:25.061409 VERSION: staging REVISION: 1188 COMMENT: 1188: Brian Aker 2009-10-18 [merge] Merge Stewart ================================================================== staging-1185 alter_table_add 25.00 0.00 0.01 0.01 staging-1188 alter_table_add 25.00 0.02 0.01 0.03 staging-1185 alter_table_drop 22.00 0.01 0.00 0.01 staging-1188 alter_table_drop 23.00 0.01 0.00 0.01 staging-1185 connect 1.00 0.96 0.50 1.46 staging-1188 connect 1.00 0.89 0.58 1.47 staging-1185 connect+select_1_row 2.00 0.90 0.64 1.54 staging-1188 connect+select_1_row 2.00 1.39 0.52 1.91 staging-1185 connect+select_simple 2.00 1.14 0.60 1.74 staging-1188 connect+select_simple 2.00 1.20 0.59 1.79 staging-1185 count 13.00 0.01 0.00 0.01 staging-1188 count 17.00 0.01 0.01 0.02 staging-1185 count_distinct 6.00 0.18 0.00 0.18 staging-1188 count_distinct 7.00 0.13 0.03 0.16 staging-1185 count_distinct_2 11.00 0.16 0.09 0.25 staging-1188 count_distinct_2 15.00 0.31 0.02 0.33 staging-1185 count_distinct_big 19.00 4.41 0.01 4.42 staging-1188 count_distinct_big 21.00 3.72 0.00 3.72 staging-1185 count_distinct_group 13.00 0.70 0.04 0.74 staging-1188 count_distinct_group 13.00 0.76 0.07 0.83 staging-1185 count_distinct_group_on_key 8.00 0.25 0.06 0.31 staging-1188 count_distinct_group_on_key 9.00 0.12 0.01 0.13 staging-1185 count_distinct_group_on_key_parts 13.00 0.55 0.04 0.59 staging-1188 count_distinct_group_on_key_parts 12.00 0.59 0.06 0.65 staging-1185 count_distinct_key_prefix 4.00 0.12 0.01 0.13 staging-1188 count_distinct_key_prefix 4.00 0.09 0.02 0.11 staging-1185 count_group_on_key_parts 8.00 0.41 0.06 0.47 staging-1188 count_group_on_key_parts 8.00 0.59 0.01 0.60 staging-1185 count_on_key 73.00 5.54 0.93 6.47 staging-1188 count_on_key 77.00 6.02 1.06 7.08 staging-1185 create+drop 20.00 1.50 0.65 2.15 staging-1188 create+drop 21.00 1.38 0.70 2.08 staging-1185 create_index 3.00 0.00 0.00 0.00 staging-1188 create_index 3.00 0.00 0.00 0.00 staging-1185 create_key+drop 23.00 1.70 0.51 2.21 staging-1188 create_key+drop 22.00 1.49 0.60 2.09 staging-1185 create_MANY_tables 18.00 1.03 0.34 1.37 staging-1188 create_MANY_tables 18.00 1.04 0.45 1.49 staging-1185 create_table 1.00 0.00 0.01 0.01 staging-1188 create_table 0.00 0.00 0.00 0.00 staging-1185 delete_all_many_keys 324.00 0.02 0.00 0.02 staging-1188 delete_all_many_keys 358.00 0.02 0.00 0.02 staging-1185 delete_autocommit 3.00 0.19 0.21 0.40 staging-1188 delete_autocommit 3.00 0.24 0.14 0.38 staging-1185 delete_big 0.00 0.00 0.00 0.00 staging-1188 delete_big 0.00 0.00 0.00 0.00 staging-1185 delete_big_many_keys 324.00 0.02 0.00 0.02 staging-1188 delete_big_many_keys 358.00 0.02 0.00 0.02 staging-1185 delete_commit 1.00 0.22 0.15 0.37 staging-1188 delete_commit 1.00 0.21 0.16 0.37 staging-1185 delete_key 2.00 0.19 0.21 0.40 staging-1188 delete_key 2.00 0.24 0.07 0.31 staging-1185 delete_range 7.00 0.00 0.00 0.00 staging-1188 delete_range 8.00 0.00 0.00 0.00 staging-1185 delete_rollback 1.00 0.23 0.16 0.39 staging-1188 delete_rollback 2.00 0.25 0.17 0.42 staging-1185 drop_index 3.00 0.00 0.00 0.00 staging-1188 drop_index 4.00 0.00 0.00 0.00 staging-1185 drop_table 0.00 0.00 0.00 0.00 staging-1188 drop_table 0.00 0.00 0.00 0.00 staging-1185 drop_table_when_MANY_tables 11.00 0.56 0.19 0.75 staging-1188 drop_table_when_MANY_tables 12.00 0.34 0.23 0.57 staging-1185 insert 94.00 8.38 6.32 14.70 staging-1188 insert 94.00 7.30 6.33 13.63 staging-1185 insert_autocommit 2.00 0.33 0.16 0.49 staging-1188 insert_autocommit 3.00 0.29 0.22 0.51 staging-1185 insert_commit 2.00 0.40 0.14 0.54 staging-1188 insert_commit 1.00 0.29 0.14 0.43 staging-1185 insert_duplicates 13.00 2.96 1.72 4.68 staging-1188 insert_duplicates 13.00 2.85 1.80 4.65 staging-1185 insert_key 319.00 3.74 1.75 5.49 staging-1188 insert_key 342.00 3.11 1.34 4.45 staging-1185 insert_many_fields 4.00 0.25 0.02 0.27 staging-1188 insert_many_fields 6.00 0.14 0.08 0.22 staging-1185 insert_rollback 1.00 0.39 0.11 0.50 staging-1188 insert_rollback 1.00 0.41 0.15 0.56 staging-1185 insert_select_1_key 5.00 0.00 0.00 0.00 staging-1188 insert_select_1_key 4.00 0.00 0.00 0.00 staging-1185 insert_select_2_keys 7.00 0.00 0.00 0.00 staging-1188 insert_select_2_keys 6.00 0.00 0.00 0.00 staging-1185 min_max 9.00 0.01 0.00 0.01 staging-1188 min_max 8.00 0.01 0.00 0.01 staging-1185 min_max_on_key 17.00 9.22 1.34 10.56 staging-1188 min_max_on_key 16.00 8.43 1.37 9.80 staging-1185 multiple_value_insert 7.00 0.19 0.01 0.20 staging-1188 multiple_value_insert 6.00 0.12 0.01 0.13 staging-1185 once_prepared_select 21.00 5.29 3.18 8.47 staging-1188 once_prepared_select 21.00 5.15 2.97 8.12 staging-1185 order_by_big 12.00 10.01 0.03 10.04 staging-1188 order_by_big 13.00 9.98 0.06 10.04 staging-1185 order_by_big_key 13.00 12.61 0.16 12.77 staging-1188 order_by_big_key 12.00 11.06 0.18 11.24 staging-1185 order_by_big_key2 10.00 9.67 0.05 9.72 staging-1188 order_by_big_key2 11.00 10.38 0.10 10.48 staging-1185 order_by_big_key_desc 12.00 10.89 0.13 11.02 staging-1188 order_by_big_key_desc 12.00 11.29 0.12 11.41 staging-1185 order_by_big_key_diff 11.00 9.72 0.06 9.78 staging-1188 order_by_big_key_diff 11.00 10.13 0.07 10.20 staging-1185 order_by_big_key_prefix 12.00 9.94 0.03 9.97 staging-1188 order_by_big_key_prefix 12.00 9.99 0.03 10.02 staging-1185 order_by_key2_diff 1.00 1.05 0.01 1.06 staging-1188 order_by_key2_diff 1.00 1.04 0.00 1.04 staging-1185 order_by_key_prefix 1.00 0.57 0.02 0.59 staging-1188 order_by_key_prefix 1.00 0.59 0.01 0.60 staging-1185 order_by_range 1.00 0.58 0.01 0.59 staging-1188 order_by_range 1.00 0.60 0.01 0.61 staging-1185 outer_join 16.00 0.00 0.00 0.00 staging-1188 outer_join 21.00 0.00 0.00 0.00 staging-1185 outer_join_found 15.00 0.01 0.00 0.01 staging-1188 outer_join_found 20.00 0.00 0.00 0.00 staging-1185 outer_join_not_found 14.00 0.02 0.00 0.02 staging-1188 outer_join_not_found 17.00 0.01 0.00 0.01 staging-1185 outer_join_on_key 11.00 0.00 0.00 0.00 staging-1188 outer_join_on_key 14.00 0.00 0.00 0.00 staging-1185 prepared_select 29.00 12.01 3.18 15.19 staging-1188 prepared_select 25.00 11.51 2.83 14.34 staging-1185 select_1_row 3.00 0.52 0.38 0.90 staging-1188 select_1_row 3.00 0.52 0.43 0.95 staging-1185 select_1_row_cache 2.00 0.36 0.32 0.68 staging-1188 select_1_row_cache 2.00 0.43 0.47 0.90 staging-1185 select_2_rows 2.00 0.50 0.30 0.80 staging-1188 select_2_rows 2.00 0.39 0.23 0.62 staging-1185 select_big 13.00 11.77 0.23 12.00 staging-1188 select_big 12.00 9.91 0.16 10.07 staging-1185 select_big_str 1.00 0.43 0.12 0.55 staging-1188 select_big_str 1.00 0.40 0.18 0.58 staging-1185 select_cache 56.00 1.01 0.19 1.20 staging-1188 select_cache 53.00 1.09 0.21 1.30 staging-1185 select_cache2 58.00 1.16 0.13 1.29 staging-1188 select_cache2 64.00 1.07 0.21 1.28 staging-1185 select_column+column 2.00 0.47 0.22 0.69 staging-1188 select_column+column 3.00 0.49 0.30 0.79 staging-1185 select_diff_key 1.00 0.07 0.01 0.08 staging-1188 select_diff_key 0.00 0.06 0.01 0.07 staging-1185 select_distinct 3.00 0.92 0.02 0.94 staging-1188 select_distinct 4.00 0.98 0.03 1.01 staging-1185 select_group 14.00 0.67 0.06 0.73 staging-1188 select_group 16.00 0.68 0.06 0.74 staging-1185 select_group_when_MANY_tables 4.00 0.29 0.19 0.48 staging-1188 select_group_when_MANY_tables 4.00 0.30 0.20 0.50 staging-1185 select_join 1.00 0.28 0.00 0.28 staging-1188 select_join 1.00 0.27 0.01 0.28 staging-1185 select_key 41.00 22.52 2.88 25.40 staging-1188 select_key 46.00 23.45 3.79 27.24 staging-1185 select_key2 45.00 17.42 3.20 20.62 staging-1188 select_key2 49.00 21.50 3.07 24.57 staging-1185 select_key2_return_key 43.00 19.11 3.07 22.18 staging-1188 select_key2_return_key 47.00 22.37 2.95 25.32 staging-1185 select_key2_return_prim 44.00 18.74 3.01 21.75 staging-1188 select_key2_return_prim 45.00 21.96 2.85 24.81 staging-1185 select_key_prefix 48.00 21.28 3.26 24.54 staging-1188 select_key_prefix 56.00 28.92 3.40 32.32 staging-1185 select_key_prefix_join 4.00 2.37 0.03 2.40 staging-1188 select_key_prefix_join 4.00 2.39 0.00 2.39 staging-1185 select_key_return_key 38.00 20.09 3.02 23.11 staging-1188 select_key_return_key 43.00 24.16 2.83 26.99 staging-1185 select_many_fields 16.00 8.97 0.22 9.19 staging-1188 select_many_fields 16.00 8.52 0.27 8.79 staging-1185 select_range 48.00 4.77 0.21 4.98 staging-1188 select_range 48.00 4.60 0.31 4.91 staging-1185 select_range_key2 8.00 2.51 0.32 2.83 staging-1188 select_range_key2 9.00 2.75 0.37 3.12 staging-1185 select_range_prefix 7.00 2.97 0.29 3.26 staging-1188 select_range_prefix 7.00 2.39 0.24 2.63 staging-1185 select_simple 2.00 0.39 0.24 0.63 staging-1188 select_simple 2.00 0.36 0.30 0.66 staging-1185 select_simple_cache 1.00 0.28 0.33 0.61 staging-1188 select_simple_cache 1.00 0.41 0.26 0.67 staging-1185 select_simple_join 1.00 0.34 0.01 0.35 staging-1188 select_simple_join 0.00 0.30 0.02 0.32 staging-1185 TOTALS 999.99 307.79 55.26 363.05 staging-1188 TOTALS 999.99 325.18 55.41 380.59 staging-1185 update_autocommit 3.00 0.38 0.13 0.51 staging-1188 update_autocommit 3.00 0.44 0.26 0.70 staging-1185 update_big 42.00 0.00 0.00 0.00 staging-1188 update_big 47.00 0.00 0.00 0.00 staging-1185 update_commit 1.00 0.16 0.14 0.30 staging-1188 update_commit 1.00 0.29 0.18 0.47 staging-1185 update_of_key 19.00 1.49 0.95 2.44 staging-1188 update_of_key 19.00 1.84 0.88 2.72 staging-1185 update_of_key_big 18.00 0.02 0.00 0.02 staging-1188 update_of_key_big 20.00 0.01 0.07 0.08 staging-1185 update_of_primary_key_many_keys 858.00 0.02 0.01 0.03 staging-1188 update_of_primary_key_many_keys 922.00 0.00 0.00 0.00 staging-1185 update_rollback 2.00 0.29 0.20 0.49 staging-1188 update_rollback 1.00 0.23 0.14 0.37 staging-1185 update_with_key 93.00 8.83 5.65 14.48 staging-1188 update_with_key 91.00 8.11 5.34 13.45 staging-1185 update_with_key_prefix 34.00 5.35 1.86 7.21 staging-1188 update_with_key_prefix 36.00 6.03 1.96 7.99 staging-1185 wisc_benchmark 3.00 1.80 0.21 2.01 staging-1188 wisc_benchmark 3.00 1.80 0.09 1.89 ================================================================== FULL REVISION COMMENTARY:
1165.2.4: Stewart Smith 2009-10-19 remove --disable-warnings in func_in_nu... 1165.2.3: Stewart Smith 2009-10-19 use MyISAM for tests so results for EXP... 1165.2.2: [email protected] 2009-10-12 MySQL Bug #44139: Table scan when ... 1165.2.1: Stewart Smith 2009-10-12 [merge] merge test case for bug 977.2.1: Stewart Smith 2009-04-08 Add test for SELECT IN () with NULL prod... _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
