==================================================================
SQLBENCH REGRESSION REPORT
==================================================================
MACHINE: orisndriz05
RUN DATE: 2009-08-24T15:36:10.529900
VERSION: staging
REVISION: 1124
COMMENT: 1124: Brian Aker 2009-08-24 [merge] Merge Monty
==================================================================
staging-1121 alter_table_add 12.00 0.03 0.00 0.03
staging-1122 alter_table_add 12.00 0.02 0.00 0.02
staging-1124 alter_table_add 13.00 0.00 0.00 0.00
staging-1121 alter_table_drop 15.00 0.01 0.01 0.02
staging-1122 alter_table_drop 13.00 0.01 0.01 0.02
staging-1124 alter_table_drop 14.00 0.00 0.00 0.00
staging-1121 connect 2.00 0.69 0.34 1.03
staging-1122 connect 2.00 1.03 0.35 1.38
staging-1124 connect 2.00 0.88 0.51 1.39
staging-1121 connect+select_1_row 2.00 0.98 0.75 1.73
staging-1122 connect+select_1_row 2.00 0.77 0.53 1.30
staging-1124 connect+select_1_row 2.00 0.84 0.56 1.40
staging-1121 connect+select_simple 2.00 1.15 0.58 1.73
staging-1122 connect+select_simple 2.00 1.30 0.56 1.86
staging-1124 connect+select_simple 2.00 1.09 0.73 1.82
staging-1121 count 21.00 0.03 0.00 0.03
staging-1122 count 16.00 0.00 0.00 0.00
staging-1124 count 21.00 0.06 0.00 0.06
staging-1121 count_distinct 6.00 0.12 0.02 0.14
staging-1122 count_distinct 6.00 0.09 0.01 0.10
staging-1124 count_distinct 6.00 0.15 0.01 0.16
staging-1121 count_distinct_2 14.00 0.05 0.00 0.05
staging-1122 count_distinct_2 12.00 0.22 0.01 0.23
staging-1124 count_distinct_2 12.00 0.15 0.01 0.16
staging-1121 count_distinct_big 24.00 4.56 0.04 4.60
staging-1122 count_distinct_big 20.00 4.18 0.06 4.24
staging-1124 count_distinct_big 23.00 4.34 0.02 4.36
staging-1121 count_distinct_group 12.00 0.65 0.02 0.67
staging-1122 count_distinct_group 11.00 0.54 0.04 0.58
staging-1124 count_distinct_group 14.00 0.62 0.04 0.66
staging-1121 count_distinct_group_on_key 10.00 0.25 0.02 0.27
staging-1122 count_distinct_group_on_key 7.00 0.05 0.00 0.05
staging-1124 count_distinct_group_on_key 8.00 0.19 0.03 0.22
staging-1121 count_distinct_group_on_key_parts 12.00 0.31 0.00
0.31
staging-1122 count_distinct_group_on_key_parts 12.00 0.50 0.07
0.57
staging-1124 count_distinct_group_on_key_parts 13.00 0.52 0.04
0.56
staging-1121 count_distinct_key_prefix 6.00 0.19 0.03 0.22
staging-1122 count_distinct_key_prefix 4.00 0.19 0.01 0.20
staging-1124 count_distinct_key_prefix 5.00 0.10 0.05 0.15
staging-1121 count_group_on_key_parts 9.00 0.52 0.00 0.52
staging-1122 count_group_on_key_parts 10.00 1.87 0.03 1.90
staging-1124 count_group_on_key_parts 9.00 0.19 0.01 0.20
staging-1121 count_on_key 77.00 5.46 0.97 6.43
staging-1122 count_on_key 72.00 5.55 0.86 6.41
staging-1124 count_on_key 79.00 6.02 0.87 6.89
staging-1121 create+drop 19.00 1.31 0.51 1.82
staging-1122 create+drop 19.00 1.40 0.57 1.97
staging-1124 create+drop 19.00 1.56 0.40 1.96
staging-1121 create_index 2.00 0.00 0.00 0.00
staging-1122 create_index 2.00 0.00 0.00 0.00
staging-1124 create_index 2.00 0.00 0.00 0.00
staging-1121 create_key+drop 23.00 1.62 0.64 2.26
staging-1122 create_key+drop 25.00 1.47 0.53 2.00
staging-1124 create_key+drop 24.00 1.67 0.55 2.22
staging-1121 create_MANY_tables 16.00 1.06 0.38 1.44
staging-1122 create_MANY_tables 17.00 0.96 0.34 1.30
staging-1124 create_MANY_tables 18.00 1.01 0.31 1.32
staging-1121 create_table 0.00 0.01 0.00 0.01
staging-1122 create_table 0.00 0.00 0.00 0.00
staging-1124 create_table 0.00 0.00 0.00 0.00
staging-1121 delete_all_many_keys 974.00 0.01 0.00 0.01
staging-1122 delete_all_many_keys 999.99 0.03 0.00 0.03
staging-1124 delete_all_many_keys 999.99 0.00 0.01 0.01
staging-1121 delete_autocommit 3.00 0.30 0.22 0.52
staging-1122 delete_autocommit 3.00 0.32 0.19 0.51
staging-1124 delete_autocommit 3.00 0.31 0.13 0.44
staging-1121 delete_big 0.00 0.00 0.00 0.00
staging-1122 delete_big 0.00 0.00 0.00 0.00
staging-1124 delete_big 1.00 0.00 0.00 0.00
staging-1121 delete_big_many_keys 973.00 0.01 0.00 0.01
staging-1122 delete_big_many_keys 999.99 0.03 0.00 0.03
staging-1124 delete_big_many_keys 999.99 0.00 0.01 0.01
staging-1121 delete_commit 1.00 0.32 0.15 0.47
staging-1122 delete_commit 1.00 0.23 0.19 0.42
staging-1124 delete_commit 1.00 0.25 0.15 0.40
staging-1121 delete_key 3.00 0.16 0.26 0.42
staging-1122 delete_key 2.00 0.17 0.30 0.47
staging-1124 delete_key 3.00 0.13 0.23 0.36
staging-1121 delete_range 8.00 0.00 0.00 0.00
staging-1122 delete_range 9.00 0.01 0.00 0.01
staging-1124 delete_range 8.00 0.00 0.00 0.00
staging-1121 delete_rollback 2.00 0.22 0.24 0.46
staging-1122 delete_rollback 2.00 0.25 0.18 0.43
staging-1124 delete_rollback 2.00 0.26 0.15 0.41
staging-1121 drop_index 2.00 0.00 0.00 0.00
staging-1122 drop_index 2.00 0.00 0.00 0.00
staging-1124 drop_index 1.00 0.00 0.00 0.00
staging-1121 drop_table 0.00 0.00 0.00 0.00
staging-1122 drop_table 0.00 0.00 0.00 0.00
staging-1124 drop_table 0.00 0.00 0.00 0.00
staging-1121 drop_table_when_MANY_tables 15.00 0.53 0.26 0.79
staging-1122 drop_table_when_MANY_tables 19.00 0.42 0.19 0.61
staging-1124 drop_table_when_MANY_tables 18.00 0.51 0.15 0.66
staging-1121 insert 90.00 7.65 6.69 14.34
staging-1122 insert 94.00 7.69 6.71 14.40
staging-1124 insert 93.00 7.28 5.98 13.26
staging-1121 insert_autocommit 2.00 0.33 0.16 0.49
staging-1122 insert_autocommit 3.00 0.30 0.16 0.46
staging-1124 insert_autocommit 2.00 0.36 0.13 0.49
staging-1121 insert_commit 1.00 0.29 0.21 0.50
staging-1122 insert_commit 1.00 0.35 0.16 0.51
staging-1124 insert_commit 1.00 0.42 0.22 0.64
staging-1121 insert_duplicates 14.00 2.73 1.94 4.67
staging-1122 insert_duplicates 14.00 3.04 1.82 4.86
staging-1124 insert_duplicates 14.00 3.07 1.61 4.68
staging-1121 insert_key 512.00 5.56 2.27 7.83
staging-1122 insert_key 532.00 5.79 2.59 8.38
staging-1124 insert_key 528.00 5.32 2.07 7.39
staging-1121 insert_many_fields 4.00 0.14 0.06 0.20
staging-1122 insert_many_fields 4.00 0.16 0.05 0.21
staging-1124 insert_many_fields 5.00 0.14 0.07 0.21
staging-1121 insert_rollback 2.00 0.27 0.21 0.48
staging-1122 insert_rollback 1.00 0.32 0.16 0.48
staging-1124 insert_rollback 2.00 0.35 0.19 0.54
staging-1121 insert_select_1_key 4.00 0.00 0.00 0.00
staging-1122 insert_select_1_key 4.00 0.00 0.00 0.00
staging-1124 insert_select_1_key 4.00 0.00 0.00 0.00
staging-1121 insert_select_2_keys 5.00 0.00 0.00 0.00
staging-1122 insert_select_2_keys 6.00 0.00 0.00 0.00
staging-1124 insert_select_2_keys 5.00 0.00 0.00 0.00
staging-1121 min_max 11.00 0.01 0.01 0.02
staging-1122 min_max 9.00 0.00 0.00 0.00
staging-1124 min_max 11.00 0.00 0.00 0.00
staging-1121 min_max_on_key 19.00 10.28 1.67 11.95
staging-1122 min_max_on_key 17.00 9.40 1.30 10.70
staging-1124 min_max_on_key 17.00 10.73 1.27 12.00
staging-1121 multiple_value_insert 3.00 0.16 0.01 0.17
staging-1122 multiple_value_insert 2.00 0.14 0.00 0.14
staging-1124 multiple_value_insert 3.00 0.14 0.01 0.15
staging-1121 once_prepared_select 22.00 5.08 3.34 8.42
staging-1122 once_prepared_select 22.00 5.76 3.14 8.90
staging-1124 once_prepared_select 21.00 4.50 3.31 7.81
staging-1121 order_by_big 16.00 10.50 0.07 10.57
staging-1122 order_by_big 15.00 11.65 0.09 11.74
staging-1124 order_by_big 12.00 9.64 0.02 9.66
staging-1121 order_by_big_key 16.00 13.02 0.16 13.18
staging-1122 order_by_big_key 14.00 13.16 0.17 13.33
staging-1124 order_by_big_key 15.00 13.32 0.22 13.54
staging-1121 order_by_big_key2 14.00 10.07 0.05 10.12
staging-1122 order_by_big_key2 13.00 11.67 0.03 11.70
staging-1124 order_by_big_key2 12.00 11.85 0.02 11.87
staging-1121 order_by_big_key_desc 16.00 11.27 0.10 11.37
staging-1122 order_by_big_key_desc 15.00 13.18 0.11 13.29
staging-1124 order_by_big_key_desc 15.00 13.01 0.17 13.18
staging-1121 order_by_big_key_diff 15.00 10.48 0.06 10.54
staging-1122 order_by_big_key_diff 12.00 11.46 0.02 11.48
staging-1124 order_by_big_key_diff 13.00 11.56 0.01 11.57
staging-1121 order_by_big_key_prefix 15.00 10.15 0.05 10.20
staging-1122 order_by_big_key_prefix 14.00 11.67 0.05 11.72
staging-1124 order_by_big_key_prefix 14.00 11.95 0.05 12.00
staging-1121 order_by_key2_diff 1.00 1.09 0.03 1.12
staging-1122 order_by_key2_diff 1.00 0.77 0.01 0.78
staging-1124 order_by_key2_diff 1.00 0.85 0.01 0.86
staging-1121 order_by_key_prefix 1.00 0.58 0.00 0.58
staging-1122 order_by_key_prefix 0.00 0.43 0.00 0.43
staging-1124 order_by_key_prefix 1.00 0.50 0.00 0.50
staging-1121 order_by_range 1.00 0.50 0.01 0.51
staging-1122 order_by_range 1.00 0.44 0.02 0.46
staging-1124 order_by_range 1.00 0.54 0.00 0.54
staging-1121 outer_join 21.00 0.00 0.00 0.00
staging-1122 outer_join 21.00 0.00 0.00 0.00
staging-1124 outer_join 26.00 0.00 0.00 0.00
staging-1121 outer_join_found 20.00 0.00 0.00 0.00
staging-1122 outer_join_found 20.00 0.00 0.00 0.00
staging-1124 outer_join_found 26.00 0.00 0.00 0.00
staging-1121 outer_join_not_found 19.00 0.00 0.00 0.00
staging-1122 outer_join_not_found 18.00 0.00 0.00 0.00
staging-1124 outer_join_not_found 22.00 0.00 0.00 0.00
staging-1121 outer_join_on_key 10.00 0.00 0.00 0.00
staging-1122 outer_join_on_key 10.00 0.01 0.00 0.01
staging-1124 outer_join_on_key 14.00 0.00 0.00 0.00
staging-1121 prepared_select 25.00 9.73 3.19 12.92
staging-1122 prepared_select 26.00 11.68 2.65 14.33
staging-1124 prepared_select 26.00 11.08 2.67 13.75
staging-1121 select_1_row 2.00 0.53 0.32 0.85
staging-1122 select_1_row 3.00 0.71 0.38 1.09
staging-1124 select_1_row 2.00 0.59 0.24 0.83
staging-1121 select_1_row_cache 2.00 0.55 0.25 0.80
staging-1122 select_1_row_cache 2.00 0.73 0.52 1.25
staging-1124 select_1_row_cache 2.00 0.47 0.37 0.84
staging-1121 select_2_rows 3.00 0.43 0.17 0.60
staging-1122 select_2_rows 2.00 0.48 0.42 0.90
staging-1124 select_2_rows 3.00 0.41 0.33 0.74
staging-1121 select_big 16.00 11.71 0.31 12.02
staging-1122 select_big 12.00 9.85 0.23 10.08
staging-1124 select_big 13.00 11.96 0.27 12.23
staging-1121 select_big_str 1.00 0.46 0.14 0.60
staging-1122 select_big_str 1.00 0.42 0.12 0.54
staging-1124 select_big_str 1.00 0.40 0.18 0.58
staging-1121 select_cache 77.00 1.37 0.31 1.68
staging-1122 select_cache 57.00 0.29 0.05 0.34
staging-1124 select_cache 59.00 1.21 0.17 1.38
staging-1121 select_cache2 65.00 1.21 0.20 1.41
staging-1122 select_cache2 57.00 0.77 0.21 0.98
staging-1124 select_cache2 59.00 1.15 0.26 1.41
staging-1121 select_column+column 2.00 0.36 0.34 0.70
staging-1122 select_column+column 3.00 0.37 0.29 0.66
staging-1124 select_column+column 2.00 0.46 0.33 0.79
staging-1121 select_diff_key 1.00 0.06 0.00 0.06
staging-1122 select_diff_key 1.00 0.04 0.04 0.08
staging-1124 select_diff_key 0.00 0.09 0.00 0.09
staging-1121 select_distinct 3.00 1.08 0.02 1.10
staging-1122 select_distinct 3.00 0.74 0.01 0.75
staging-1124 select_distinct 3.00 0.90 0.02 0.92
staging-1121 select_group 16.00 0.68 0.08 0.76
staging-1122 select_group 19.00 0.68 0.08 0.76
staging-1124 select_group 18.00 0.81 0.05 0.86
staging-1121 select_group_when_MANY_tables 7.00 0.40 0.17 0.57
staging-1122 select_group_when_MANY_tables 7.00 0.47 0.21 0.68
staging-1124 select_group_when_MANY_tables 7.00 0.46 0.23 0.69
staging-1121 select_join 0.00 0.27 0.01 0.28
staging-1122 select_join 0.00 0.23 0.00 0.23
staging-1124 select_join 1.00 0.31 0.00 0.31
staging-1121 select_key 44.00 21.63 3.05 24.68
staging-1122 select_key 49.00 25.01 4.75 29.76
staging-1124 select_key 42.00 23.36 2.63 25.99
staging-1121 select_key2 51.00 22.64 3.35 25.99
staging-1122 select_key2 50.00 23.51 3.67 27.18
staging-1124 select_key2 48.00 21.81 2.95 24.76
staging-1121 select_key2_return_key 45.00 22.33 3.33 25.66
staging-1122 select_key2_return_key 52.00 25.09 3.36 28.45
staging-1124 select_key2_return_key 47.00 21.92 3.18 25.10
staging-1121 select_key2_return_prim 44.00 20.92 3.22 24.14
staging-1122 select_key2_return_prim 45.00 20.89 3.05 23.94
staging-1124 select_key2_return_prim 45.00 19.42 3.44 22.86
staging-1121 select_key_prefix 47.00 22.51 3.12 25.63
staging-1122 select_key_prefix 46.00 24.15 3.33 27.48
staging-1124 select_key_prefix 47.00 22.71 3.47 26.18
staging-1121 select_key_prefix_join 5.00 2.30 0.01 2.31
staging-1122 select_key_prefix_join 5.00 2.34 0.00 2.34
staging-1124 select_key_prefix_join 5.00 2.31 0.00 2.31
staging-1121 select_key_return_key 43.00 20.83 3.68 24.51
staging-1122 select_key_return_key 48.00 26.57 3.74 30.31
staging-1124 select_key_return_key 48.00 24.50 3.93 28.43
staging-1121 select_many_fields 17.00 10.91 0.28 11.19
staging-1122 select_many_fields 16.00 9.18 0.18 9.36
staging-1124 select_many_fields 17.00 8.76 0.20 8.96
staging-1121 select_range 49.00 4.56 0.24 4.80
staging-1122 select_range 48.00 4.60 0.30 4.90
staging-1124 select_range 48.00 4.71 0.21 4.92
staging-1121 select_range_key2 7.00 2.90 0.27 3.17
staging-1122 select_range_key2 7.00 2.44 0.30 2.74
staging-1124 select_range_key2 8.00 2.72 0.31 3.03
staging-1121 select_range_prefix 6.00 2.17 0.17 2.34
staging-1122 select_range_prefix 8.00 2.51 0.30 2.81
staging-1124 select_range_prefix 7.00 2.27 0.25 2.52
staging-1121 select_simple 1.00 0.33 0.36 0.69
staging-1122 select_simple 2.00 0.51 0.33 0.84
staging-1124 select_simple 1.00 0.29 0.27 0.56
staging-1121 select_simple_cache 2.00 0.50 0.37 0.87
staging-1122 select_simple_cache 1.00 0.42 0.38 0.80
staging-1124 select_simple_cache 2.00 0.48 0.36 0.84
staging-1121 select_simple_join 1.00 0.38 0.00 0.38
staging-1122 select_simple_join 1.00 0.32 0.03 0.35
staging-1124 select_simple_join 0.00 0.25 0.01 0.26
staging-1121 TOTALS 999.99 322.11 59.15 381.26
staging-1122 TOTALS 999.99 341.29 60.05 401.34
staging-1124 TOTALS 999.99 329.48 55.46 384.94
staging-1121 update_autocommit 3.00 0.34 0.14 0.48
staging-1122 update_autocommit 3.00 0.26 0.16 0.42
staging-1124 update_autocommit 3.00 0.23 0.16 0.39
staging-1121 update_big 44.00 0.00 0.00 0.00
staging-1122 update_big 45.00 0.00 0.00 0.00
staging-1124 update_big 45.00 0.00 0.00 0.00
staging-1121 update_commit 1.00 0.25 0.08 0.33
staging-1122 update_commit 1.00 0.26 0.21 0.47
staging-1124 update_commit 1.00 0.20 0.25 0.45
staging-1121 update_of_key 32.00 1.39 1.13 2.52
staging-1122 update_of_key 30.00 1.55 1.10 2.65
staging-1124 update_of_key 29.00 1.39 0.90 2.29
staging-1121 update_of_key_big 38.00 0.03 0.00 0.03
staging-1122 update_of_key_big 44.00 0.03 0.02 0.05
staging-1124 update_of_key_big 36.00 0.04 0.01 0.05
staging-1121 update_of_primary_key_many_keys 999.99 0.02 0.00 0.02
staging-1122 update_of_primary_key_many_keys 999.99 0.01 0.01 0.02
staging-1124 update_of_primary_key_many_keys 999.99 0.01 0.00 0.01
staging-1121 update_rollback 1.00 0.24 0.21 0.45
staging-1122 update_rollback 1.00 0.26 0.21 0.47
staging-1124 update_rollback 1.00 0.28 0.20 0.48
staging-1121 update_with_key 94.00 8.35 5.89 14.24
staging-1122 update_with_key 93.00 8.14 5.51 13.65
staging-1124 update_with_key 93.00 8.21 5.16 13.37
staging-1121 update_with_key_prefix 36.00 5.22 2.12 7.34
staging-1122 update_with_key_prefix 35.00 5.04 2.16 7.20
staging-1124 update_with_key_prefix 36.00 5.13 1.98 7.11
staging-1121 wisc_benchmark 2.00 1.81 0.08 1.89
staging-1122 wisc_benchmark 2.00 1.74 0.12 1.86
staging-1124 wisc_benchmark 2.00 1.80 0.14 1.94
==================================================================
FULL REVISION COMMENTARY:
1119.2.11: Monty Taylor 2009-08-24 [merge] Merged trunk.
1119.2.10: Monty Taylor 2009-08-22 [merge] Merged Stewart from lp:~stewart...
1119.8.3: Stewart Smith 2009-08-21 include global.h first for table prot...
1119.8.2: Stewart Smith 2009-08-21 fix up some style things in table_raw...
1119.8.1: Stewart Smith 2009-08-21 Add simple table proto reader that re...
1119.2.9: Monty Taylor 2009-08-20 [merge] Merged Stewart from lp:~stewart-...
1119.7.1: Stewart Smith 2009-08-20 Fix mtr2 timeouts/spurious test failu...
1119.2.8: Monty Taylor 2009-08-20 [merge] Merged Stewart from ~stewart-fla...
1119.6.1: Stewart Smith 2009-08-20 remove nasty malloc() optimisation in...
1119.2.7: Monty Taylor 2009-08-20 [merge] Merged Stewart from lp:~stewart-...
1119.5.1: Stewart Smith 2009-08-20 use a valid default value for key cac...
1119.2.6: Monty Taylor 2009-08-20 [merge] Merging Stewart from lp:~stewart...
1119.4.14: Stewart Smith 2009-06-16 slightly out of order variables resu...
1119.4.13: Stewart Smith 2009-06-16 make insert_update test not leave ta...
1119.4.12: Stewart Smith 2009-06-16 make subselect_sj test not leave tab...
1119.4.11: Stewart Smith 2009-06-16 make subselect_mat test not leave ta...
1119.4.10: Stewart Smith 2009-06-16 make subselect_innodb test not leave...
1119.4.9: Stewart Smith 2009-06-16 make show_create_table_utf8 test not ...
1119.4.8: Stewart Smith 2009-06-16 make type_blob test not leave tables ...
1119.4.7: Stewart Smith 2009-06-16 make variables test not leave state o...
1119.4.6: Stewart Smith 2009-06-16 make snowman test not leave tables be...
1119.4.5: Stewart Smith 2009-06-16 make group_by test not leave tables b...
1119.4.4: Stewart Smith 2009-06-16 make comment_index test not leave tab...
1119.4.3: Stewart Smith 2009-06-16 make comment_column2 test not leave t...
1119.4.2: Stewart Smith 2009-06-16 make clef test not leave tables behin...
1119.4.1: Stewart Smith 2009-06-16 make archive tests not change state o...
1119.2.5: Monty Taylor 2009-08-20 Fixed a namespace style thing.
1119.2.4: Monty Taylor 2009-08-20 [merge] Merged Ross from lp:~rwmcfa1/dri...
1107.1.1: rm 2009-08-04 fix for drizzletest chmod bug408690, mode string...
1119.2.3: Monty Taylor 2009-08-20 [merge] Merge Stewart from lp:~stewart-f...
1118.2.1: Stewart Smith 2009-08-19 fix drizzled::message::Table usage so...
1119.2.2: Monty Taylor 2009-08-20 [merge] Merged Stewart from lp:~stewart-...
1119.3.1: Stewart Smith 2009-08-20 Valgrind 3.5 requires --alignment to ...
1119.2.1: Monty Taylor 2009-08-20 [merge] Merged Stewart from lp:~stewart-...
1118.1.1: Stewart Smith 2009-08-19 remove unused ha_choice part of parser....
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
