================================================================== SQLBENCH REGRESSION REPORT ================================================================== MACHINE: orisndriz05 RUN DATE: 2009-08-29T09:57:12.040206 VERSION: staging REVISION: 1126 COMMENT: 1126: Brian Aker 2009-08-27 [merge] Merge Padraig ================================================================== staging-1124 alter_table_add 13.00 0.00 0.00 0.00 staging-1125 alter_table_add 14.00 0.03 0.00 0.03 staging-1126 alter_table_add 13.00 0.02 0.00 0.02 staging-1124 alter_table_drop 14.00 0.00 0.00 0.00 staging-1125 alter_table_drop 14.00 0.01 0.00 0.01 staging-1126 alter_table_drop 13.00 0.02 0.00 0.02 staging-1124 connect 2.00 0.88 0.51 1.39 staging-1125 connect 2.00 1.08 0.71 1.79 staging-1126 connect 1.00 0.91 0.48 1.39 staging-1124 connect+select_1_row 2.00 0.84 0.56 1.40 staging-1125 connect+select_1_row 3.00 0.90 0.45 1.35 staging-1126 connect+select_1_row 3.00 0.59 0.44 1.03 staging-1124 connect+select_simple 2.00 1.09 0.73 1.82 staging-1125 connect+select_simple 2.00 1.23 0.71 1.94 staging-1126 connect+select_simple 3.00 1.09 0.74 1.83 staging-1124 count 21.00 0.06 0.00 0.06 staging-1125 count 20.00 0.02 0.02 0.04 staging-1126 count 17.00 0.01 0.01 0.02 staging-1124 count_distinct 6.00 0.15 0.01 0.16 staging-1125 count_distinct 6.00 0.09 0.00 0.09 staging-1126 count_distinct 6.00 0.09 0.04 0.13 staging-1124 count_distinct_2 12.00 0.15 0.01 0.16 staging-1125 count_distinct_2 11.00 0.17 0.04 0.21 staging-1126 count_distinct_2 12.00 0.15 0.04 0.19 staging-1124 count_distinct_big 23.00 4.34 0.02 4.36 staging-1125 count_distinct_big 24.00 4.34 0.03 4.37 staging-1126 count_distinct_big 21.00 4.35 0.03 4.38 staging-1124 count_distinct_group 14.00 0.62 0.04 0.66 staging-1125 count_distinct_group 14.00 0.53 0.04 0.57 staging-1126 count_distinct_group 11.00 0.46 0.03 0.49 staging-1124 count_distinct_group_on_key 8.00 0.19 0.03 0.22 staging-1125 count_distinct_group_on_key 8.00 0.14 0.06 0.20 staging-1126 count_distinct_group_on_key 8.00 0.16 0.03 0.19 staging-1124 count_distinct_group_on_key_parts 13.00 0.52 0.04 0.56 staging-1125 count_distinct_group_on_key_parts 13.00 0.44 0.05 0.49 staging-1126 count_distinct_group_on_key_parts 13.00 0.47 0.04 0.51 staging-1124 count_distinct_key_prefix 5.00 0.10 0.05 0.15 staging-1125 count_distinct_key_prefix 4.00 0.11 0.04 0.15 staging-1126 count_distinct_key_prefix 4.00 0.19 0.03 0.22 staging-1124 count_group_on_key_parts 9.00 0.19 0.01 0.20 staging-1125 count_group_on_key_parts 7.00 0.47 0.04 0.51 staging-1126 count_group_on_key_parts 8.00 0.40 0.06 0.46 staging-1124 count_on_key 79.00 6.02 0.87 6.89 staging-1125 count_on_key 77.00 5.74 0.82 6.56 staging-1126 count_on_key 77.00 5.82 0.88 6.70 staging-1124 create+drop 19.00 1.56 0.40 1.96 staging-1125 create+drop 19.00 1.36 0.51 1.87 staging-1126 create+drop 20.00 1.60 0.66 2.26 staging-1124 create_index 2.00 0.00 0.00 0.00 staging-1125 create_index 3.00 0.00 0.00 0.00 staging-1126 create_index 2.00 0.01 0.01 0.02 staging-1124 create_key+drop 24.00 1.67 0.55 2.22 staging-1125 create_key+drop 25.00 1.57 0.64 2.21 staging-1126 create_key+drop 25.00 1.75 0.55 2.30 staging-1124 create_MANY_tables 18.00 1.01 0.31 1.32 staging-1125 create_MANY_tables 20.00 1.08 0.38 1.46 staging-1126 create_MANY_tables 22.00 1.20 0.27 1.47 staging-1124 create_table 0.00 0.00 0.00 0.00 staging-1125 create_table 0.00 0.00 0.00 0.00 staging-1126 create_table 0.00 0.02 0.00 0.02 staging-1124 delete_all_many_keys 999.99 0.00 0.01 0.01 staging-1125 delete_all_many_keys 999.99 0.01 0.01 0.02 staging-1126 delete_all_many_keys 996.00 0.01 0.00 0.01 staging-1124 delete_autocommit 3.00 0.31 0.13 0.44 staging-1125 delete_autocommit 3.00 0.23 0.28 0.51 staging-1126 delete_autocommit 3.00 0.31 0.21 0.52 staging-1124 delete_big 1.00 0.00 0.00 0.00 staging-1125 delete_big 0.00 0.00 0.00 0.00 staging-1126 delete_big 0.00 0.00 0.00 0.00 staging-1124 delete_big_many_keys 999.99 0.00 0.01 0.01 staging-1125 delete_big_many_keys 999.99 0.01 0.01 0.02 staging-1126 delete_big_many_keys 996.00 0.01 0.00 0.01 staging-1124 delete_commit 1.00 0.25 0.15 0.40 staging-1125 delete_commit 1.00 0.24 0.16 0.40 staging-1126 delete_commit 1.00 0.15 0.14 0.29 staging-1124 delete_key 3.00 0.13 0.23 0.36 staging-1125 delete_key 2.00 0.20 0.19 0.39 staging-1126 delete_key 3.00 0.17 0.14 0.31 staging-1124 delete_range 8.00 0.00 0.00 0.00 staging-1125 delete_range 8.00 0.00 0.00 0.00 staging-1126 delete_range 9.00 0.00 0.01 0.01 staging-1124 delete_rollback 2.00 0.26 0.15 0.41 staging-1125 delete_rollback 2.00 0.26 0.13 0.39 staging-1126 delete_rollback 1.00 0.20 0.16 0.36 staging-1124 drop_index 1.00 0.00 0.00 0.00 staging-1125 drop_index 2.00 0.00 0.00 0.00 staging-1126 drop_index 2.00 0.00 0.00 0.00 staging-1124 drop_table 0.00 0.00 0.00 0.00 staging-1125 drop_table 0.00 0.00 0.00 0.00 staging-1126 drop_table 0.00 0.00 0.00 0.00 staging-1124 drop_table_when_MANY_tables 18.00 0.51 0.15 0.66 staging-1125 drop_table_when_MANY_tables 19.00 0.53 0.29 0.82 staging-1126 drop_table_when_MANY_tables 19.00 0.45 0.22 0.67 staging-1124 insert 93.00 7.28 5.98 13.26 staging-1125 insert 92.00 7.65 6.61 14.26 staging-1126 insert 94.00 7.50 6.36 13.86 staging-1124 insert_autocommit 2.00 0.36 0.13 0.49 staging-1125 insert_autocommit 3.00 0.30 0.16 0.46 staging-1126 insert_autocommit 3.00 0.30 0.17 0.47 staging-1124 insert_commit 1.00 0.42 0.22 0.64 staging-1125 insert_commit 1.00 0.33 0.16 0.49 staging-1126 insert_commit 1.00 0.31 0.15 0.46 staging-1124 insert_duplicates 14.00 3.07 1.61 4.68 staging-1125 insert_duplicates 14.00 3.02 1.72 4.74 staging-1126 insert_duplicates 15.00 3.00 1.79 4.79 staging-1124 insert_key 528.00 5.32 2.07 7.39 staging-1125 insert_key 532.00 5.65 2.10 7.75 staging-1126 insert_key 524.00 5.43 2.12 7.55 staging-1124 insert_many_fields 5.00 0.14 0.07 0.21 staging-1125 insert_many_fields 4.00 0.12 0.01 0.13 staging-1126 insert_many_fields 4.00 0.20 0.05 0.25 staging-1124 insert_rollback 2.00 0.35 0.19 0.54 staging-1125 insert_rollback 1.00 0.34 0.17 0.51 staging-1126 insert_rollback 1.00 0.28 0.11 0.39 staging-1124 insert_select_1_key 4.00 0.00 0.00 0.00 staging-1125 insert_select_1_key 5.00 0.00 0.00 0.00 staging-1126 insert_select_1_key 4.00 0.00 0.00 0.00 staging-1124 insert_select_2_keys 5.00 0.00 0.00 0.00 staging-1125 insert_select_2_keys 6.00 0.00 0.00 0.00 staging-1126 insert_select_2_keys 5.00 0.00 0.00 0.00 staging-1124 min_max 11.00 0.00 0.00 0.00 staging-1125 min_max 11.00 0.01 0.00 0.01 staging-1126 min_max 10.00 0.00 0.00 0.00 staging-1124 min_max_on_key 17.00 10.73 1.27 12.00 staging-1125 min_max_on_key 17.00 9.00 1.61 10.61 staging-1126 min_max_on_key 17.00 9.10 1.40 10.50 staging-1124 multiple_value_insert 3.00 0.14 0.01 0.15 staging-1125 multiple_value_insert 3.00 0.22 0.02 0.24 staging-1126 multiple_value_insert 2.00 0.15 0.00 0.15 staging-1124 once_prepared_select 21.00 4.50 3.31 7.81 staging-1125 once_prepared_select 21.00 5.05 3.30 8.35 staging-1126 once_prepared_select 21.00 5.50 3.12 8.62 staging-1124 order_by_big 12.00 9.64 0.02 9.66 staging-1125 order_by_big 16.00 11.94 0.04 11.98 staging-1126 order_by_big 15.00 11.68 0.07 11.75 staging-1124 order_by_big_key 15.00 13.32 0.22 13.54 staging-1125 order_by_big_key 14.00 13.13 0.19 13.32 staging-1126 order_by_big_key 15.00 12.99 0.18 13.17 staging-1124 order_by_big_key2 12.00 11.85 0.02 11.87 staging-1125 order_by_big_key2 13.00 11.79 0.08 11.87 staging-1126 order_by_big_key2 13.00 11.68 0.05 11.73 staging-1124 order_by_big_key_desc 15.00 13.01 0.17 13.18 staging-1125 order_by_big_key_desc 15.00 13.13 0.15 13.28 staging-1126 order_by_big_key_desc 14.00 13.10 0.11 13.21 staging-1124 order_by_big_key_diff 13.00 11.56 0.01 11.57 staging-1125 order_by_big_key_diff 12.00 11.80 0.08 11.88 staging-1126 order_by_big_key_diff 12.00 11.77 0.07 11.84 staging-1124 order_by_big_key_prefix 14.00 11.95 0.05 12.00 staging-1125 order_by_big_key_prefix 14.00 11.84 0.03 11.87 staging-1126 order_by_big_key_prefix 14.00 11.72 0.06 11.78 staging-1124 order_by_key2_diff 1.00 0.85 0.01 0.86 staging-1125 order_by_key2_diff 1.00 1.10 0.00 1.10 staging-1126 order_by_key2_diff 1.00 0.82 0.01 0.83 staging-1124 order_by_key_prefix 1.00 0.50 0.00 0.50 staging-1125 order_by_key_prefix 1.00 0.55 0.00 0.55 staging-1126 order_by_key_prefix 1.00 0.51 0.00 0.51 staging-1124 order_by_range 1.00 0.54 0.00 0.54 staging-1125 order_by_range 0.00 0.50 0.01 0.51 staging-1126 order_by_range 1.00 0.50 0.01 0.51 staging-1124 outer_join 26.00 0.00 0.00 0.00 staging-1125 outer_join 26.00 0.01 0.00 0.01 staging-1126 outer_join 25.00 0.01 0.00 0.01 staging-1124 outer_join_found 26.00 0.00 0.00 0.00 staging-1125 outer_join_found 25.00 0.01 0.00 0.01 staging-1126 outer_join_found 25.00 0.01 0.00 0.01 staging-1124 outer_join_not_found 22.00 0.00 0.00 0.00 staging-1125 outer_join_not_found 18.00 0.00 0.00 0.00 staging-1126 outer_join_not_found 22.00 0.01 0.00 0.01 staging-1124 outer_join_on_key 14.00 0.00 0.00 0.00 staging-1125 outer_join_on_key 14.00 0.00 0.00 0.00 staging-1126 outer_join_on_key 13.00 0.00 0.00 0.00 staging-1124 prepared_select 26.00 11.08 2.67 13.75 staging-1125 prepared_select 25.00 10.11 2.58 12.69 staging-1126 prepared_select 25.00 10.98 3.02 14.00 staging-1124 select_1_row 2.00 0.59 0.24 0.83 staging-1125 select_1_row 2.00 0.50 0.33 0.83 staging-1126 select_1_row 2.00 0.49 0.35 0.84 staging-1124 select_1_row_cache 2.00 0.47 0.37 0.84 staging-1125 select_1_row_cache 2.00 0.63 0.43 1.06 staging-1126 select_1_row_cache 2.00 0.27 0.27 0.54 staging-1124 select_2_rows 3.00 0.41 0.33 0.74 staging-1125 select_2_rows 3.00 0.54 0.30 0.84 staging-1126 select_2_rows 2.00 0.41 0.26 0.67 staging-1124 select_big 13.00 11.96 0.27 12.23 staging-1125 select_big 13.00 11.89 0.21 12.10 staging-1126 select_big 13.00 11.76 0.28 12.04 staging-1124 select_big_str 1.00 0.40 0.18 0.58 staging-1125 select_big_str 1.00 0.45 0.06 0.51 staging-1126 select_big_str 1.00 0.53 0.12 0.65 staging-1124 select_cache 59.00 1.21 0.17 1.38 staging-1125 select_cache 57.00 1.05 0.10 1.15 staging-1126 select_cache 55.00 1.01 0.09 1.10 staging-1124 select_cache2 59.00 1.15 0.26 1.41 staging-1125 select_cache2 53.00 0.84 0.25 1.09 staging-1126 select_cache2 55.00 0.92 0.25 1.17 staging-1124 select_column+column 2.00 0.46 0.33 0.79 staging-1125 select_column+column 2.00 0.50 0.38 0.88 staging-1126 select_column+column 3.00 0.43 0.33 0.76 staging-1124 select_diff_key 0.00 0.09 0.00 0.09 staging-1125 select_diff_key 1.00 0.11 0.02 0.13 staging-1126 select_diff_key 0.00 0.07 0.00 0.07 staging-1124 select_distinct 3.00 0.90 0.02 0.92 staging-1125 select_distinct 4.00 0.69 0.02 0.71 staging-1126 select_distinct 3.00 0.94 0.02 0.96 staging-1124 select_group 18.00 0.81 0.05 0.86 staging-1125 select_group 16.00 0.72 0.07 0.79 staging-1126 select_group 16.00 0.62 0.07 0.69 staging-1124 select_group_when_MANY_tables 7.00 0.46 0.23 0.69 staging-1125 select_group_when_MANY_tables 7.00 0.15 0.25 0.40 staging-1126 select_group_when_MANY_tables 7.00 0.35 0.24 0.59 staging-1124 select_join 1.00 0.31 0.00 0.31 staging-1125 select_join 0.00 0.25 0.00 0.25 staging-1126 select_join 1.00 0.27 0.00 0.27 staging-1124 select_key 42.00 23.36 2.63 25.99 staging-1125 select_key 47.00 25.28 3.80 29.08 staging-1126 select_key 50.00 25.91 3.60 29.51 staging-1124 select_key2 48.00 21.81 2.95 24.76 staging-1125 select_key2 53.00 23.80 3.34 27.14 staging-1126 select_key2 51.00 22.92 3.41 26.33 staging-1124 select_key2_return_key 47.00 21.92 3.18 25.10 staging-1125 select_key2_return_key 46.00 22.14 3.56 25.70 staging-1126 select_key2_return_key 49.00 20.15 3.21 23.36 staging-1124 select_key2_return_prim 45.00 19.42 3.44 22.86 staging-1125 select_key2_return_prim 49.00 22.63 3.18 25.81 staging-1126 select_key2_return_prim 54.00 26.86 4.97 31.83 staging-1124 select_key_prefix 47.00 22.71 3.47 26.18 staging-1125 select_key_prefix 54.00 28.02 2.87 30.89 staging-1126 select_key_prefix 52.00 24.45 3.61 28.06 staging-1124 select_key_prefix_join 5.00 2.31 0.00 2.31 staging-1125 select_key_prefix_join 5.00 2.19 0.00 2.19 staging-1126 select_key_prefix_join 5.00 2.21 0.00 2.21 staging-1124 select_key_return_key 48.00 24.50 3.93 28.43 staging-1125 select_key_return_key 43.00 19.25 3.65 22.90 staging-1126 select_key_return_key 48.00 24.58 3.93 28.51 staging-1124 select_many_fields 17.00 8.76 0.20 8.96 staging-1125 select_many_fields 16.00 9.17 0.25 9.42 staging-1126 select_many_fields 16.00 9.01 0.15 9.16 staging-1124 select_range 48.00 4.71 0.21 4.92 staging-1125 select_range 49.00 4.63 0.32 4.95 staging-1126 select_range 49.00 4.57 0.27 4.84 staging-1124 select_range_key2 8.00 2.72 0.31 3.03 staging-1125 select_range_key2 8.00 2.55 0.21 2.76 staging-1126 select_range_key2 8.00 2.61 0.27 2.88 staging-1124 select_range_prefix 7.00 2.27 0.25 2.52 staging-1125 select_range_prefix 7.00 2.21 0.19 2.40 staging-1126 select_range_prefix 8.00 2.45 0.31 2.76 staging-1124 select_simple 1.00 0.29 0.27 0.56 staging-1125 select_simple 1.00 0.40 0.26 0.66 staging-1126 select_simple 1.00 0.41 0.36 0.77 staging-1124 select_simple_cache 2.00 0.48 0.36 0.84 staging-1125 select_simple_cache 1.00 0.31 0.38 0.69 staging-1126 select_simple_cache 1.00 0.44 0.25 0.69 staging-1124 select_simple_join 0.00 0.25 0.01 0.26 staging-1125 select_simple_join 1.00 0.36 0.00 0.36 staging-1126 select_simple_join 1.00 0.33 0.04 0.37 staging-1124 TOTALS 999.99 329.48 55.46 384.94 staging-1125 TOTALS 999.99 336.50 58.16 394.66 staging-1126 TOTALS 999.99 341.52 60.66 402.18 staging-1124 update_autocommit 3.00 0.23 0.16 0.39 staging-1125 update_autocommit 3.00 0.28 0.19 0.47 staging-1126 update_autocommit 3.00 0.24 0.24 0.48 staging-1124 update_big 45.00 0.00 0.00 0.00 staging-1125 update_big 43.00 0.00 0.00 0.00 staging-1126 update_big 49.00 0.00 0.00 0.00 staging-1124 update_commit 1.00 0.20 0.25 0.45 staging-1125 update_commit 1.00 0.24 0.22 0.46 staging-1126 update_commit 1.00 0.20 0.18 0.38 staging-1124 update_of_key 29.00 1.39 0.90 2.29 staging-1125 update_of_key 30.00 1.49 0.96 2.45 staging-1126 update_of_key 31.00 1.24 1.05 2.29 staging-1124 update_of_key_big 36.00 0.04 0.01 0.05 staging-1125 update_of_key_big 39.00 0.01 0.01 0.02 staging-1126 update_of_key_big 31.00 0.03 0.00 0.03 staging-1124 update_of_primary_key_many_keys 999.99 0.01 0.00 0.01 staging-1125 update_of_primary_key_many_keys 999.99 0.01 0.02 0.03 staging-1126 update_of_primary_key_many_keys 999.99 0.04 0.00 0.04 staging-1124 update_rollback 1.00 0.28 0.20 0.48 staging-1125 update_rollback 1.00 0.23 0.15 0.38 staging-1126 update_rollback 2.00 0.19 0.18 0.37 staging-1124 update_with_key 93.00 8.21 5.16 13.37 staging-1125 update_with_key 92.00 7.41 5.47 12.88 staging-1126 update_with_key 95.00 8.46 5.87 14.33 staging-1124 update_with_key_prefix 36.00 5.13 1.98 7.11 staging-1125 update_with_key_prefix 35.00 5.29 2.00 7.29 staging-1126 update_with_key_prefix 36.00 6.17 2.28 8.45 staging-1124 wisc_benchmark 2.00 1.80 0.14 1.94 staging-1125 wisc_benchmark 2.00 1.89 0.08 1.97 staging-1126 wisc_benchmark 3.00 1.82 0.13 1.95 ================================================================== FULL REVISION COMMENTARY:
1100.3.68: Padraig O'Sullivan 2009-08-26 Changed the type of res in mysql_... 1100.3.67: Padraig O'Sullivan 2009-08-26 Various small style cleanups. 1100.3.66: Padraig O'Sullivan 2009-08-26 Extracted the last commands....Fi... 1100.3.65: Padraig O'Sullivan 2009-08-26 Extracted the CREATE TABLE comman... 1100.3.64: Padraig O'Sullivan 2009-08-26 Extracted the REPLACE and INSERT ... 1100.3.63: Padraig O'Sullivan 2009-08-26 Extracted the ALTER TABLE command... 1100.3.62: Padraig O'Sullivan 2009-08-25 Created a CreateIndex class and D... 1100.3.61: Padraig O'Sullivan 2009-08-25 Various style cleanups based on c... 1100.3.60: Padraig O'Sullivan 2009-08-25 Changed the command Begin to Star... 1100.3.59: Padraig O'Sullivan 2009-08-25 [merge] Merge from trunk. 1100.3.58: Padraig O'Sullivan 2009-08-20 Few style cleanups. 1100.3.57: Padraig O'Sullivan 2009-08-20 Extracted the RENAME TABLE comman... 1100.3.56: Padraig O'Sullivan 2009-08-20 Extracted the CREATE INDEX and DR... 1100.3.55: Padraig O'Sullivan 2009-08-20 Extracted the BEGIN command into ... 1100.3.54: Padraig O'Sullivan 2009-08-20 Extracted the RELEASE SAVEPOINT c... 1100.3.53: Padraig O'Sullivan 2009-08-20 Whoops, fixed a return statement ... 1100.3.52: Padraig O'Sullivan 2009-08-20 Extracted the ROLLBACK_TO_SAVEPOI... 1100.3.51: Padraig O'Sullivan 2009-08-20 Extracted the SAVEPOINT command i... 1100.3.50: Padraig O'Sullivan 2009-08-20 [merge] Merge from trunk. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
