Benchmark DBD suite: 2.15 Date of test: 2009-04-06 14:33:11 Running tests on: FreeBSD 7.2-PRERELEASE amd64 Arguments: Comments: Limits from: Server version: MySQL 5.1.33 log Optimization: None Hardware: alter-table: Total time: 20 wallclock secs ( 0.05 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.07 CPU) ATIS: Total time: 13 wallclock secs ( 2.16 usr 0.24 sys + 0.00 cusr 0.00 csys = 2.41 CPU) big-tables: Total time: 13 wallclock secs ( 4.50 usr 0.23 sys + 0.00 cusr 0.00 csys = 4.73 CPU) connect: Total time: 77 wallclock secs (22.43 usr 12.31 sys + 0.00 cusr 0.00 csys = 34.74 CPU) create: Total time: 113 wallclock secs ( 2.21 usr 1.06 sys + 0.00 cusr 0.00 csys = 3.27 CPU) insert: Total time: 1083 wallclock secs (182.53 usr 39.30 sys + 0.00 cusr 0.00 csys = 221.83 CPU) select: Total time: 326 wallclock secs (16.54 usr 2.61 sys + 0.00 cusr 0.00 csys = 19.15 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 6 wallclock secs ( 1.22 usr 0.50 sys + 0.00 cusr 0.00 csys = 1.72 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 9.00 0.02 0.01 0.02 100 alter_table_drop 9.00 0.02 0.00 0.02 91 connect 6.00 3.18 0.97 4.15 10000 connect+select_1_row 8.00 4.00 0.91 4.91 10000 connect+select_simple 7.00 3.63 0.93 4.56 10000 count 4.00 0.02 0.01 0.02 100 count_distinct 11.00 0.11 0.02 0.13 1000 count_distinct_2 17.00 0.11 0.03 0.14 1000 count_distinct_big 19.00 1.80 0.04 1.84 120 count_distinct_group 10.00 0.27 0.03 0.30 1000 count_distinct_group_on_key 12.00 0.13 0.02 0.16 1000 count_distinct_group_on_key_parts 10.00 0.24 0.05 0.30 1000 count_distinct_key_prefix 5.00 0.09 0.03 0.12 1000 count_group_on_key_parts 17.00 0.25 0.02 0.27 1000 count_on_key 101.00 4.01 0.84 4.85 50100 create+drop 31.00 0.67 0.30 0.97 10000 create_MANY_tables 41.00 0.52 0.16 0.68 10000 create_index 1.00 0.00 0.00 0.00 8 create_key+drop 37.00 0.77 0.34 1.11 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 190.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 190.00 0.01 0.00 0.01 128 delete_key 2.00 0.10 0.13 0.23 10000 delete_range 5.00 0.01 0.00 0.01 12 drop_index 1.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 1.00 0.10 0.13 0.23 10000 insert 38.00 4.17 3.90 8.07 350768 insert_duplicates 8.00 1.46 1.45 2.91 100000 insert_key 182.00 3.26 1.23 4.49 100000 insert_many_fields 3.00 0.10 0.04 0.13 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 3.00 0.00 0.00 0.00 1 min_max 6.00 0.01 0.00 0.01 60 min_max_on_key 13.00 6.42 1.30 7.72 85000 multiple_value_insert 2.00 0.25 0.01 0.26 100000 once_prepared_select 16.00 3.23 1.38 4.61 100000 order_by_big 10.00 5.41 0.18 5.59 10 order_by_big_key 10.00 6.27 0.27 6.53 10 order_by_big_key2 7.00 5.48 0.13 5.61 10 order_by_big_key_desc 10.00 6.25 0.20 6.45 10 order_by_big_key_diff 9.00 5.41 0.17 5.59 10 order_by_big_key_prefix 9.00 5.47 0.20 5.66 10 order_by_key2_diff 2.00 0.55 0.00 0.55 500 order_by_key_prefix 1.00 0.24 0.02 0.27 500 order_by_range 1.00 0.26 0.02 0.28 500 outer_join 23.00 0.00 0.00 0.00 10 outer_join_found 23.00 0.01 0.00 0.01 10 outer_join_not_found 17.00 0.00 0.00 0.00 500 outer_join_on_key 17.00 0.00 0.00 0.00 10 prepared_select 22.00 7.67 1.66 9.34 100000 select_1_row 10.00 1.93 1.48 3.41 100000 select_1_row_cache 9.00 1.73 1.31 3.04 100000 select_2_rows 11.00 2.01 1.45 3.46 100000 select_big 8.00 5.42 0.20 5.62 80 select_big_str 5.00 1.52 1.24 2.77 10000 select_cache 42.00 0.82 0.11 0.93 10000 select_cache2 43.00 0.78 0.17 0.95 10000 select_column+column 10.00 1.52 1.41 2.93 100000 select_diff_key 0.00 0.05 0.01 0.06 500 select_distinct 3.00 0.43 0.03 0.46 800 select_group 18.00 0.40 0.05 0.45 2911 select_group_when_MANY_tables 3.00 0.16 0.12 0.27 10000 select_join 1.00 0.12 0.00 0.12 100 select_key 42.00 18.67 3.48 22.15 200000 select_key2 45.00 18.50 3.51 22.01 200000 select_key2_return_key 40.00 17.12 3.55 20.66 200000 select_key2_return_prim 42.00 17.28 3.64 20.92 200000 select_key_prefix 48.00 18.94 3.85 22.79 200000 select_key_prefix_join 3.00 0.90 0.04 0.94 100 select_key_return_key 38.00 17.38 3.39 20.77 200000 select_many_fields 10.00 4.41 0.20 4.60 2000 select_range 55.00 2.46 0.05 2.51 410 select_range_key2 7.00 1.90 0.27 2.18 25010 select_range_prefix 8.00 2.02 0.24 2.26 25010 select_simple 6.00 1.44 1.37 2.80 100000 select_simple_cache 5.00 1.47 1.23 2.70 100000 select_simple_join 1.00 0.14 0.02 0.16 500 update_big 16.00 0.00 0.00 0.00 10 update_of_key 8.00 0.63 0.56 1.20 50000 update_of_key_big 11.00 0.01 0.00 0.01 501 update_of_primary_key_many_keys 37.00 0.02 0.01 0.02 256 update_with_key 40.00 3.42 3.97 7.39 300000 update_with_key_prefix 15.00 2.58 1.89 4.47 100000 wisc_benchmark 2.00 0.88 0.17 1.05 114 TOTALS 1820.00 229.05 56.15 285.18 3425950