================================================================== SQLBENCH REGRESSION REPORT ================================================================== MACHINE: orisndriz05 RUN DATE: 2009-10-06T17:15:16.912729 VERSION: staging REVISION: 1166 COMMENT: 1166: Brian Aker 2009-10-06 [merge] Merge Jay ================================================================== staging-1164 alter_table_add 14.00 0.01 0.00 0.01 staging-1166 alter_table_add 13.00 0.01 0.00 0.01 staging-1164 alter_table_drop 16.00 0.00 0.01 0.01 staging-1166 alter_table_drop 13.00 0.00 0.00 0.00 staging-1164 connect 2.00 1.02 0.34 1.36 staging-1166 connect 2.00 0.94 0.49 1.43 staging-1164 connect+select_1_row 2.00 1.02 0.68 1.70 staging-1166 connect+select_1_row 3.00 1.20 0.61 1.81 staging-1164 connect+select_simple 2.00 1.24 0.51 1.75 staging-1166 connect+select_simple 2.00 1.13 0.52 1.65 staging-1164 count 16.00 0.01 0.01 0.02 staging-1166 count 20.00 0.01 0.00 0.01 staging-1164 count_distinct 5.00 0.14 0.03 0.17 staging-1166 count_distinct 5.00 0.08 0.02 0.10 staging-1164 count_distinct_2 11.00 0.19 0.02 0.21 staging-1166 count_distinct_2 12.00 0.13 0.02 0.15 staging-1164 count_distinct_big 21.00 4.55 0.02 4.57 staging-1166 count_distinct_big 25.00 4.51 0.00 4.51 staging-1164 count_distinct_group 14.00 0.59 0.08 0.67 staging-1166 count_distinct_group 11.00 0.49 0.06 0.55 staging-1164 count_distinct_group_on_key 8.00 0.17 0.03 0.20 staging-1166 count_distinct_group_on_key 8.00 0.15 0.01 0.16 staging-1164 count_distinct_group_on_key_parts 13.00 0.64 0.06 0.70 staging-1166 count_distinct_group_on_key_parts 13.00 0.51 0.06 0.57 staging-1164 count_distinct_key_prefix 5.00 0.20 0.04 0.24 staging-1166 count_distinct_key_prefix 5.00 0.11 0.00 0.11 staging-1164 count_group_on_key_parts 8.00 0.49 0.01 0.50 staging-1166 count_group_on_key_parts 8.00 0.35 0.03 0.38 staging-1164 count_on_key 81.00 5.86 0.87 6.73 staging-1166 count_on_key 76.00 6.25 0.86 7.11 staging-1164 create+drop 20.00 1.55 0.53 2.08 staging-1166 create+drop 19.00 1.57 0.60 2.17 staging-1164 create_index 2.00 0.00 0.00 0.00 staging-1166 create_index 1.00 0.00 0.00 0.00 staging-1164 create_key+drop 22.00 1.93 0.51 2.44 staging-1166 create_key+drop 24.00 1.40 0.62 2.02 staging-1164 create_MANY_tables 18.00 0.91 0.41 1.32 staging-1166 create_MANY_tables 19.00 1.01 0.36 1.37 staging-1164 create_table 0.00 0.01 0.01 0.02 staging-1166 create_table 0.00 0.00 0.00 0.00 staging-1164 delete_all_many_keys 999.99 0.01 0.00 0.01 staging-1166 delete_all_many_keys 999.99 0.00 0.01 0.01 staging-1164 delete_autocommit 2.00 0.27 0.19 0.46 staging-1166 delete_autocommit 3.00 0.30 0.16 0.46 staging-1164 delete_big 0.00 0.00 0.00 0.00 staging-1166 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-1166 delete_big_many_keys 999.99 0.00 0.01 0.01 staging-1164 delete_commit 2.00 0.24 0.22 0.46 staging-1166 delete_commit 1.00 0.20 0.16 0.36 staging-1164 delete_key 2.00 0.20 0.23 0.43 staging-1166 delete_key 2.00 0.24 0.18 0.42 staging-1164 delete_range 9.00 0.00 0.00 0.00 staging-1166 delete_range 8.00 0.00 0.00 0.00 staging-1164 delete_rollback 1.00 0.18 0.11 0.29 staging-1166 delete_rollback 1.00 0.26 0.15 0.41 staging-1164 drop_index 2.00 0.01 0.00 0.01 staging-1166 drop_index 2.00 0.00 0.00 0.00 staging-1164 drop_table 0.00 0.00 0.00 0.00 staging-1166 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-1166 drop_table_when_MANY_tables 18.00 0.38 0.22 0.60 staging-1164 insert 94.00 7.33 5.95 13.28 staging-1166 insert 94.00 7.40 6.12 13.52 staging-1164 insert_autocommit 2.00 0.41 0.20 0.61 staging-1166 insert_autocommit 3.00 0.45 0.25 0.70 staging-1164 insert_commit 2.00 0.27 0.22 0.49 staging-1166 insert_commit 1.00 0.31 0.18 0.49 staging-1164 insert_duplicates 14.00 2.97 1.99 4.96 staging-1166 insert_duplicates 14.00 3.25 1.63 4.88 staging-1164 insert_key 528.00 5.53 2.35 7.88 staging-1166 insert_key 509.00 5.44 2.34 7.78 staging-1164 insert_many_fields 4.00 0.17 0.05 0.22 staging-1166 insert_many_fields 4.00 0.15 0.10 0.25 staging-1164 insert_rollback 1.00 0.26 0.21 0.47 staging-1166 insert_rollback 1.00 0.33 0.16 0.49 staging-1164 insert_select_1_key 4.00 0.00 0.00 0.00 staging-1166 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-1166 insert_select_2_keys 6.00 0.00 0.00 0.00 staging-1164 min_max 8.00 0.01 0.01 0.02 staging-1166 min_max 11.00 0.02 0.00 0.02 staging-1164 min_max_on_key 16.00 7.95 1.54 9.49 staging-1166 min_max_on_key 16.00 8.61 1.32 9.93 staging-1164 multiple_value_insert 3.00 0.22 0.00 0.22 staging-1166 multiple_value_insert 3.00 0.14 0.00 0.14 staging-1164 once_prepared_select 20.00 4.75 3.22 7.97 staging-1166 once_prepared_select 21.00 6.19 3.22 9.41 staging-1164 order_by_big 14.00 10.30 0.08 10.38 staging-1166 order_by_big 14.00 9.92 0.07 9.99 staging-1164 order_by_big_key 13.00 11.50 0.16 11.66 staging-1166 order_by_big_key 13.00 11.35 0.15 11.50 staging-1164 order_by_big_key2 11.00 10.22 0.06 10.28 staging-1166 order_by_big_key2 11.00 10.13 0.05 10.18 staging-1164 order_by_big_key_desc 13.00 11.39 0.14 11.53 staging-1166 order_by_big_key_desc 13.00 11.30 0.15 11.45 staging-1164 order_by_big_key_diff 12.00 10.14 0.09 10.23 staging-1166 order_by_big_key_diff 11.00 10.06 0.06 10.12 staging-1164 order_by_big_key_prefix 13.00 10.30 0.06 10.36 staging-1166 order_by_big_key_prefix 12.00 10.23 0.13 10.36 staging-1164 order_by_key2_diff 2.00 1.01 0.02 1.03 staging-1166 order_by_key2_diff 2.00 1.08 0.02 1.10 staging-1164 order_by_key_prefix 0.00 0.53 0.00 0.53 staging-1166 order_by_key_prefix 1.00 0.55 0.00 0.55 staging-1164 order_by_range 1.00 0.53 0.02 0.55 staging-1166 order_by_range 0.00 0.54 0.00 0.54 staging-1164 outer_join 21.00 0.00 0.00 0.00 staging-1166 outer_join 26.00 0.00 0.00 0.00 staging-1164 outer_join_found 20.00 0.01 0.00 0.01 staging-1166 outer_join_found 25.00 0.00 0.00 0.00 staging-1164 outer_join_not_found 19.00 0.00 0.00 0.00 staging-1166 outer_join_not_found 24.00 0.00 0.00 0.00 staging-1164 outer_join_on_key 11.00 0.00 0.00 0.00 staging-1166 outer_join_on_key 14.00 0.00 0.00 0.00 staging-1164 prepared_select 25.00 10.30 2.74 13.04 staging-1166 prepared_select 25.00 9.47 3.05 12.52 staging-1164 select_1_row 2.00 0.63 0.32 0.95 staging-1166 select_1_row 2.00 0.51 0.30 0.81 staging-1164 select_1_row_cache 3.00 0.67 0.38 1.05 staging-1166 select_1_row_cache 2.00 0.41 0.36 0.77 staging-1164 select_2_rows 2.00 0.47 0.33 0.80 staging-1166 select_2_rows 2.00 0.44 0.28 0.72 staging-1164 select_big 12.00 10.44 0.16 10.60 staging-1166 select_big 12.00 10.19 0.28 10.47 staging-1164 select_big_str 1.00 0.43 0.12 0.55 staging-1166 select_big_str 1.00 0.35 0.17 0.52 staging-1164 select_cache 53.00 0.82 0.13 0.95 staging-1166 select_cache 54.00 1.11 0.14 1.25 staging-1164 select_cache2 54.00 1.00 0.18 1.18 staging-1166 select_cache2 54.00 1.07 0.17 1.24 staging-1164 select_column+column 3.00 0.42 0.31 0.73 staging-1166 select_column+column 3.00 0.41 0.37 0.78 staging-1164 select_diff_key 0.00 0.07 0.02 0.09 staging-1166 select_diff_key 0.00 0.05 0.01 0.06 staging-1164 select_distinct 4.00 0.95 0.05 1.00 staging-1166 select_distinct 4.00 1.07 0.02 1.09 staging-1164 select_group 19.00 0.74 0.05 0.79 staging-1166 select_group 17.00 0.78 0.04 0.82 staging-1164 select_group_when_MANY_tables 10.00 0.32 0.18 0.50 staging-1166 select_group_when_MANY_tables 8.00 0.25 0.23 0.48 staging-1164 select_join 0.00 0.27 0.00 0.27 staging-1166 select_join 0.00 0.29 0.00 0.29 staging-1164 select_key 44.00 23.68 2.92 26.60 staging-1166 select_key 40.00 19.98 3.13 23.11 staging-1164 select_key2 51.00 22.04 3.18 25.22 staging-1166 select_key2 50.00 22.20 3.11 25.31 staging-1164 select_key2_return_key 47.00 22.20 3.32 25.52 staging-1166 select_key2_return_key 46.00 21.00 3.08 24.08 staging-1164 select_key2_return_prim 51.00 27.05 2.69 29.74 staging-1166 select_key2_return_prim 49.00 24.64 3.57 28.21 staging-1164 select_key_prefix 53.00 26.33 4.80 31.13 staging-1166 select_key_prefix 54.00 25.67 4.15 29.82 staging-1164 select_key_prefix_join 5.00 2.23 0.00 2.23 staging-1166 select_key_prefix_join 5.00 2.37 0.02 2.39 staging-1164 select_key_return_key 45.00 22.99 3.48 26.47 staging-1166 select_key_return_key 44.00 19.78 3.41 23.19 staging-1164 select_many_fields 17.00 9.76 0.11 9.87 staging-1166 select_many_fields 17.00 8.92 0.15 9.07 staging-1164 select_range 50.00 4.65 0.23 4.88 staging-1166 select_range 49.00 4.92 0.18 5.10 staging-1164 select_range_key2 7.00 2.75 0.24 2.99 staging-1166 select_range_key2 7.00 2.51 0.30 2.81 staging-1164 select_range_prefix 8.00 2.77 0.30 3.07 staging-1166 select_range_prefix 8.00 2.69 0.24 2.93 staging-1164 select_simple 2.00 0.33 0.36 0.69 staging-1166 select_simple 1.00 0.35 0.28 0.63 staging-1164 select_simple_cache 1.00 0.44 0.33 0.77 staging-1166 select_simple_cache 1.00 0.37 0.33 0.70 staging-1164 select_simple_join 1.00 0.32 0.01 0.33 staging-1166 select_simple_join 1.00 0.32 0.03 0.35 staging-1164 TOTALS 999.99 330.53 57.85 388.38 staging-1166 TOTALS 999.99 318.35 58.17 376.52 staging-1164 update_autocommit 2.00 0.36 0.22 0.58 staging-1166 update_autocommit 3.00 0.23 0.16 0.39 staging-1164 update_big 46.00 0.00 0.00 0.00 staging-1166 update_big 45.00 0.00 0.00 0.00 staging-1164 update_commit 2.00 0.26 0.17 0.43 staging-1166 update_commit 1.00 0.24 0.14 0.38 staging-1164 update_of_key 30.00 1.31 0.91 2.22 staging-1166 update_of_key 29.00 1.45 0.80 2.25 staging-1164 update_of_key_big 37.00 0.03 0.02 0.05 staging-1166 update_of_key_big 42.00 0.03 0.00 0.03 staging-1164 update_of_primary_key_many_keys 999.99 0.02 0.01 0.03 staging-1166 update_of_primary_key_many_keys 999.99 0.00 0.01 0.01 staging-1164 update_rollback 2.00 0.32 0.09 0.41 staging-1166 update_rollback 2.00 0.31 0.10 0.41 staging-1164 update_with_key 92.00 8.45 5.83 14.28 staging-1166 update_with_key 93.00 7.92 6.00 13.92 staging-1164 update_with_key_prefix 36.00 5.15 2.02 7.17 staging-1166 update_with_key_prefix 35.00 5.59 2.25 7.84 staging-1164 wisc_benchmark 3.00 1.79 0.14 1.93 staging-1166 wisc_benchmark 3.00 1.78 0.21 1.99 ================================================================== FULL REVISION COMMENTARY:
1143.2.7: Jay Pipes 2009-10-05 Based on IRC discussions with Brian, this p... 1143.2.6: Jay Pipes 2009-10-05 [merge] Merge trunk 1143.2.5: Jay Pipes 2009-10-03 [merge] Merge with trunk 1143.2.4: Jay Pipes 2009-10-03 New transaction proto file containing messa... 1143.2.3: Jay Pipes 2009-10-01 [merge] Merge trunk 1143.2.2: Jay Pipes 2009-09-29 [merge] Merging fix for bug 437896 1143.2.1: Jay Pipes 2009-09-29 [merge] Merging command2sql library work. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
