==================================================================
SQLBENCH REGRESSION REPORT
==================================================================
MACHINE: orisndriz05
RUN DATE: 2009-08-22T09:50:20.387830
VERSION: staging
REVISION: 1122
COMMENT: 1122: Brian Aker 2009-08-21 [merge] Merge Jay
==================================================================
staging-1121 alter_table_add 12.00 0.03 0.00 0.03
staging-1121 alter_table_drop 15.00 0.01 0.01 0.02
staging-1121 connect 2.00 0.69 0.34 1.03
staging-1121 connect+select_1_row 2.00 0.98 0.75 1.73
staging-1121 connect+select_simple 2.00 1.15 0.58 1.73
staging-1121 count 21.00 0.03 0.00 0.03
staging-1121 count_distinct 6.00 0.12 0.02 0.14
staging-1121 count_distinct_2 14.00 0.05 0.00 0.05
staging-1121 count_distinct_big 24.00 4.56 0.04 4.60
staging-1121 count_distinct_group 12.00 0.65 0.02 0.67
staging-1121 count_distinct_group_on_key 10.00 0.25 0.02 0.27
staging-1121 count_distinct_group_on_key_parts 12.00 0.31 0.00
0.31
staging-1121 count_distinct_key_prefix 6.00 0.19 0.03 0.22
staging-1121 count_group_on_key_parts 9.00 0.52 0.00 0.52
staging-1121 count_on_key 77.00 5.46 0.97 6.43
staging-1121 create+drop 19.00 1.31 0.51 1.82
staging-1121 create_index 2.00 0.00 0.00 0.00
staging-1121 create_key+drop 23.00 1.62 0.64 2.26
staging-1121 create_MANY_tables 16.00 1.06 0.38 1.44
staging-1121 create_table 0.00 0.01 0.00 0.01
staging-1121 delete_all_many_keys 974.00 0.01 0.00 0.01
staging-1121 delete_autocommit 3.00 0.30 0.22 0.52
staging-1121 delete_big 0.00 0.00 0.00 0.00
staging-1121 delete_big_many_keys 973.00 0.01 0.00 0.01
staging-1121 delete_commit 1.00 0.32 0.15 0.47
staging-1121 delete_key 3.00 0.16 0.26 0.42
staging-1121 delete_range 8.00 0.00 0.00 0.00
staging-1121 delete_rollback 2.00 0.22 0.24 0.46
staging-1121 drop_index 2.00 0.00 0.00 0.00
staging-1121 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-1121 insert 90.00 7.65 6.69 14.34
staging-1121 insert_autocommit 2.00 0.33 0.16 0.49
staging-1121 insert_commit 1.00 0.29 0.21 0.50
staging-1121 insert_duplicates 14.00 2.73 1.94 4.67
staging-1121 insert_key 512.00 5.56 2.27 7.83
staging-1121 insert_many_fields 4.00 0.14 0.06 0.20
staging-1121 insert_rollback 2.00 0.27 0.21 0.48
staging-1121 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-1121 min_max 11.00 0.01 0.01 0.02
staging-1121 min_max_on_key 19.00 10.28 1.67 11.95
staging-1121 multiple_value_insert 3.00 0.16 0.01 0.17
staging-1121 once_prepared_select 22.00 5.08 3.34 8.42
staging-1121 order_by_big 16.00 10.50 0.07 10.57
staging-1121 order_by_big_key 16.00 13.02 0.16 13.18
staging-1121 order_by_big_key2 14.00 10.07 0.05 10.12
staging-1121 order_by_big_key_desc 16.00 11.27 0.10 11.37
staging-1121 order_by_big_key_diff 15.00 10.48 0.06 10.54
staging-1121 order_by_big_key_prefix 15.00 10.15 0.05 10.20
staging-1121 order_by_key2_diff 1.00 1.09 0.03 1.12
staging-1121 order_by_key_prefix 1.00 0.58 0.00 0.58
staging-1121 order_by_range 1.00 0.50 0.01 0.51
staging-1121 outer_join 21.00 0.00 0.00 0.00
staging-1121 outer_join_found 20.00 0.00 0.00 0.00
staging-1121 outer_join_not_found 19.00 0.00 0.00 0.00
staging-1121 outer_join_on_key 10.00 0.00 0.00 0.00
staging-1121 prepared_select 25.00 9.73 3.19 12.92
staging-1121 select_1_row 2.00 0.53 0.32 0.85
staging-1121 select_1_row_cache 2.00 0.55 0.25 0.80
staging-1121 select_2_rows 3.00 0.43 0.17 0.60
staging-1121 select_big 16.00 11.71 0.31 12.02
staging-1121 select_big_str 1.00 0.46 0.14 0.60
staging-1121 select_cache 77.00 1.37 0.31 1.68
staging-1121 select_cache2 65.00 1.21 0.20 1.41
staging-1121 select_column+column 2.00 0.36 0.34 0.70
staging-1121 select_diff_key 1.00 0.06 0.00 0.06
staging-1121 select_distinct 3.00 1.08 0.02 1.10
staging-1121 select_group 16.00 0.68 0.08 0.76
staging-1121 select_group_when_MANY_tables 7.00 0.40 0.17 0.57
staging-1121 select_join 0.00 0.27 0.01 0.28
staging-1121 select_key 44.00 21.63 3.05 24.68
staging-1121 select_key2 51.00 22.64 3.35 25.99
staging-1121 select_key2_return_key 45.00 22.33 3.33 25.66
staging-1121 select_key2_return_prim 44.00 20.92 3.22 24.14
staging-1121 select_key_prefix 47.00 22.51 3.12 25.63
staging-1121 select_key_prefix_join 5.00 2.30 0.01 2.31
staging-1121 select_key_return_key 43.00 20.83 3.68 24.51
staging-1121 select_many_fields 17.00 10.91 0.28 11.19
staging-1121 select_range 49.00 4.56 0.24 4.80
staging-1121 select_range_key2 7.00 2.90 0.27 3.17
staging-1121 select_range_prefix 6.00 2.17 0.17 2.34
staging-1121 select_simple 1.00 0.33 0.36 0.69
staging-1121 select_simple_cache 2.00 0.50 0.37 0.87
staging-1121 select_simple_join 1.00 0.38 0.00 0.38
staging-1121 TOTALS 999.99 322.11 59.15 381.26
staging-1121 update_autocommit 3.00 0.34 0.14 0.48
staging-1121 update_big 44.00 0.00 0.00 0.00
staging-1121 update_commit 1.00 0.25 0.08 0.33
staging-1121 update_of_key 32.00 1.39 1.13 2.52
staging-1121 update_of_key_big 38.00 0.03 0.00 0.03
staging-1121 update_of_primary_key_many_keys 999.99 0.02 0.00 0.02
staging-1121 update_rollback 1.00 0.24 0.21 0.45
staging-1121 update_with_key 94.00 8.35 5.89 14.24
staging-1121 update_with_key_prefix 36.00 5.22 2.12 7.34
staging-1121 wisc_benchmark 2.00 1.81 0.08 1.89
staging-1122 alter_table_add 12.00 0.02 0.00 0.02
staging-1122 alter_table_drop 13.00 0.01 0.01 0.02
staging-1122 connect 2.00 1.03 0.35 1.38
staging-1122 connect+select_1_row 2.00 0.77 0.53 1.30
staging-1122 connect+select_simple 2.00 1.30 0.56 1.86
staging-1122 count 16.00 0.00 0.00 0.00
staging-1122 count_distinct 6.00 0.09 0.01 0.10
staging-1122 count_distinct_2 12.00 0.22 0.01 0.23
staging-1122 count_distinct_big 20.00 4.18 0.06 4.24
staging-1122 count_distinct_group 11.00 0.54 0.04 0.58
staging-1122 count_distinct_group_on_key 7.00 0.05 0.00 0.05
staging-1122 count_distinct_group_on_key_parts 12.00 0.50 0.07
0.57
staging-1122 count_distinct_key_prefix 4.00 0.19 0.01 0.20
staging-1122 count_group_on_key_parts 10.00 1.87 0.03 1.90
staging-1122 count_on_key 72.00 5.55 0.86 6.41
staging-1122 create+drop 19.00 1.40 0.57 1.97
staging-1122 create_index 2.00 0.00 0.00 0.00
staging-1122 create_key+drop 25.00 1.47 0.53 2.00
staging-1122 create_MANY_tables 17.00 0.96 0.34 1.30
staging-1122 create_table 0.00 0.00 0.00 0.00
staging-1122 delete_all_many_keys 999.99 0.03 0.00 0.03
staging-1122 delete_autocommit 3.00 0.32 0.19 0.51
staging-1122 delete_big 0.00 0.00 0.00 0.00
staging-1122 delete_big_many_keys 999.99 0.03 0.00 0.03
staging-1122 delete_commit 1.00 0.23 0.19 0.42
staging-1122 delete_key 2.00 0.17 0.30 0.47
staging-1122 delete_range 9.00 0.01 0.00 0.01
staging-1122 delete_rollback 2.00 0.25 0.18 0.43
staging-1122 drop_index 2.00 0.00 0.00 0.00
staging-1122 drop_table 0.00 0.00 0.00 0.00
staging-1122 drop_table_when_MANY_tables 19.00 0.42 0.19 0.61
staging-1122 insert 94.00 7.69 6.71 14.40
staging-1122 insert_autocommit 3.00 0.30 0.16 0.46
staging-1122 insert_commit 1.00 0.35 0.16 0.51
staging-1122 insert_duplicates 14.00 3.04 1.82 4.86
staging-1122 insert_key 532.00 5.79 2.59 8.38
staging-1122 insert_many_fields 4.00 0.16 0.05 0.21
staging-1122 insert_rollback 1.00 0.32 0.16 0.48
staging-1122 insert_select_1_key 4.00 0.00 0.00 0.00
staging-1122 insert_select_2_keys 6.00 0.00 0.00 0.00
staging-1122 min_max 9.00 0.00 0.00 0.00
staging-1122 min_max_on_key 17.00 9.40 1.30 10.70
staging-1122 multiple_value_insert 2.00 0.14 0.00 0.14
staging-1122 once_prepared_select 22.00 5.76 3.14 8.90
staging-1122 order_by_big 15.00 11.65 0.09 11.74
staging-1122 order_by_big_key 14.00 13.16 0.17 13.33
staging-1122 order_by_big_key2 13.00 11.67 0.03 11.70
staging-1122 order_by_big_key_desc 15.00 13.18 0.11 13.29
staging-1122 order_by_big_key_diff 12.00 11.46 0.02 11.48
staging-1122 order_by_big_key_prefix 14.00 11.67 0.05 11.72
staging-1122 order_by_key2_diff 1.00 0.77 0.01 0.78
staging-1122 order_by_key_prefix 0.00 0.43 0.00 0.43
staging-1122 order_by_range 1.00 0.44 0.02 0.46
staging-1122 outer_join 21.00 0.00 0.00 0.00
staging-1122 outer_join_found 20.00 0.00 0.00 0.00
staging-1122 outer_join_not_found 18.00 0.00 0.00 0.00
staging-1122 outer_join_on_key 10.00 0.01 0.00 0.01
staging-1122 prepared_select 26.00 11.68 2.65 14.33
staging-1122 select_1_row 3.00 0.71 0.38 1.09
staging-1122 select_1_row_cache 2.00 0.73 0.52 1.25
staging-1122 select_2_rows 2.00 0.48 0.42 0.90
staging-1122 select_big 12.00 9.85 0.23 10.08
staging-1122 select_big_str 1.00 0.42 0.12 0.54
staging-1122 select_cache 57.00 0.29 0.05 0.34
staging-1122 select_cache2 57.00 0.77 0.21 0.98
staging-1122 select_column+column 3.00 0.37 0.29 0.66
staging-1122 select_diff_key 1.00 0.04 0.04 0.08
staging-1122 select_distinct 3.00 0.74 0.01 0.75
staging-1122 select_group 19.00 0.68 0.08 0.76
staging-1122 select_group_when_MANY_tables 7.00 0.47 0.21 0.68
staging-1122 select_join 0.00 0.23 0.00 0.23
staging-1122 select_key 49.00 25.01 4.75 29.76
staging-1122 select_key2 50.00 23.51 3.67 27.18
staging-1122 select_key2_return_key 52.00 25.09 3.36 28.45
staging-1122 select_key2_return_prim 45.00 20.89 3.05 23.94
staging-1122 select_key_prefix 46.00 24.15 3.33 27.48
staging-1122 select_key_prefix_join 5.00 2.34 0.00 2.34
staging-1122 select_key_return_key 48.00 26.57 3.74 30.31
staging-1122 select_many_fields 16.00 9.18 0.18 9.36
staging-1122 select_range 48.00 4.60 0.30 4.90
staging-1122 select_range_key2 7.00 2.44 0.30 2.74
staging-1122 select_range_prefix 8.00 2.51 0.30 2.81
staging-1122 select_simple 2.00 0.51 0.33 0.84
staging-1122 select_simple_cache 1.00 0.42 0.38 0.80
staging-1122 select_simple_join 1.00 0.32 0.03 0.35
staging-1122 TOTALS 999.99 341.29 60.05 401.34
staging-1122 update_autocommit 3.00 0.26 0.16 0.42
staging-1122 update_big 45.00 0.00 0.00 0.00
staging-1122 update_commit 1.00 0.26 0.21 0.47
staging-1122 update_of_key 30.00 1.55 1.10 2.65
staging-1122 update_of_key_big 44.00 0.03 0.02 0.05
staging-1122 update_of_primary_key_many_keys 999.99 0.01 0.01 0.02
staging-1122 update_rollback 1.00 0.26 0.21 0.47
staging-1122 update_with_key 93.00 8.14 5.51 13.65
staging-1122 update_with_key_prefix 35.00 5.04 2.16 7.20
staging-1122 wisc_benchmark 2.00 1.74 0.12 1.86
==================================================================
FULL REVISION COMMENTARY:
1115.3.14: Jay Pipes 2009-08-21 [merge] Merge Monty's fixes for extended h...
1119.1.2: Monty Taylor 2009-08-21 Fixed style issues. /me smacks /me.
1119.1.1: Monty Taylor 2009-08-20 --help doesn't need --datadir to work.
1115.3.13: Jay Pipes 2009-08-21 [merge] Merge Biping's pool of thread plug...
1089.12.14: Biping Meng 2009-08-21 [merge] Merge trunk and resolved confli...
1089.12.13: Biping Meng 2009-08-11 Made up the missing space
1089.12.12: Biping Meng 2009-08-10 Some tiny cleanups
1089.12.11: Biping Meng 2009-08-10 [merge] Merge trunk
1089.12.10: Biping Meng 2009-08-10 Some refinements on comments
1089.12.9: Biping Meng 2009-07-28 Bug causing assertion failure fixed
1089.12.8: Biping Meng 2009-07-21 If libevent_add_session is called when s...
1089.12.7: Biping Meng 2009-07-21 sessions_to_be_killed added in order to ...
1089.12.6: Biping Meng 2009-07-21 [merge] Merge trunk
1089.12.5: Biping Meng 2009-07-21 Unused parameter error fixed
1089.12.4: Biping Meng 2009-07-21 Several refinements on comments
1089.12.3: Biping Meng 2009-07-21 std::list sessions_waiting_for_io change...
1089.12.2: Biping Meng 2009-07-14 [merge] up to date merge
1089.12.1: Biping Meng 2009-07-11 std::list changed into std::queue
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
