==================================================================
SQLBENCH REGRESSION REPORT
==================================================================
MACHINE: orisndriz05
RUN DATE: 2009-10-13T17:50:42.371781
VERSION: staging
REVISION: 1183
COMMENT: 1183: Brian Aker 2009-10-13 [merge] MErge Innodb (plus Solaris fixes)
==================================================================
staging-1182 alter_table_add 13.00 0.04 0.02 0.06
staging-1183 alter_table_add 22.00 0.02 0.00 0.02
staging-1182 alter_table_drop 12.00 0.01 0.00 0.01
staging-1183 alter_table_drop 20.00 0.00 0.00 0.00
staging-1182 connect 1.00 0.87 0.53 1.40
staging-1183 connect 2.00 0.85 0.53 1.38
staging-1182 connect+select_1_row 2.00 1.27 0.51 1.78
staging-1183 connect+select_1_row 2.00 1.04 0.67 1.71
staging-1182 connect+select_simple 2.00 0.94 0.62 1.56
staging-1183 connect+select_simple 2.00 0.87 0.71 1.58
staging-1182 count 17.00 0.01 0.00 0.01
staging-1183 count 17.00 0.03 0.01 0.04
staging-1182 count_distinct 6.00 0.10 0.00 0.10
staging-1183 count_distinct 6.00 0.15 0.02 0.17
staging-1182 count_distinct_2 11.00 0.22 0.03 0.25
staging-1183 count_distinct_2 12.00 0.19 0.03 0.22
staging-1182 count_distinct_big 22.00 4.33 0.01 4.34
staging-1183 count_distinct_big 22.00 4.43 0.02 4.45
staging-1182 count_distinct_group 14.00 0.77 0.05 0.82
staging-1183 count_distinct_group 14.00 0.74 0.09 0.83
staging-1182 count_distinct_group_on_key 8.00 0.19 0.04 0.23
staging-1183 count_distinct_group_on_key 9.00 0.17 0.01 0.18
staging-1182 count_distinct_group_on_key_parts 13.00 0.68 0.07
0.75
staging-1183 count_distinct_group_on_key_parts 11.00 0.73 0.07
0.80
staging-1182 count_distinct_key_prefix 4.00 0.17 0.01 0.18
staging-1183 count_distinct_key_prefix 4.00 0.11 0.01 0.12
staging-1182 count_group_on_key_parts 8.00 0.57 0.01 0.58
staging-1183 count_group_on_key_parts 8.00 0.53 0.02 0.55
staging-1182 count_on_key 75.00 5.55 0.74 6.29
staging-1183 count_on_key 73.00 5.82 0.91 6.73
staging-1182 create+drop 19.00 1.50 0.48 1.98
staging-1183 create+drop 19.00 1.37 0.49 1.86
staging-1182 create_index 2.00 0.00 0.00 0.00
staging-1183 create_index 5.00 0.00 0.00 0.00
staging-1182 create_key+drop 24.00 1.76 0.56 2.32
staging-1183 create_key+drop 21.00 1.74 0.64 2.38
staging-1182 create_MANY_tables 20.00 1.18 0.44 1.62
staging-1183 create_MANY_tables 16.00 1.01 0.38 1.39
staging-1182 create_table 0.00 0.00 0.00 0.00
staging-1183 create_table 0.00 0.00 0.00 0.00
staging-1182 delete_all_many_keys 999.99 0.01 0.01 0.02
staging-1183 delete_all_many_keys 337.00 0.01 0.00 0.01
staging-1182 delete_autocommit 3.00 0.45 0.14 0.59
staging-1183 delete_autocommit 3.00 0.34 0.24 0.58
staging-1182 delete_big 1.00 0.00 0.00 0.00
staging-1183 delete_big 0.00 0.00 0.00 0.00
staging-1182 delete_big_many_keys 999.99 0.01 0.01 0.02
staging-1183 delete_big_many_keys 337.00 0.01 0.00 0.01
staging-1182 delete_commit 2.00 0.20 0.13 0.33
staging-1183 delete_commit 1.00 0.22 0.21 0.43
staging-1182 delete_key 2.00 0.18 0.21 0.39
staging-1183 delete_key 3.00 0.23 0.18 0.41
staging-1182 delete_range 9.00 0.01 0.00 0.01
staging-1183 delete_range 7.00 0.00 0.00 0.00
staging-1182 delete_rollback 2.00 0.19 0.12 0.31
staging-1183 delete_rollback 2.00 0.22 0.18 0.40
staging-1182 drop_index 2.00 0.00 0.00 0.00
staging-1183 drop_index 3.00 0.00 0.00 0.00
staging-1182 drop_table 0.00 0.00 0.00 0.00
staging-1183 drop_table 0.00 0.00 0.00 0.00
staging-1182 drop_table_when_MANY_tables 17.00 0.42 0.22 0.64
staging-1183 drop_table_when_MANY_tables 13.00 0.39 0.27 0.66
staging-1182 insert 93.00 8.08 5.91 13.99
staging-1183 insert 94.00 7.42 6.10 13.52
staging-1182 insert_autocommit 3.00 0.50 0.16 0.66
staging-1183 insert_autocommit 3.00 0.41 0.13 0.54
staging-1182 insert_commit 1.00 0.29 0.27 0.56
staging-1183 insert_commit 1.00 0.32 0.14 0.46
staging-1182 insert_duplicates 14.00 2.89 1.60 4.49
staging-1183 insert_duplicates 13.00 2.99 1.81 4.80
staging-1182 insert_key 517.00 5.39 2.06 7.45
staging-1183 insert_key 330.00 3.98 1.64 5.62
staging-1182 insert_many_fields 4.00 0.12 0.03 0.15
staging-1183 insert_many_fields 3.00 0.16 0.04 0.20
staging-1182 insert_rollback 1.00 0.35 0.14 0.49
staging-1183 insert_rollback 1.00 0.37 0.18 0.55
staging-1182 insert_select_1_key 4.00 0.00 0.00 0.00
staging-1183 insert_select_1_key 4.00 0.00 0.00 0.00
staging-1182 insert_select_2_keys 5.00 0.00 0.00 0.00
staging-1183 insert_select_2_keys 6.00 0.00 0.00 0.00
staging-1182 min_max 9.00 0.01 0.00 0.01
staging-1183 min_max 8.00 0.00 0.01 0.01
staging-1182 min_max_on_key 15.00 8.57 1.19 9.76
staging-1183 min_max_on_key 18.00 8.97 1.31 10.28
staging-1182 multiple_value_insert 3.00 0.13 0.00 0.13
staging-1183 multiple_value_insert 6.00 0.19 0.00 0.19
staging-1182 once_prepared_select 21.00 4.80 3.03 7.83
staging-1183 once_prepared_select 21.00 5.91 3.34 9.25
staging-1182 order_by_big 13.00 10.00 0.03 10.03
staging-1183 order_by_big 15.00 12.01 0.03 12.04
staging-1182 order_by_big_key 12.00 11.33 0.12 11.45
staging-1183 order_by_big_key 12.00 11.13 0.09 11.22
staging-1182 order_by_big_key2 11.00 9.84 0.05 9.89
staging-1183 order_by_big_key2 12.00 10.35 0.04 10.39
staging-1182 order_by_big_key_desc 13.00 11.38 0.17 11.55
staging-1183 order_by_big_key_desc 13.00 11.21 0.08 11.29
staging-1182 order_by_big_key_diff 11.00 10.01 0.11 10.12
staging-1183 order_by_big_key_diff 12.00 11.96 0.08 12.04
staging-1182 order_by_big_key_prefix 12.00 10.18 0.08 10.26
staging-1183 order_by_big_key_prefix 11.00 10.18 0.08 10.26
staging-1182 order_by_key2_diff 1.00 0.84 0.01 0.85
staging-1183 order_by_key2_diff 1.00 0.82 0.00 0.82
staging-1182 order_by_key_prefix 0.00 0.42 0.01 0.43
staging-1183 order_by_key_prefix 0.00 0.48 0.01 0.49
staging-1182 order_by_range 1.00 0.54 0.01 0.55
staging-1183 order_by_range 1.00 0.50 0.01 0.51
staging-1182 outer_join 26.00 0.00 0.00 0.00
staging-1183 outer_join 15.00 0.01 0.00 0.01
staging-1182 outer_join_found 26.00 0.00 0.00 0.00
staging-1183 outer_join_found 15.00 0.00 0.00 0.00
staging-1182 outer_join_not_found 23.00 0.00 0.00 0.00
staging-1183 outer_join_not_found 12.00 0.00 0.00 0.00
staging-1182 outer_join_on_key 14.00 0.00 0.00 0.00
staging-1183 outer_join_on_key 10.00 0.00 0.00 0.00
staging-1182 prepared_select 27.00 11.10 3.53 14.63
staging-1183 prepared_select 27.00 12.12 3.23 15.35
staging-1182 select_1_row 3.00 0.48 0.28 0.76
staging-1183 select_1_row 3.00 0.61 0.42 1.03
staging-1182 select_1_row_cache 2.00 0.57 0.41 0.98
staging-1183 select_1_row_cache 2.00 0.40 0.33 0.73
staging-1182 select_2_rows 2.00 0.57 0.25 0.82
staging-1183 select_2_rows 2.00 0.35 0.34 0.69
staging-1182 select_big 12.00 10.12 0.23 10.35
staging-1183 select_big 11.00 9.92 0.32 10.24
staging-1182 select_big_str 1.00 0.51 0.11 0.62
staging-1183 select_big_str 2.00 0.41 0.19 0.60
staging-1182 select_cache 75.00 1.09 0.16 1.25
staging-1183 select_cache 57.00 1.10 0.08 1.18
staging-1182 select_cache2 62.00 1.23 0.16 1.39
staging-1183 select_cache2 52.00 1.09 0.18 1.27
staging-1182 select_column+column 3.00 0.32 0.41 0.73
staging-1183 select_column+column 2.00 0.42 0.41 0.83
staging-1182 select_diff_key 0.00 0.05 0.00 0.05
staging-1183 select_diff_key 1.00 0.07 0.01 0.08
staging-1182 select_distinct 3.00 0.92 0.02 0.94
staging-1183 select_distinct 4.00 1.06 0.02 1.08
staging-1182 select_group 16.00 0.64 0.04 0.68
staging-1183 select_group 14.00 0.73 0.04 0.77
staging-1182 select_group_when_MANY_tables 7.00 0.28 0.12 0.40
staging-1183 select_group_when_MANY_tables 4.00 0.18 0.19 0.37
staging-1182 select_join 1.00 0.29 0.00 0.29
staging-1183 select_join 0.00 0.28 0.03 0.31
staging-1182 select_key 43.00 22.04 3.11 25.15
staging-1183 select_key 47.00 26.48 3.53 30.01
staging-1182 select_key2 50.00 24.65 3.02 27.67
staging-1183 select_key2 53.00 25.74 3.25 28.99
staging-1182 select_key2_return_key 46.00 20.55 3.24 23.79
staging-1183 select_key2_return_key 49.00 25.02 3.74 28.76
staging-1182 select_key2_return_prim 47.00 22.12 2.98 25.10
staging-1183 select_key2_return_prim 46.00 21.95 3.10 25.05
staging-1182 select_key_prefix 48.00 22.07 3.45 25.52
staging-1183 select_key_prefix 46.00 22.13 3.20 25.33
staging-1182 select_key_prefix_join 5.00 2.46 0.01 2.47
staging-1183 select_key_prefix_join 5.00 2.38 0.00 2.38
staging-1182 select_key_return_key 46.00 23.32 3.25 26.57
staging-1183 select_key_return_key 48.00 25.47 3.84 29.31
staging-1182 select_many_fields 17.00 8.72 0.21 8.93
staging-1183 select_many_fields 17.00 9.30 0.13 9.43
staging-1182 select_range 49.00 4.66 0.18 4.84
staging-1183 select_range 49.00 4.81 0.36 5.17
staging-1182 select_range_key2 7.00 2.34 0.26 2.60
staging-1183 select_range_key2 7.00 2.82 0.23 3.05
staging-1182 select_range_prefix 7.00 2.29 0.30 2.59
staging-1183 select_range_prefix 7.00 2.54 0.26 2.80
staging-1182 select_simple 2.00 0.42 0.26 0.68
staging-1183 select_simple 1.00 0.30 0.35 0.65
staging-1182 select_simple_cache 1.00 0.28 0.19 0.47
staging-1183 select_simple_cache 1.00 0.34 0.26 0.60
staging-1182 select_simple_join 1.00 0.36 0.03 0.39
staging-1183 select_simple_join 1.00 0.29 0.01 0.30
staging-1182 TOTALS 999.99 318.53 54.87 373.40
staging-1183 TOTALS 999.99 336.27 57.89 394.16
staging-1182 update_autocommit 2.00 0.38 0.20 0.58
staging-1183 update_autocommit 3.00 0.34 0.19 0.53
staging-1182 update_big 46.00 0.00 0.00 0.00
staging-1183 update_big 40.00 0.00 0.00 0.00
staging-1182 update_commit 1.00 0.27 0.21 0.48
staging-1183 update_commit 1.00 0.28 0.09 0.37
staging-1182 update_of_key 30.00 1.14 0.85 1.99
staging-1183 update_of_key 19.00 1.65 0.96 2.61
staging-1182 update_of_key_big 43.00 0.00 0.02 0.02
staging-1183 update_of_key_big 18.00 0.02 0.00 0.02
staging-1182 update_of_primary_key_many_keys 999.99 0.03 0.02 0.05
staging-1183 update_of_primary_key_many_keys 884.00 0.02 0.01 0.03
staging-1182 update_rollback 1.00 0.22 0.16 0.38
staging-1183 update_rollback 1.00 0.19 0.19 0.38
staging-1182 update_with_key 92.00 7.51 5.32 12.83
staging-1183 update_with_key 91.00 7.80 5.56 13.36
staging-1182 update_with_key_prefix 35.00 5.51 1.86 7.37
staging-1183 update_with_key_prefix 35.00 5.37 1.91 7.28
staging-1182 wisc_benchmark 3.00 1.72 0.08 1.80
staging-1183 wisc_benchmark 3.00 1.70 0.12 1.82
==================================================================
FULL REVISION COMMENTARY:
1182.1.3: Monty Taylor 2009-10-13 Fixed solaris build errors in InnoDB
1182.1.2: Monty Taylor 2009-10-13 Must test comparison for strict sun studio.
1182.1.1: Brian Aker 2009-10-13 [merge] Updated Innodb
1114.1.5: Monty Taylor 2009-10-12 [merge] Merged up with trunk.
1114.1.4: Monty Taylor 2009-09-23 [merge] Merged Diego from lp:~diego-fmpw...
1114.2.1: Diego Medina 2009-09-11 Added missing defined()
1114.1.3: Monty Taylor 2009-09-03 A few cleanups for sending back upstream.
1114.1.2: Monty Taylor 2009-08-17 "Fixed" the deadlock test. I'd still lik...
1114.1.1: Monty Taylor 2009-08-17 [merge] Merged InnoDB Plugin 1.0.4
641.2.3: Monty Taylor 2009-08-11 {innodb-plugin-1.0.4} InnoDB Plugin 1.0.4
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
