Benchmark DBD suite: 2.14 Date of test: 2005-04-18 20:25:42 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=ordered,mballoc,extents 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 858 wallclock secs ( 0.17 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.24 CPU) ATIS: Total time: 125 wallclock secs (31.45 usr 6.89 sys + 0.00 cusr 0.00 csys = 38.34 CPU) big-tables: Total time: 430 wallclock secs (60.51 usr 54.87 sys + 0.00 cusr 0.00 csys = 115.38 CPU) connect: Total time: 463 wallclock secs (282.47 usr 74.23 sys + 0.00 cusr 0.00 csys = 356.70 CPU) create: Total time: 390 wallclock secs ( 2.74 usr 1.34 sys + 0.00 cusr 0.00 csys = 4.08 CPU) insert: Total time: 608 wallclock secs (47.88 usr 11.01 sys + 0.00 cusr 0.00 csys = 58.89 CPU) select: Total time: 486 wallclock secs (34.44 usr 7.02 sys + 0.00 cusr 0.00 csys = 41.46 CPU) wisconsin: Total time: 195 wallclock secs ( 3.26 usr 0.96 sys + 0.00 cusr 0.00 csys = 4.22 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 466.00 0.10 0.03 0.13 992 alter_table_drop 372.00 0.06 0.02 0.08 496 connect 111.00 80.18 13.20 93.38 200000 connect+select_1_row 131.00 79.67 20.92 100.59 200000 connect+select_simple 118.00 84.26 17.00 101.26 200000 count 2.00 0.02 0.00 0.02 100 count_distinct 12.00 0.15 0.02 0.17 1000 count_distinct_2 20.00 0.18 0.04 0.22 1000 count_distinct_big 13.00 6.10 1.37 7.47 120 count_distinct_group 38.00 0.75 0.17 0.92 1000 count_distinct_group_on_key 12.00 0.19 0.03 0.22 1000 count_distinct_group_on_key_parts 39.00 0.77 0.16 0.93 1000 count_distinct_key_prefix 9.00 0.10 0.02 0.12 1000 count_group_on_key_parts 11.00 0.73 0.17 0.90 1000 count_on_key 83.00 6.55 1.26 7.81 50100 create+drop 128.00 0.75 0.35 1.10 10000 create_MANY_tables 67.00 0.60 0.19 0.79 10000 create_index 8.00 0.00 0.00 0.00 8 create_key+drop 130.00 0.97 0.39 1.36 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.01 0.01 1 delete_big 0.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.01 0.02 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 64.00 0.18 0.18 0.36 10000 insert 496.00 1.32 1.17 2.49 80768 insert_duplicates 1.00 0.18 0.16 0.34 10000 insert_key 62.00 0.33 0.19 0.52 10000 insert_many_fields 279.00 2.94 0.90 3.84 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.01 0.01 0.02 60 min_max_on_key 42.00 10.91 1.95 12.86 85000 multiple_value_insert 0.00 0.03 0.00 0.03 10000 order_by_big 2.00 1.66 0.40 2.06 10 order_by_big_key 2.00 1.70 0.41 2.11 10 order_by_big_key2 2.00 1.69 0.39 2.08 10 order_by_big_key_desc 2.00 1.76 0.40 2.16 10 order_by_big_key_diff 3.00 1.68 0.39 2.07 10 order_by_big_key_prefix 2.00 1.62 0.42 2.04 10 order_by_key2_diff 2.00 1.48 0.34 1.82 500 order_by_key_prefix 1.00 0.78 0.18 0.96 500 order_by_range 2.00 0.78 0.19 0.97 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.01 0.00 0.01 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 select_1_row 15.00 3.71 4.68 8.39 200000 select_2_rows 16.00 3.35 4.75 8.10 200000 select_big 3.00 1.77 0.43 2.20 80 select_big_str 44.00 25.74 5.95 31.69 200000 select_column+column 17.00 2.49 3.94 6.43 200000 select_diff_key 9.00 0.09 0.01 0.10 500 select_distinct 18.00 6.13 1.33 7.46 4000 select_group 21.00 4.33 0.81 5.14 14111 select_group_when_MANY_tables 1.00 0.23 0.23 0.46 10000 select_join 2.00 2.04 0.39 2.43 500 select_key 4.00 2.73 0.51 3.24 20000 select_key2 5.00 2.73 0.57 3.30 20000 select_key2_return_key 5.00 2.59 0.39 2.98 20000 select_key2_return_prim 4.00 2.66 0.48 3.14 20000 select_key_prefix 5.00 2.75 0.57 3.32 20000 select_key_prefix_join 25.00 16.66 3.76 20.42 500 select_key_return_key 4.00 2.62 0.50 3.12 20000 select_many_fields 150.00 57.57 53.97 111.54 40000 select_query_cache 56.00 1.34 0.25 1.59 10000 select_query_cache2 56.00 1.38 0.22 1.60 10000 select_range 38.00 6.80 1.52 8.32 410 select_range_key2 7.00 2.99 0.57 3.56 25010 select_range_prefix 6.00 3.01 0.49 3.50 25010 select_simple 11.00 3.07 3.79 6.86 200000 select_simple_join 4.00 2.13 0.46 2.59 2500 update_big 3.00 0.00 0.00 0.00 10 update_of_key 31.00 0.08 0.07 0.15 5000 update_of_key_big 16.00 0.01 0.02 0.03 480 update_of_primary_key_many_keys 4.00 0.01 0.00 0.01 256 update_with_key 184.00 0.49 0.46 0.95 30000 update_with_key_prefix 1.00 0.10 0.15 0.25 10000 wisc_benchmark 5.00 2.78 0.51 3.29 214 TOTALS 3525.00 455.58 154.82 610.40 2246526