Benchmark DBD suite: 2.15 Date of test: 2007-09-14 10:03:27 Running tests on: Linux 2.6.21-2-686 i686 Arguments: Comments: Limits from: Server version: MySQL 5.0.45 Debian_1 log/ Optimization: None Hardware: alter-table: Total time: 44 wallclock secs ( 0.04 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.05 CPU) ATIS: Total time: 6 wallclock secs ( 3.83 usr 0.24 sys + 0.00 cusr 0.00 csys = 4.07 CPU) big-tables: Total time: 6 wallclock secs ( 2.85 usr 0.23 sys + 0.00 cusr 0.00 csys = 3.08 CPU) connect: Total time: 82 wallclock secs (28.24 usr 10.12 sys + 0.00 cusr 0.00 csys = 38.36 CPU) create: Total time: 180 wallclock secs ( 2.75 usr 1.02 sys + 0.00 cusr 0.00 csys = 3.77 CPU) insert: Total time: 1268 wallclock secs (272.28 usr 35.04 sys + 0.00 cusr 0.00 csys = 307.32 CPU) select: Total time: 74 wallclock secs (25.28 usr 2.16 sys + 0.00 cusr 0.00 csys = 27.44 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 6 wallclock secs ( 1.62 usr 0.48 sys + 0.00 cusr 0.00 csys = 2.10 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 19.00 0.00 0.00 0.00 100 alter_table_drop 17.00 0.01 0.00 0.01 91 connect 5.00 3.18 0.54 3.72 10000 connect+select_1_row 6.00 3.58 0.74 4.32 10000 connect+select_simple 6.00 3.41 0.66 4.07 10000 count 6.00 0.04 0.00 0.04 100 count_distinct 0.00 0.13 0.01 0.14 1000 count_distinct_2 1.00 0.14 0.01 0.15 1000 count_distinct_big 5.00 3.25 0.02 3.27 120 count_distinct_group 1.00 0.45 0.01 0.46 1000 count_distinct_group_on_key 0.00 0.15 0.01 0.16 1000 count_distinct_group_on_key_parts 0.00 0.45 0.01 0.46 1000 count_distinct_key_prefix 0.00 0.12 0.02 0.14 1000 count_group_on_key_parts 1.00 0.45 0.01 0.46 1000 count_on_key 17.00 5.87 0.63 6.50 50100 create+drop 57.00 0.94 0.28 1.22 10000 create_MANY_tables 56.00 0.55 0.16 0.71 10000 create_index 4.00 0.00 0.00 0.00 8 create_key+drop 63.00 0.84 0.28 1.12 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 170.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 170.00 0.01 0.00 0.01 128 delete_key 5.00 0.15 0.14 0.29 10000 delete_range 6.00 0.00 0.00 0.00 12 drop_index 4.00 0.00 0.00 0.00 8 drop_table 1.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 2.00 0.21 0.12 0.33 10000 insert 41.00 6.25 4.48 10.73 350768 insert_duplicates 10.00 2.58 1.24 3.82 100000 insert_key 359.00 3.40 1.18 4.58 100000 insert_many_fields 3.00 0.10 0.02 0.12 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 2.00 0.00 0.00 0.00 1 min_max 2.00 0.00 0.00 0.00 60 min_max_on_key 13.00 9.69 1.21 10.90 85000 multiple_value_insert 2.00 0.24 0.02 0.26 100000 once_prepared_select 22.00 5.83 1.50 7.33 100000 order_by_big 13.00 9.44 0.12 9.56 10 order_by_big_key 13.00 10.28 0.22 10.50 10 order_by_big_key2 11.00 9.87 0.17 10.04 10 order_by_big_key_desc 12.00 10.27 0.29 10.56 10 order_by_big_key_diff 13.00 9.89 0.15 10.04 10 order_by_big_key_prefix 13.00 9.80 0.14 9.94 10 order_by_key2_diff 2.00 0.87 0.01 0.88 500 order_by_key_prefix 1.00 0.46 0.01 0.47 500 order_by_range 1.00 0.50 0.00 0.50 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 1.00 0.00 0.00 0.00 500 outer_join_on_key 1.00 0.00 0.00 0.00 10 prepared_select 28.00 13.12 1.56 14.68 100000 select_1_row 13.00 3.15 1.36 4.51 100000 select_1_row_cache 6.00 2.42 1.07 3.49 100000 select_2_rows 15.00 3.13 1.35 4.48 100000 select_big 11.00 9.81 0.15 9.96 80 select_big_str 5.00 2.04 0.51 2.55 10000 select_cache 2.00 1.12 0.12 1.24 10000 select_cache2 42.00 1.06 0.12 1.18 10000 select_column+column 14.00 2.79 1.35 4.14 100000 select_diff_key 0.00 0.07 0.00 0.07 500 select_distinct 1.00 0.73 0.02 0.75 800 select_group 2.00 0.61 0.04 0.65 2911 select_group_when_MANY_tables 2.00 0.20 0.18 0.38 10000 select_join 0.00 0.21 0.01 0.22 100 select_key 52.00 25.17 2.98 28.15 200000 select_key2 54.00 25.16 2.94 28.10 200000 select_key2_return_key 50.00 24.68 2.99 27.67 200000 select_key2_return_prim 52.00 25.28 3.04 28.32 200000 select_key_prefix 56.00 26.16 3.22 29.38 200000 select_key_prefix_join 2.00 1.84 0.00 1.84 100 select_key_return_key 50.00 23.97 2.72 26.69 200000 select_many_fields 3.00 2.75 0.21 2.96 2000 select_range 5.00 3.85 0.05 3.90 410 select_range_key2 2.00 2.40 0.18 2.58 25010 select_range_prefix 3.00 2.33 0.17 2.50 25010 select_simple 6.00 2.41 1.25 3.66 100000 select_simple_cache 6.00 2.12 1.29 3.41 100000 select_simple_join 0.00 0.25 0.02 0.27 500 update_big 16.00 0.00 0.00 0.00 10 update_of_key 27.00 0.97 0.59 1.56 50000 update_of_key_big 11.00 0.01 0.01 0.02 501 update_of_primary_key_many_keys 73.00 0.00 0.02 0.02 256 update_with_key 42.00 5.12 3.75 8.87 300000 update_with_key_prefix 13.00 3.08 1.46 4.54 100000 wisc_benchmark 1.00 1.17 0.08 1.25 114 TOTALS 1828.00 332.59 49.22 381.81 3425950