Benchmark DBD suite: 2.15 Date of test: 2007-07-05 19:37:10 Running tests on: Linux 2.6.18-4-amd64 x86_64 Arguments: Comments: Limits from: Server version: MySQL 5.0.32 Debian_7etch1 log/ Optimization: None Hardware: alter-table: Total time: 16 wallclock secs ( 0.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.02 CPU) ATIS: Total time: 4 wallclock secs ( 3.06 usr 0.38 sys + 0.00 cusr 0.00 csys = 3.44 CPU) big-tables: Total time: 6 wallclock secs ( 2.15 usr 0.69 sys + 0.00 cusr 0.00 csys = 2.84 CPU) connect: Total time: 48 wallclock secs (12.61 usr 8.13 sys + 0.00 cusr 0.00 csys = 20.74 CPU) create: Total time: 105 wallclock secs ( 1.54 usr 0.51 sys + 0.00 cusr 0.00 csys = 2.05 CPU) insert: Total time: 743 wallclock secs (157.35 usr 28.60 sys + 0.00 cusr 0.00 csys = 185.95 CPU) select: Total time: 47 wallclock secs (15.58 usr 2.10 sys + 0.00 cusr 0.00 csys = 17.68 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 4 wallclock secs ( 1.17 usr 0.47 sys + 0.00 cusr 0.00 csys = 1.64 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 7.00 0.00 0.00 0.00 100 alter_table_drop 7.00 0.01 0.00 0.01 91 connect 3.00 1.77 0.42 2.19 10000 connect+select_1_row 3.00 1.71 0.60 2.31 10000 connect+select_simple 3.00 1.86 0.48 2.34 10000 count 6.00 0.01 0.00 0.01 100 count_distinct 0.00 0.05 0.02 0.07 1000 count_distinct_2 0.00 0.07 0.00 0.07 1000 count_distinct_big 4.00 2.84 0.22 3.06 120 count_distinct_group 0.00 0.35 0.03 0.38 1000 count_distinct_group_on_key 0.00 0.09 0.02 0.11 1000 count_distinct_group_on_key_parts 1.00 0.35 0.03 0.38 1000 count_distinct_key_prefix 0.00 0.08 0.01 0.09 1000 count_group_on_key_parts 1.00 0.32 0.04 0.36 1000 count_on_key 9.00 2.90 0.48 3.38 50100 create+drop 38.00 0.48 0.13 0.61 10000 create_MANY_tables 29.00 0.44 0.08 0.52 10000 create_index 1.00 0.00 0.00 0.00 8 create_key+drop 35.00 0.47 0.14 0.61 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 176.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 176.00 0.00 0.00 0.00 128 delete_key 1.00 0.08 0.08 0.16 10000 delete_range 3.00 0.00 0.00 0.00 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.07 0.07 0.14 10000 insert 26.00 2.53 2.62 5.15 350768 insert_duplicates 5.00 0.80 0.86 1.66 100000 insert_key 126.00 1.98 0.77 2.75 100000 insert_many_fields 3.00 0.07 0.01 0.08 2000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 1.00 0.00 0.00 0.00 1 min_max 2.00 0.00 0.00 0.00 60 min_max_on_key 7.00 4.74 0.87 5.61 85000 multiple_value_insert 1.00 0.14 0.01 0.15 100000 once_prepared_select 13.00 3.62 0.99 4.61 100000 order_by_big 12.00 8.21 0.82 9.03 10 order_by_big_key 9.00 8.63 0.79 9.42 10 order_by_big_key2 9.00 8.12 0.82 8.94 10 order_by_big_key_desc 10.00 8.57 0.82 9.39 10 order_by_big_key_diff 10.00 8.25 0.76 9.01 10 order_by_big_key_prefix 9.00 8.18 0.82 9.00 10 order_by_key2_diff 1.00 0.75 0.05 0.80 500 order_by_key_prefix 0.00 0.40 0.03 0.43 500 order_by_range 1.00 0.37 0.04 0.41 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 1.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 0.00 0.00 0.00 0.00 10 prepared_select 16.00 5.63 0.99 6.62 100000 select_1_row 8.00 1.20 1.07 2.27 100000 select_1_row_cache 4.00 0.83 1.10 1.93 100000 select_2_rows 8.00 1.12 1.00 2.12 100000 select_big 9.00 8.26 0.78 9.04 80 select_big_str 3.00 1.32 0.46 1.78 10000 select_cache 1.00 0.50 0.15 0.65 10000 select_cache2 26.00 0.65 0.11 0.76 10000 select_column+column 8.00 1.05 0.98 2.03 100000 select_diff_key 1.00 0.04 0.00 0.04 500 select_distinct 1.00 0.59 0.05 0.64 800 select_group 1.00 0.38 0.05 0.43 2911 select_group_when_MANY_tables 2.00 0.08 0.09 0.17 10000 select_join 0.00 0.19 0.01 0.20 100 select_key 26.00 12.33 2.70 15.03 200000 select_key2 25.00 12.18 1.86 14.04 200000 select_key2_return_key 24.00 11.70 1.62 13.32 200000 select_key2_return_prim 26.00 12.34 1.87 14.21 200000 select_key_prefix 25.00 11.89 2.59 14.48 200000 select_key_prefix_join 1.00 1.58 0.15 1.73 100 select_key_return_key 24.00 11.96 1.89 13.85 200000 select_many_fields 3.00 2.08 0.68 2.76 2000 select_range 5.00 3.24 0.21 3.45 410 select_range_key2 2.00 1.38 0.18 1.56 25010 select_range_prefix 1.00 1.32 0.22 1.54 25010 select_simple 3.00 0.83 0.95 1.78 100000 select_simple_cache 4.00 0.92 1.07 1.99 100000 select_simple_join 1.00 0.20 0.02 0.22 500 update_big 10.00 0.00 0.00 0.00 10 update_of_key 42.00 0.35 0.21 0.56 50000 update_of_key_big 7.00 0.00 0.00 0.00 501 update_of_primary_key_many_keys 39.00 0.00 0.00 0.00 256 update_with_key 24.00 2.01 2.21 4.22 300000 update_with_key_prefix 7.00 1.43 1.18 2.61 100000 wisc_benchmark 1.00 0.99 0.23 1.22 114 TOTALS 1143.00 189.88 40.61 230.49 3425950