Benchmark DBD suite: 2.14 Date of test: 2005-04-18 16:22:00 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext2 defaults 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 833 wallclock secs ( 0.17 usr 0.05 sys + 0.00 cusr 0.00 csys = 0.22 CPU) ATIS: Total time: 124 wallclock secs (31.10 usr 7.01 sys + 0.00 cusr 0.00 csys = 38.11 CPU) big-tables: Total time: 430 wallclock secs (60.69 usr 58.66 sys + 0.00 cusr 0.00 csys = 119.35 CPU) connect: Total time: 467 wallclock secs (290.94 usr 74.70 sys + 0.00 cusr 0.00 csys = 365.64 CPU) create: Total time: 383 wallclock secs ( 2.50 usr 1.24 sys + 0.00 cusr 0.00 csys = 3.74 CPU) insert: Total time: 603 wallclock secs (48.57 usr 11.28 sys + 0.00 cusr 0.00 csys = 59.85 CPU) select: Total time: 483 wallclock secs (33.82 usr 6.88 sys + 0.00 cusr 0.00 csys = 40.70 CPU) wisconsin: Total time: 192 wallclock secs ( 3.34 usr 0.96 sys + 0.00 cusr 0.00 csys = 4.30 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 456.00 0.10 0.03 0.13 992 alter_table_drop 358.00 0.05 0.01 0.06 496 connect 110.00 80.73 13.59 94.32 200000 connect+select_1_row 134.00 85.77 19.66 105.43 200000 connect+select_simple 121.00 85.43 17.74 103.17 200000 count 2.00 0.02 0.01 0.03 100 count_distinct 12.00 0.14 0.02 0.16 1000 count_distinct_2 20.00 0.17 0.04 0.21 1000 count_distinct_big 13.00 6.22 1.39 7.61 120 count_distinct_group 39.00 0.76 0.17 0.93 1000 count_distinct_group_on_key 13.00 0.19 0.03 0.22 1000 count_distinct_group_on_key_parts 38.00 0.76 0.17 0.93 1000 count_distinct_key_prefix 9.00 0.08 0.02 0.10 1000 count_group_on_key_parts 11.00 0.75 0.17 0.92 1000 count_on_key 83.00 5.94 1.16 7.10 50100 create+drop 124.00 0.69 0.33 1.02 10000 create_MANY_tables 68.00 0.51 0.15 0.66 10000 create_index 7.00 0.00 0.00 0.00 8 create_key+drop 126.00 0.93 0.38 1.31 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all 0.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 4.00 0.02 0.01 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 63.00 0.20 0.16 0.36 10000 insert 489.00 1.33 1.18 2.51 80768 insert_duplicates 1.00 0.17 0.17 0.34 10000 insert_key 62.00 0.29 0.18 0.47 10000 insert_many_fields 275.00 2.80 0.81 3.61 40000 insert_select_1_key 0.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 41.00 10.88 1.80 12.68 85000 multiple_value_insert 0.00 0.03 0.00 0.03 10000 order_by_big 3.00 1.66 0.41 2.07 10 order_by_big_key 2.00 1.71 0.42 2.13 10 order_by_big_key2 2.00 1.67 0.40 2.07 10 order_by_big_key_desc 3.00 1.74 0.41 2.15 10 order_by_big_key_diff 2.00 1.65 0.40 2.05 10 order_by_big_key_prefix 2.00 1.62 0.41 2.03 10 order_by_key2_diff 3.00 1.50 0.35 1.85 500 order_by_key_prefix 1.00 0.78 0.19 0.97 500 order_by_range 1.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.01 0.00 0.01 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 select_1_row 15.00 3.91 4.77 8.68 200000 select_2_rows 16.00 3.40 4.88 8.28 200000 select_big 2.00 1.75 0.43 2.18 80 select_big_str 44.00 25.71 6.10 31.81 200000 select_column+column 17.00 2.86 4.02 6.88 200000 select_diff_key 8.00 0.08 0.02 0.10 500 select_distinct 17.00 6.27 1.33 7.60 4000 select_group 22.00 4.33 0.82 5.15 14111 select_group_when_MANY_tables 2.00 0.17 0.22 0.39 10000 select_join 3.00 1.95 0.41 2.36 500 select_key 5.00 2.75 0.53 3.28 20000 select_key2 5.00 2.77 0.55 3.32 20000 select_key2_return_key 4.00 2.70 0.47 3.17 20000 select_key2_return_prim 5.00 2.73 0.50 3.23 20000 select_key_prefix 4.00 2.68 0.57 3.25 20000 select_key_prefix_join 24.00 16.29 3.83 20.12 500 select_key_return_key 4.00 2.71 0.47 3.18 20000 select_many_fields 155.00 57.88 57.85 115.73 40000 select_query_cache 55.00 1.39 0.28 1.67 10000 select_query_cache2 55.00 1.38 0.27 1.65 10000 select_range 40.00 6.99 1.48 8.47 410 select_range_key2 7.00 3.07 0.57 3.64 25010 select_range_prefix 7.00 3.00 0.52 3.52 25010 select_simple 10.00 3.12 3.94 7.06 200000 select_simple_join 3.00 2.13 0.48 2.61 2500 update_big 4.00 0.00 0.00 0.00 10 update_of_key 30.00 0.10 0.10 0.20 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 182.00 0.46 0.52 0.98 30000 update_with_key_prefix 0.00 0.12 0.13 0.25 10000 wisc_benchmark 4.00 2.83 0.50 3.33 214 TOTALS 3487.00 463.64 159.14 622.78 2246526