Benchmark DBD suite: 2.14 Date of test: 2005-04-18 23:27:23 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=writeback,mballoc,extents 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 829 wallclock secs ( 0.18 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.25 CPU) ATIS: Total time: 126 wallclock secs (32.18 usr 6.83 sys + 0.00 cusr 0.00 csys = 39.01 CPU) big-tables: Total time: 428 wallclock secs (60.57 usr 54.85 sys + 0.00 cusr 0.00 csys = 115.42 CPU) connect: Total time: 466 wallclock secs (284.37 usr 75.02 sys + 0.00 cusr 0.00 csys = 359.39 CPU) create: Total time: 383 wallclock secs ( 2.55 usr 1.29 sys + 0.00 cusr 0.00 csys = 3.84 CPU) insert: Total time: 607 wallclock secs (48.81 usr 10.98 sys + 0.00 cusr 0.00 csys = 59.79 CPU) select: Total time: 492 wallclock secs (35.55 usr 6.75 sys + 0.00 cusr 0.00 csys = 42.30 CPU) wisconsin: Total time: 195 wallclock secs ( 3.34 usr 0.95 sys + 0.00 cusr 0.00 csys = 4.29 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 450.00 0.10 0.03 0.13 992 alter_table_drop 359.00 0.06 0.02 0.08 496 connect 111.00 79.67 13.91 93.58 200000 connect+select_1_row 133.00 80.26 20.89 101.15 200000 connect+select_simple 119.00 84.62 17.93 102.55 200000 count 2.00 0.01 0.01 0.02 100 count_distinct 12.00 0.16 0.02 0.18 1000 count_distinct_2 20.00 0.19 0.02 0.21 1000 count_distinct_big 13.00 6.35 1.36 7.71 120 count_distinct_group 38.00 0.75 0.20 0.95 1000 count_distinct_group_on_key 13.00 0.18 0.04 0.22 1000 count_distinct_group_on_key_parts 38.00 0.82 0.14 0.96 1000 count_distinct_key_prefix 9.00 0.16 0.03 0.19 1000 count_group_on_key_parts 11.00 0.82 0.11 0.93 1000 count_on_key 84.00 6.84 1.16 8.00 50100 create+drop 125.00 0.72 0.34 1.06 10000 create_MANY_tables 63.00 0.50 0.15 0.65 10000 create_index 8.00 0.00 0.00 0.00 8 create_key+drop 128.00 0.93 0.37 1.30 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 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.02 0.02 0.04 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 65.00 0.17 0.15 0.32 10000 insert 496.00 1.40 1.15 2.55 80768 insert_duplicates 1.00 0.19 0.12 0.31 10000 insert_key 62.00 0.34 0.16 0.50 10000 insert_many_fields 277.00 3.01 0.79 3.80 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 11.55 1.76 13.31 85000 multiple_value_insert 0.00 0.03 0.00 0.03 10000 order_by_big 3.00 1.69 0.39 2.08 10 order_by_big_key 2.00 1.75 0.39 2.14 10 order_by_big_key2 2.00 1.70 0.41 2.11 10 order_by_big_key_desc 2.00 1.74 0.42 2.16 10 order_by_big_key_diff 2.00 1.67 0.41 2.08 10 order_by_big_key_prefix 2.00 1.68 0.42 2.10 10 order_by_key2_diff 2.00 1.47 0.35 1.82 500 order_by_key_prefix 1.00 0.80 0.17 0.97 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.01 0.00 0.01 10 outer_join_not_found 1.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 4.11 4.40 8.51 200000 select_2_rows 16.00 3.57 4.57 8.14 200000 select_big 3.00 1.78 0.44 2.22 80 select_big_str 44.00 26.38 6.11 32.49 200000 select_column+column 17.00 2.56 3.83 6.39 200000 select_diff_key 9.00 0.10 0.01 0.11 500 select_distinct 18.00 6.43 1.31 7.74 4000 select_group 22.00 4.31 0.75 5.06 14111 select_group_when_MANY_tables 2.00 0.23 0.28 0.51 10000 select_join 3.00 2.05 0.39 2.44 500 select_key 4.00 2.81 0.48 3.29 20000 select_key2 5.00 2.72 0.57 3.29 20000 select_key2_return_key 5.00 2.62 0.50 3.12 20000 select_key2_return_prim 4.00 2.75 0.48 3.23 20000 select_key_prefix 5.00 2.72 0.57 3.29 20000 select_key_prefix_join 24.00 17.02 3.76 20.78 500 select_key_return_key 4.00 2.73 0.49 3.22 20000 select_many_fields 151.00 57.56 54.06 111.62 40000 select_query_cache 57.00 1.35 0.24 1.59 10000 select_query_cache2 56.00 1.27 0.25 1.52 10000 select_range 42.00 7.12 1.49 8.61 410 select_range_key2 7.00 2.99 0.53 3.52 25010 select_range_prefix 6.00 2.94 0.54 3.48 25010 select_simple 11.00 3.20 3.38 6.58 200000 select_simple_join 4.00 2.22 0.48 2.70 2500 update_big 4.00 0.00 0.00 0.00 10 update_of_key 31.00 0.08 0.07 0.15 5000 update_of_key_big 15.00 0.02 0.00 0.02 480 update_of_primary_key_many_keys 4.00 0.01 0.01 0.02 256 update_with_key 184.00 0.51 0.42 0.93 30000 update_with_key_prefix 1.00 0.14 0.19 0.33 10000 wisc_benchmark 5.00 2.78 0.51 3.29 214 TOTALS 3497.00 460.22 155.13 615.35 2246526