Benchmark DBD suite: 2.15 Date of test: 2007-06-29 10:26:34 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: 62 wallclock secs ( 0.00 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.02 CPU) ATIS: Total time: 6 wallclock secs ( 4.11 usr 0.45 sys + 0.00 cusr 0.00 csys = 4.56 CPU) big-tables: Total time: 9 wallclock secs ( 2.74 usr 0.79 sys + 0.00 cusr 0.00 csys = 3.53 CPU) connect: Total time: 65 wallclock secs (15.78 usr 8.53 sys + 0.00 cusr 0.00 csys = 24.31 CPU) create: Failed (output/create-mysql-Linux_2.6.18_4_amd64_x86_64) insert: Total time: 1294 wallclock secs (207.78 usr 39.66 sys + 0.00 cusr 0.00 csys = 247.44 CPU) select: Total time: 61 wallclock secs (20.49 usr 3.03 sys + 0.00 cusr 0.00 csys = 23.52 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 5 wallclock secs ( 1.64 usr 0.35 sys + 0.00 cusr 0.00 csys = 1.99 CPU) Of 9 tests, 1 tests didn't work Totals per operation: Operation seconds usr sys cpu tests alter_table_add 26.00 0.00 0.00 0.00 100 alter_table_drop 27.00 0.00 0.00 0.00 91 connect 3.00 2.24 0.45 2.69 10000 connect+select_1_row 5.00 2.20 0.52 2.72 10000 connect+select_simple 4.00 2.21 0.55 2.76 10000 count 7.00 0.00 0.00 0.00 100 count_distinct 0.00 0.09 0.02 0.11 1000 count_distinct_2 0.00 0.08 0.02 0.10 1000 count_distinct_big 5.00 3.77 0.45 4.22 120 count_distinct_group 0.00 0.46 0.05 0.51 1000 count_distinct_group_on_key 0.00 0.11 0.02 0.13 1000 count_distinct_group_on_key_parts 1.00 0.46 0.06 0.52 1000 count_distinct_key_prefix 0.00 0.10 0.01 0.11 1000 count_group_on_key_parts 1.00 0.45 0.05 0.50 1000 count_on_key 12.00 3.73 0.73 4.46 50100 create_index 5.00 0.00 0.00 0.00 8 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 247.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 247.00 0.00 0.00 0.00 128 delete_key 1.00 0.09 0.11 0.20 10000 delete_range 5.00 0.00 0.00 0.00 12 drop_index 4.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 insert 33.00 3.34 3.37 6.71 350768 insert_duplicates 8.00 1.17 0.86 2.03 100000 insert_key 431.00 2.45 0.94 3.39 100000 insert_many_fields 5.00 0.08 0.04 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.01 0.00 0.01 60 min_max_on_key 11.00 6.31 1.13 7.44 85000 multiple_value_insert 1.00 0.19 0.01 0.20 100000 once_prepared_select 15.00 3.99 0.95 4.94 100000 order_by_big 15.00 10.59 1.15 11.74 10 order_by_big_key 12.00 11.15 1.26 12.41 10 order_by_big_key2 11.00 10.62 1.21 11.83 10 order_by_big_key_desc 13.00 11.20 1.24 12.44 10 order_by_big_key_diff 14.00 10.71 1.07 11.78 10 order_by_big_key_prefix 12.00 10.68 1.26 11.94 10 order_by_key2_diff 1.00 0.98 0.11 1.09 500 order_by_key_prefix 1.00 0.54 0.05 0.59 500 order_by_range 1.00 0.49 0.06 0.55 500 outer_join 1.00 0.00 0.00 0.00 10 outer_join_found 1.00 0.00 0.00 0.00 10 outer_join_not_found 2.00 0.00 0.00 0.00 500 outer_join_on_key 1.00 0.00 0.00 0.00 10 prepared_select 20.00 7.65 0.94 8.59 100000 select_1_row 10.00 1.45 0.93 2.38 100000 select_1_row_cache 3.00 1.20 1.22 2.42 100000 select_2_rows 11.00 1.33 0.93 2.26 100000 select_big 13.00 10.79 1.20 11.99 80 select_big_str 9.00 1.79 0.65 2.44 10000 select_cache 1.00 0.75 0.10 0.85 10000 select_cache2 34.00 0.80 0.11 0.91 10000 select_column+column 10.00 1.16 1.13 2.29 100000 select_diff_key 0.00 0.05 0.01 0.06 500 select_distinct 1.00 0.77 0.09 0.86 800 select_group 2.00 0.55 0.05 0.60 2911 select_join 0.00 0.22 0.04 0.26 100 select_key 31.00 16.26 3.18 19.44 200000 select_key2 34.00 16.60 3.05 19.65 200000 select_key2_return_key 31.00 15.66 2.72 18.38 200000 select_key2_return_prim 32.00 15.58 3.07 18.65 200000 select_key_prefix 33.00 16.10 3.11 19.21 200000 select_key_prefix_join 2.00 2.18 0.17 2.35 100 select_key_return_key 31.00 16.23 3.16 19.39 200000 select_many_fields 4.00 2.66 0.75 3.41 2000 select_range 5.00 4.31 0.40 4.71 410 select_range_key2 2.00 1.77 0.28 2.05 25010 select_range_prefix 2.00 1.80 0.20 2.00 25010 select_simple 4.00 1.15 1.10 2.25 100000 select_simple_cache 4.00 1.05 1.05 2.10 100000 select_simple_join 1.00 0.28 0.01 0.29 500 update_big 12.00 0.00 0.00 0.00 10 update_of_key 31.00 0.26 0.70 0.96 50000 update_of_key_big 11.00 0.00 0.00 0.00 501 update_of_primary_key_many_keys 96.00 0.01 0.00 0.01 256 update_with_key 44.00 3.43 2.97 6.40 300000 update_with_key_prefix 10.00 2.25 1.18 3.43 100000 wisc_benchmark 2.00 1.18 0.10 1.28 114 TOTALS 1731.00 247.76 52.35 300.11 3375950