Benchmark DBD suite: 2.14 Date of test: 2005-04-19 1:27:39 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: reiserfs defaults 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 830 wallclock secs ( 0.18 usr 0.06 sys + 0.00 cusr 0.00 csys = 0.24 CPU) ATIS: Total time: 124 wallclock secs (31.29 usr 7.25 sys + 0.00 cusr 0.00 csys = 38.54 CPU) big-tables: Total time: 426 wallclock secs (61.44 usr 54.81 sys + 0.00 cusr 0.00 csys = 116.25 CPU) connect: Total time: 464 wallclock secs (276.36 usr 74.98 sys + 0.00 cusr 0.00 csys = 351.34 CPU) create: Total time: 378 wallclock secs ( 2.48 usr 1.26 sys + 0.00 cusr 0.00 csys = 3.74 CPU) insert: Total time: 600 wallclock secs (48.03 usr 10.89 sys + 0.00 cusr 0.00 csys = 58.92 CPU) select: Total time: 475 wallclock secs (34.93 usr 6.66 sys + 0.00 cusr 0.00 csys = 41.59 CPU) wisconsin: Total time: 191 wallclock secs ( 3.35 usr 1.01 sys + 0.00 cusr 0.00 csys = 4.36 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 361.00 0.06 0.02 0.08 496 connect 110.00 80.07 12.83 92.90 200000 connect+select_1_row 133.00 72.46 23.15 95.61 200000 connect+select_simple 119.00 84.88 16.87 101.75 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.15 0.02 0.17 1000 count_distinct_big 12.00 6.40 1.33 7.73 120 count_distinct_group 38.00 0.80 0.15 0.95 1000 count_distinct_group_on_key 12.00 0.18 0.04 0.22 1000 count_distinct_group_on_key_parts 38.00 0.79 0.14 0.93 1000 count_distinct_key_prefix 9.00 0.13 0.02 0.15 1000 count_group_on_key_parts 10.00 0.79 0.14 0.93 1000 count_on_key 83.00 6.44 1.18 7.62 50100 create+drop 124.00 0.73 0.35 1.08 10000 create_MANY_tables 64.00 0.53 0.15 0.68 10000 create_index 7.00 0.00 0.00 0.00 8 create_key+drop 126.00 0.91 0.38 1.29 10000 create_table 0.00 0.01 0.00 0.01 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.01 0.02 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 62.00 0.13 0.15 0.28 10000 insert 487.00 1.32 1.23 2.55 80768 insert_duplicates 1.00 0.22 0.10 0.32 10000 insert_key 61.00 0.30 0.15 0.45 10000 insert_many_fields 274.00 2.80 0.79 3.59 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 1.00 0.01 0.00 0.01 60 min_max_on_key 41.00 11.02 1.85 12.87 85000 multiple_value_insert 0.00 0.03 0.00 0.03 10000 order_by_big 3.00 1.66 0.39 2.05 10 order_by_big_key 2.00 1.67 0.41 2.08 10 order_by_big_key2 2.00 1.69 0.40 2.09 10 order_by_big_key_desc 2.00 1.73 0.41 2.14 10 order_by_big_key_diff 2.00 1.65 0.38 2.03 10 order_by_big_key_prefix 2.00 1.64 0.41 2.05 10 order_by_key2_diff 2.00 1.45 0.35 1.80 500 order_by_key_prefix 1.00 0.79 0.18 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.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.00 0.00 10 select_1_row 15.00 3.57 4.17 7.74 200000 select_2_rows 16.00 3.80 4.41 8.21 200000 select_big 2.00 1.76 0.43 2.19 80 select_big_str 44.00 26.07 6.05 32.12 200000 select_column+column 17.00 2.47 3.72 6.19 200000 select_diff_key 9.00 0.08 0.02 0.10 500 select_distinct 18.00 6.22 1.39 7.61 4000 select_group 22.00 4.23 0.84 5.07 14111 select_group_when_MANY_tables 2.00 0.17 0.23 0.40 10000 select_join 3.00 2.00 0.43 2.43 500 select_key 4.00 2.77 0.51 3.28 20000 select_key2 5.00 2.73 0.54 3.27 20000 select_key2_return_key 4.00 2.60 0.43 3.03 20000 select_key2_return_prim 5.00 2.75 0.47 3.22 20000 select_key_prefix 5.00 2.72 0.51 3.23 20000 select_key_prefix_join 24.00 16.55 3.97 20.52 500 select_key_return_key 4.00 2.74 0.44 3.18 20000 select_many_fields 152.00 58.64 54.02 112.66 40000 select_query_cache 54.00 1.30 0.24 1.54 10000 select_query_cache2 54.00 1.37 0.25 1.62 10000 select_range 38.00 7.12 1.40 8.52 410 select_range_key2 7.00 2.92 0.59 3.51 25010 select_range_prefix 6.00 2.92 0.54 3.46 25010 select_simple 10.00 3.04 3.78 6.82 200000 select_simple_join 3.00 2.14 0.48 2.62 2500 update_big 4.00 0.00 0.00 0.00 10 update_of_key 30.00 0.11 0.08 0.19 5000 update_of_key_big 17.00 0.01 0.01 0.02 480 update_of_primary_key_many_keys 4.00 0.01 0.00 0.01 256 update_with_key 180.00 0.51 0.48 0.99 30000 update_with_key_prefix 1.00 0.12 0.12 0.24 10000 wisc_benchmark 4.00 2.82 0.52 3.34 214 TOTALS 3459.00 450.74 155.29 606.03 2246526