Benchmark DBD suite: 2.14 Date of test: 2005-04-18 19:24:51 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=ordered,extents 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 852 wallclock secs ( 0.18 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.25 CPU) ATIS: Total time: 125 wallclock secs (31.26 usr 6.88 sys + 0.00 cusr 0.00 csys = 38.14 CPU) big-tables: Total time: 431 wallclock secs (60.53 usr 55.50 sys + 0.00 cusr 0.00 csys = 116.03 CPU) connect: Total time: 460 wallclock secs (272.95 usr 76.36 sys + 0.00 cusr 0.00 csys = 349.31 CPU) create: Total time: 389 wallclock secs ( 2.69 usr 1.25 sys + 0.00 cusr 0.00 csys = 3.94 CPU) insert: Total time: 607 wallclock secs (47.20 usr 11.20 sys + 0.00 cusr 0.00 csys = 58.40 CPU) select: Total time: 481 wallclock secs (33.92 usr 6.77 sys + 0.00 cusr 0.00 csys = 40.69 CPU) wisconsin: Total time: 194 wallclock secs ( 3.23 usr 0.98 sys + 0.00 cusr 0.00 csys = 4.21 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 463.00 0.10 0.03 0.13 992 alter_table_drop 369.00 0.06 0.02 0.08 496 connect 109.00 79.70 13.13 92.83 200000 connect+select_1_row 132.00 72.15 24.08 96.23 200000 connect+select_simple 117.00 83.72 16.93 100.65 200000 count 2.00 0.01 0.00 0.01 100 count_distinct 12.00 0.15 0.02 0.17 1000 count_distinct_2 20.00 0.14 0.02 0.16 1000 count_distinct_big 13.00 6.03 1.35 7.38 120 count_distinct_group 38.00 0.75 0.16 0.91 1000 count_distinct_group_on_key 12.00 0.19 0.03 0.22 1000 count_distinct_group_on_key_parts 38.00 0.73 0.19 0.92 1000 count_distinct_key_prefix 9.00 0.09 0.01 0.10 1000 count_group_on_key_parts 11.00 0.71 0.15 0.86 1000 count_on_key 81.00 6.37 1.13 7.50 50100 create+drop 127.00 0.78 0.35 1.13 10000 create_MANY_tables 66.00 0.53 0.18 0.71 10000 create_index 7.00 0.00 0.00 0.00 8 create_key+drop 130.00 1.04 0.36 1.40 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 3.00 0.01 0.01 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 3.00 0.01 0.01 0.02 128 delete_key 3.00 0.01 0.02 0.03 1000 drop_index 7.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 64.00 0.18 0.16 0.34 10000 insert 494.00 1.32 1.14 2.46 80768 insert_duplicates 1.00 0.11 0.15 0.26 10000 insert_key 62.00 0.35 0.15 0.50 10000 insert_many_fields 279.00 2.88 0.79 3.67 40000 insert_select_1_key 0.00 0.00 0.00 0.00 1 insert_select_2_keys 1.00 0.00 0.00 0.00 1 min_max 1.00 0.00 0.00 0.00 60 min_max_on_key 41.00 10.62 1.96 12.58 85000 multiple_value_insert 1.00 0.03 0.00 0.03 10000 order_by_big 3.00 1.59 0.41 2.00 10 order_by_big_key 2.00 1.65 0.40 2.05 10 order_by_big_key2 2.00 1.62 0.42 2.04 10 order_by_big_key_desc 2.00 1.66 0.40 2.06 10 order_by_big_key_diff 2.00 1.59 0.40 1.99 10 order_by_big_key_prefix 2.00 1.58 0.40 1.98 10 order_by_key2_diff 2.00 1.47 0.32 1.79 500 order_by_key_prefix 1.00 0.78 0.17 0.95 500 order_by_range 2.00 0.75 0.17 0.92 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.01 0.01 10 select_1_row 15.00 3.48 4.47 7.95 200000 select_2_rows 16.00 3.29 4.47 7.76 200000 select_big 2.00 1.67 0.44 2.11 80 select_big_str 43.00 25.35 5.74 31.09 200000 select_column+column 17.00 2.47 3.75 6.22 200000 select_diff_key 8.00 0.09 0.01 0.10 500 select_distinct 17.00 6.29 1.33 7.62 4000 select_group 22.00 4.34 0.81 5.15 14111 select_group_when_MANY_tables 2.00 0.16 0.20 0.36 10000 select_join 3.00 1.98 0.40 2.38 500 select_key 5.00 2.74 0.48 3.22 20000 select_key2 5.00 2.81 0.56 3.37 20000 select_key2_return_key 4.00 2.81 0.42 3.23 20000 select_key2_return_prim 5.00 2.72 0.45 3.17 20000 select_key_prefix 4.00 2.75 0.54 3.29 20000 select_key_prefix_join 24.00 16.32 3.76 20.08 500 select_key_return_key 4.00 2.57 0.55 3.12 20000 select_many_fields 152.00 57.65 54.71 112.36 40000 select_query_cache 56.00 1.38 0.24 1.62 10000 select_query_cache2 56.00 1.30 0.26 1.56 10000 select_range 38.00 6.84 1.51 8.35 410 select_range_key2 7.00 2.97 0.56 3.53 25010 select_range_prefix 7.00 2.96 0.60 3.56 25010 select_simple 11.00 2.79 3.79 6.58 200000 select_simple_join 4.00 2.17 0.45 2.62 2500 update_big 4.00 0.00 0.00 0.00 10 update_of_key 31.00 0.09 0.09 0.18 5000 update_of_key_big 16.00 0.01 0.01 0.02 480 update_of_primary_key_many_keys 4.00 0.00 0.00 0.00 256 update_with_key 183.00 0.46 0.47 0.93 30000 update_with_key_prefix 1.00 0.12 0.15 0.27 10000 wisc_benchmark 4.00 2.76 0.54 3.30 214 TOTALS 3511.00 444.80 157.39 602.19 2246526