Benchmark DBD suite: 2.15 Date of test: 2006-03-05 12:41:50 Running tests on: Linux 2.6.8-022stab068.1-enterprise i686 Arguments: Comments: Limits from: Server version: MySQL 4.1.15 Debian_1 log Optimization: None Hardware: alter-table: Total time: 19 wallclock secs ( 0.05 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.08 CPU) ATIS: Total time: 14 wallclock secs ( 6.88 usr 4.38 sys + 0.00 cusr 0.00 csys = 11.26 CPU) big-tables: Total time: 18 wallclock secs ( 6.27 usr 8.63 sys + 0.00 cusr 0.00 csys = 14.90 CPU) connect: Total time: 147 wallclock secs (37.30 usr 37.23 sys + 0.00 cusr 0.00 csys = 74.53 CPU) create: Total time: 692 wallclock secs ( 3.50 usr 2.10 sys + 0.00 cusr 0.00 csys = 5.60 CPU) insert: Total time: 1144 wallclock secs (357.57 usr 207.43 sys + 0.00 cusr 0.00 csys = 565.00 CPU) select: Total time: 88 wallclock secs (35.62 usr 17.58 sys + 0.00 cusr 0.00 csys = 53.20 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 10 wallclock secs ( 2.25 usr 1.41 sys + 0.00 cusr 0.00 csys = 3.66 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 8.00 0.02 0.01 0.03 100 alter_table_drop 8.00 0.01 0.00 0.01 91 connect 9.00 3.21 0.70 3.91 10000 connect+select_1_row 10.00 3.28 1.27 4.55 10000 connect+select_simple 10.00 3.16 1.28 4.44 10000 count 9.00 0.02 0.01 0.03 100 count_distinct 0.00 0.15 0.04 0.19 1000 count_distinct_2 0.00 0.15 0.05 0.20 1000 count_distinct_big 11.00 6.10 4.27 10.37 120 count_distinct_group 2.00 0.75 0.47 1.22 1000 count_distinct_group_on_key 1.00 0.20 0.10 0.30 1000 count_distinct_group_on_key_parts 1.00 0.95 0.50 1.45 1000 count_distinct_key_prefix 0.00 0.14 0.05 0.19 1000 count_group_on_key_parts 2.00 0.75 0.46 1.21 1000 count_on_key 21.00 6.77 2.35 9.12 50100 create+drop 224.00 0.98 0.57 1.55 10000 create_MANY_tables 236.00 0.81 0.34 1.15 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 224.00 1.11 0.52 1.63 10000 create_table 1.00 0.00 0.01 0.01 31 delete_all_many_keys 23.00 0.01 0.01 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 23.00 0.01 0.01 0.02 128 delete_key 2.00 0.23 0.25 0.48 10000 delete_range 5.00 0.00 0.01 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 5.00 0.18 0.21 0.39 10000 insert 82.00 8.21 8.47 16.68 350768 insert_duplicates 22.00 2.67 2.08 4.75 100000 insert_key 49.00 4.27 2.91 7.18 100000 insert_many_fields 3.00 0.14 0.05 0.19 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 4.00 0.01 0.01 0.02 60 min_max_on_key 20.00 11.81 3.81 15.62 85000 multiple_value_insert 2.00 0.26 0.03 0.29 100000 once_prepared_select 30.00 7.18 6.12 13.30 100000 order_by_big 35.00 17.33 13.01 30.34 10 order_by_big_key 32.00 18.25 13.35 31.60 10 order_by_big_key2 31.00 17.22 13.12 30.34 10 order_by_big_key_desc 31.00 18.22 13.36 31.58 10 order_by_big_key_diff 33.00 17.24 13.06 30.30 10 order_by_big_key_prefix 31.00 17.64 13.17 30.81 10 order_by_key2_diff 5.00 1.48 1.12 2.60 500 order_by_key_prefix 2.00 0.81 0.55 1.36 500 order_by_range 2.00 0.79 0.56 1.35 500 outer_join 3.00 0.01 0.00 0.01 10 outer_join_found 3.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 38.00 13.85 6.40 20.25 100000 select_1_row 22.00 4.75 6.16 10.91 100000 select_1_row_cache 14.00 4.17 5.46 9.63 100000 select_2_rows 24.00 5.21 7.04 12.25 100000 select_big 31.00 17.31 13.37 30.68 80 select_big_str 6.00 2.26 1.09 3.35 10000 select_cache 3.00 1.28 0.55 1.83 10000 select_cache2 27.00 1.45 0.62 2.07 10000 select_column+column 23.00 4.18 5.34 9.52 100000 select_diff_key 48.00 0.12 0.04 0.16 500 select_distinct 2.00 1.34 0.78 2.12 800 select_group 3.00 0.90 0.48 1.38 2911 select_group_when_MANY_tables 3.00 0.42 0.46 0.88 10000 select_join 1.00 0.36 0.27 0.63 100 select_key 69.00 30.41 12.20 42.61 200000 select_key2 70.00 28.70 12.00 40.70 200000 select_key2_return_key 70.00 24.80 9.68 34.48 200000 select_key2_return_prim 69.00 28.22 10.08 38.30 200000 select_key_prefix 71.00 28.41 11.95 40.36 200000 select_key_prefix_join 6.00 3.54 2.32 5.86 100 select_key_return_key 67.00 27.07 11.01 38.08 200000 select_many_fields 15.00 6.13 8.58 14.71 2000 select_range 12.00 6.84 4.68 11.52 410 select_range_key2 5.00 3.00 1.41 4.41 25010 select_range_prefix 5.00 3.04 1.42 4.46 25010 select_simple 14.00 3.58 4.48 8.06 100000 select_simple_cache 15.00 3.50 4.41 7.91 100000 select_simple_join 0.00 0.47 0.27 0.74 500 update_big 23.00 0.00 0.00 0.00 10 update_of_key 13.00 1.36 1.32 2.68 50000 update_of_key_big 9.00 0.01 0.01 0.02 501 update_of_primary_key_many_keys 15.00 0.00 0.00 0.00 256 update_with_key 64.00 7.06 7.88 14.94 300000 update_with_key_prefix 18.00 4.09 3.10 7.19 100000 wisc_benchmark 2.00 1.62 0.78 2.40 114 TOTALS 2142.00 441.98 273.91 715.89 3425950