Benchmark DBD suite: 2.14 Date of test: 2005-04-19 4:14:48 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: jfs defaults 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 1502 wallclock secs ( 0.25 usr 0.08 sys + 0.00 cusr 0.00 csys = 0.33 CPU) ATIS: Total time: 268 wallclock secs (31.56 usr 7.22 sys + 0.00 cusr 0.00 csys = 38.78 CPU) big-tables: Total time: 1396 wallclock secs (63.05 usr 56.38 sys + 0.00 cusr 0.00 csys = 119.43 CPU) connect: Total time: 464 wallclock secs (282.70 usr 74.89 sys + 0.00 cusr 0.00 csys = 357.59 CPU) create: Total time: 1715 wallclock secs ( 6.56 usr 1.87 sys + 0.00 cusr 0.00 csys = 8.43 CPU) insert: Total time: 1773 wallclock secs (51.33 usr 11.91 sys + 0.00 cusr 0.00 csys = 63.24 CPU) select: Total time: 635 wallclock secs (34.61 usr 7.02 sys + 0.00 cusr 0.00 csys = 41.63 CPU) wisconsin: Total time: 661 wallclock secs ( 4.32 usr 1.24 sys + 0.00 cusr 0.00 csys = 5.56 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 829.00 0.13 0.03 0.16 992 alter_table_drop 630.00 0.08 0.02 0.10 496 connect 110.00 80.39 13.36 93.75 200000 connect+select_1_row 132.00 77.63 21.66 99.29 200000 connect+select_simple 118.00 85.13 16.27 101.40 200000 count 2.00 0.01 0.00 0.01 100 count_distinct 12.00 0.14 0.03 0.17 1000 count_distinct_2 22.00 0.18 0.03 0.21 1000 count_distinct_big 13.00 6.02 1.37 7.39 120 count_distinct_group 38.00 0.76 0.17 0.93 1000 count_distinct_group_on_key 13.00 0.18 0.04 0.22 1000 count_distinct_group_on_key_parts 39.00 0.77 0.17 0.94 1000 count_distinct_key_prefix 9.00 0.11 0.02 0.13 1000 count_group_on_key_parts 11.00 0.71 0.17 0.88 1000 count_on_key 85.00 6.63 1.15 7.78 50100 create+drop 554.00 2.13 0.57 2.70 10000 create_MANY_tables 306.00 1.20 0.30 1.50 10000 create_index 11.00 0.00 0.00 0.00 8 create_key+drop 548.00 2.51 0.54 3.05 10000 create_table 1.00 0.00 0.00 0.00 31 delete_all 1.00 0.00 0.00 0.00 12 delete_all_many_keys 5.00 0.00 0.01 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 5.00 0.00 0.01 0.01 128 delete_key 10.00 0.03 0.02 0.05 1000 drop_index 11.00 0.00 0.00 0.00 8 drop_table 1.00 0.01 0.00 0.01 28 drop_table_when_MANY_tables 305.00 0.54 0.27 0.81 10000 insert 1686.00 4.01 1.93 5.94 80768 insert_duplicates 1.00 0.16 0.17 0.33 10000 insert_key 229.00 0.82 0.28 1.10 10000 insert_many_fields 1243.00 4.58 1.09 5.67 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 0.00 0.01 0.00 0.01 60 min_max_on_key 43.00 10.90 1.99 12.89 85000 multiple_value_insert 0.00 0.03 0.00 0.03 10000 order_by_big 2.00 1.64 0.39 2.03 10 order_by_big_key 2.00 1.67 0.42 2.09 10 order_by_big_key2 2.00 1.65 0.41 2.06 10 order_by_big_key_desc 2.00 1.71 0.42 2.13 10 order_by_big_key_diff 3.00 1.60 0.41 2.01 10 order_by_big_key_prefix 2.00 1.61 0.42 2.03 10 order_by_key2_diff 2.00 1.46 0.34 1.80 500 order_by_key_prefix 1.00 0.76 0.19 0.95 500 order_by_range 2.00 0.77 0.17 0.94 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 16.00 3.76 4.80 8.56 200000 select_2_rows 16.00 3.66 4.84 8.50 200000 select_big 2.00 1.72 0.44 2.16 80 select_big_str 45.00 26.17 6.17 32.34 200000 select_column+column 17.00 3.07 4.17 7.24 200000 select_diff_key 9.00 0.09 0.01 0.10 500 select_distinct 18.00 6.21 1.35 7.56 4000 select_group 21.00 4.26 0.82 5.08 14111 select_group_when_MANY_tables 2.00 0.18 0.19 0.37 10000 select_join 3.00 1.98 0.41 2.39 500 select_key 5.00 2.81 0.52 3.33 20000 select_key2 5.00 2.69 0.55 3.24 20000 select_key2_return_key 4.00 2.87 0.43 3.30 20000 select_key2_return_prim 5.00 2.72 0.49 3.21 20000 select_key_prefix 5.00 2.84 0.54 3.38 20000 select_key_prefix_join 24.00 16.42 3.92 20.34 500 select_key_return_key 4.00 2.81 0.42 3.23 20000 select_many_fields 153.00 58.47 55.29 113.76 40000 select_query_cache 55.00 1.35 0.25 1.60 10000 select_query_cache2 54.00 1.34 0.23 1.57 10000 select_range 41.00 6.72 1.50 8.22 410 select_range_key2 7.00 3.09 0.56 3.65 25010 select_range_prefix 6.00 3.13 0.57 3.70 25010 select_simple 10.00 2.88 3.62 6.50 200000 select_simple_join 4.00 2.16 0.47 2.63 2500 update_big 4.00 0.01 0.00 0.01 10 update_of_key 107.00 0.30 0.13 0.43 5000 update_of_key_big 23.00 0.03 0.02 0.05 480 update_of_primary_key_many_keys 8.00 0.02 0.00 0.02 256 update_with_key 629.00 1.56 0.78 2.34 30000 update_with_key_prefix 1.00 0.16 0.14 0.30 10000 wisc_benchmark 4.00 2.84 0.50 3.34 214 TOTALS 8356.00 467.00 158.97 625.97 2246526