Benchmark DBD suite: 2.14 Date of test: 2005-04-18 21:26:44 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=ordered,mballoc,delalloc,extents 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 818 wallclock secs ( 0.20 usr 0.05 sys + 0.00 cusr 0.00 csys = 0.25 CPU) ATIS: Total time: 125 wallclock secs (31.03 usr 6.82 sys + 0.00 cusr 0.00 csys = 37.85 CPU) big-tables: Total time: 429 wallclock secs (60.40 usr 55.14 sys + 0.00 cusr 0.00 csys = 115.54 CPU) connect: Total time: 463 wallclock secs (276.38 usr 77.83 sys + 0.00 cusr 0.00 csys = 354.21 CPU) create: Total time: 384 wallclock secs ( 2.63 usr 1.31 sys + 0.00 cusr 0.00 csys = 3.94 CPU) insert: Total time: 607 wallclock secs (47.86 usr 11.20 sys + 0.00 cusr 0.00 csys = 59.06 CPU) select: Total time: 487 wallclock secs (33.94 usr 6.86 sys + 0.00 cusr 0.00 csys = 40.80 CPU) wisconsin: Total time: 195 wallclock secs ( 3.31 usr 1.01 sys + 0.00 cusr 0.00 csys = 4.32 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 445.00 0.11 0.02 0.13 992 alter_table_drop 354.00 0.07 0.02 0.09 496 connect 109.00 78.96 13.52 92.48 200000 connect+select_1_row 133.00 74.19 23.81 98.00 200000 connect+select_simple 118.00 83.72 17.39 101.11 200000 count 1.00 0.02 0.00 0.02 100 count_distinct 12.00 0.15 0.02 0.17 1000 count_distinct_2 23.00 0.16 0.03 0.19 1000 count_distinct_big 14.00 6.06 1.36 7.42 120 count_distinct_group 38.00 0.75 0.18 0.93 1000 count_distinct_group_on_key 12.00 0.18 0.03 0.21 1000 count_distinct_group_on_key_parts 39.00 0.75 0.18 0.93 1000 count_distinct_key_prefix 9.00 0.08 0.01 0.09 1000 count_group_on_key_parts 11.00 0.76 0.16 0.92 1000 count_on_key 85.00 6.44 1.14 7.58 50100 create+drop 125.00 0.75 0.34 1.09 10000 create_MANY_tables 64.00 0.55 0.18 0.73 10000 create_index 7.00 0.00 0.00 0.00 8 create_key+drop 127.00 1.02 0.41 1.43 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all 1.00 0.00 0.00 0.00 12 delete_all_many_keys 2.00 0.00 0.00 0.00 1 delete_big 1.00 0.00 0.00 0.00 1 delete_big_many_keys 2.00 0.00 0.00 0.00 128 delete_key 3.00 0.01 0.02 0.03 1000 drop_index 6.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 66.00 0.15 0.17 0.32 10000 insert 496.00 1.38 1.19 2.57 80768 insert_duplicates 0.00 0.20 0.12 0.32 10000 insert_key 62.00 0.32 0.16 0.48 10000 insert_many_fields 278.00 2.97 0.78 3.75 40000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 0.00 0.00 0.00 0.00 1 min_max 1.00 0.01 0.00 0.01 60 min_max_on_key 42.00 11.28 1.84 13.12 85000 multiple_value_insert 0.00 0.02 0.00 0.02 10000 order_by_big 2.00 1.63 0.41 2.04 10 order_by_big_key 2.00 1.62 0.43 2.05 10 order_by_big_key2 2.00 1.63 0.41 2.04 10 order_by_big_key_desc 3.00 1.68 0.41 2.09 10 order_by_big_key_diff 2.00 1.63 0.40 2.03 10 order_by_big_key_prefix 2.00 1.58 0.42 2.00 10 order_by_key2_diff 2.00 1.46 0.34 1.80 500 order_by_key_prefix 1.00 0.75 0.18 0.93 500 order_by_range 2.00 0.77 0.18 0.95 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.01 0.00 0.01 10 select_1_row 15.00 3.73 4.68 8.41 200000 select_2_rows 16.00 3.62 4.55 8.17 200000 select_big 2.00 1.71 0.43 2.14 80 select_big_str 44.00 26.09 5.66 31.75 200000 select_column+column 17.00 3.04 4.22 7.26 200000 select_diff_key 9.00 0.07 0.01 0.08 500 select_distinct 18.00 6.29 1.29 7.58 4000 select_group 22.00 4.22 0.85 5.07 14111 select_group_when_MANY_tables 2.00 0.16 0.21 0.37 10000 select_join 3.00 1.87 0.39 2.26 500 select_key 4.00 2.75 0.60 3.35 20000 select_key2 4.00 2.62 0.55 3.17 20000 select_key2_return_key 5.00 2.74 0.43 3.17 20000 select_key2_return_prim 5.00 2.77 0.49 3.26 20000 select_key_prefix 5.00 2.69 0.54 3.23 20000 select_key_prefix_join 23.00 16.29 3.71 20.00 500 select_key_return_key 5.00 2.67 0.48 3.15 20000 select_many_fields 151.00 57.43 54.36 111.79 40000 select_query_cache 54.00 1.32 0.26 1.58 10000 select_query_cache2 54.00 1.24 0.24 1.48 10000 select_range 39.00 6.80 1.52 8.32 410 select_range_key2 7.00 2.90 0.55 3.45 25010 select_range_prefix 6.00 2.96 0.60 3.56 25010 select_simple 11.00 3.03 4.00 7.03 200000 select_simple_join 4.00 2.18 0.46 2.64 2500 update_big 4.00 0.00 0.00 0.00 10 update_of_key 30.00 0.06 0.07 0.13 5000 update_of_key_big 17.00 0.02 0.01 0.03 480 update_of_primary_key_many_keys 4.00 0.01 0.01 0.02 256 update_with_key 183.00 0.48 0.48 0.96 30000 update_with_key_prefix 1.00 0.13 0.13 0.26 10000 wisc_benchmark 4.00 2.77 0.51 3.28 214 TOTALS 3479.00 448.48 158.55 607.03 2246526