Benchmark DBD suite: 2.14 Date of test: 2005-04-18 17:22:25 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=ordered 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 882 wallclock secs ( 0.24 usr 0.06 sys + 0.00 cusr 0.00 csys = 0.30 CPU) ATIS: Total time: 125 wallclock secs (31.67 usr 6.83 sys + 0.00 cusr 0.00 csys = 38.50 CPU) big-tables: Total time: 432 wallclock secs (60.87 usr 55.05 sys + 0.00 cusr 0.00 csys = 115.92 CPU) connect: Total time: 458 wallclock secs (274.95 usr 73.28 sys + 0.00 cusr 0.00 csys = 348.23 CPU) create: Total time: 390 wallclock secs ( 2.64 usr 1.24 sys + 0.00 cusr 0.00 csys = 3.88 CPU) insert: Total time: 608 wallclock secs (47.37 usr 10.86 sys + 0.00 cusr 0.00 csys = 58.23 CPU) select: Total time: 487 wallclock secs (34.04 usr 6.87 sys + 0.00 cusr 0.00 csys = 40.91 CPU) wisconsin: Total time: 195 wallclock secs ( 3.27 usr 0.95 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 480.00 0.14 0.03 0.17 992 alter_table_drop 383.00 0.08 0.01 0.09 496 connect 109.00 81.41 11.93 93.34 200000 connect+select_1_row 131.00 73.02 21.95 94.97 200000 connect+select_simple 116.00 82.36 16.71 99.07 200000 count 2.00 0.02 0.00 0.02 100 count_distinct 12.00 0.14 0.02 0.16 1000 count_distinct_2 21.00 0.17 0.03 0.20 1000 count_distinct_big 12.00 6.09 1.36 7.45 120 count_distinct_group 39.00 0.78 0.15 0.93 1000 count_distinct_group_on_key 12.00 0.18 0.03 0.21 1000 count_distinct_group_on_key_parts 39.00 0.76 0.16 0.92 1000 count_distinct_key_prefix 9.00 0.11 0.02 0.13 1000 count_group_on_key_parts 11.00 0.70 0.16 0.86 1000 count_on_key 84.00 6.38 1.18 7.56 50100 create+drop 128.00 0.75 0.34 1.09 10000 create_MANY_tables 66.00 0.52 0.18 0.70 10000 create_index 6.00 0.00 0.00 0.00 8 create_key+drop 130.00 1.01 0.37 1.38 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 7.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.21 0.17 0.38 10000 insert 495.00 1.30 1.15 2.45 80768 insert_duplicates 1.00 0.22 0.12 0.34 10000 insert_key 62.00 0.35 0.15 0.50 10000 insert_many_fields 280.00 3.02 0.87 3.89 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 10.83 1.89 12.72 85000 multiple_value_insert 0.00 0.02 0.01 0.03 10000 order_by_big 3.00 1.65 0.40 2.05 10 order_by_big_key 2.00 1.70 0.42 2.12 10 order_by_big_key2 2.00 1.67 0.40 2.07 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.40 2.05 10 order_by_big_key_prefix 3.00 1.64 0.42 2.06 10 order_by_key2_diff 2.00 1.47 0.34 1.81 500 order_by_key_prefix 2.00 0.75 0.19 0.94 500 order_by_range 1.00 0.75 0.18 0.93 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 16.00 3.58 4.70 8.28 200000 select_2_rows 15.00 3.57 4.61 8.18 200000 select_big 3.00 1.75 0.43 2.18 80 select_big_str 43.00 25.38 5.88 31.26 200000 select_column+column 17.00 2.68 3.85 6.53 200000 select_diff_key 8.00 0.08 0.01 0.09 500 select_distinct 18.00 6.27 1.31 7.58 4000 select_group 21.00 4.16 0.79 4.95 14111 select_group_when_MANY_tables 2.00 0.15 0.18 0.33 10000 select_join 3.00 2.02 0.41 2.43 500 select_key 4.00 2.67 0.52 3.19 20000 select_key2 5.00 2.77 0.48 3.25 20000 select_key2_return_key 4.00 2.48 0.41 2.89 20000 select_key2_return_prim 5.00 2.68 0.52 3.20 20000 select_key_prefix 4.00 2.57 0.53 3.10 20000 select_key_prefix_join 25.00 16.88 3.72 20.60 500 select_key_return_key 4.00 2.53 0.45 2.98 20000 select_many_fields 152.00 57.85 54.18 112.03 40000 select_query_cache 56.00 1.37 0.25 1.62 10000 select_query_cache2 56.00 1.46 0.25 1.71 10000 select_range 39.00 6.75 1.52 8.27 410 select_range_key2 7.00 2.89 0.52 3.41 25010 select_range_prefix 7.00 2.92 0.54 3.46 25010 select_simple 11.00 2.95 3.65 6.60 200000 select_simple_join 3.00 2.16 0.47 2.63 2500 update_big 4.00 0.00 0.00 0.00 10 update_of_key 30.00 0.11 0.10 0.21 5000 update_of_key_big 17.00 0.02 0.01 0.03 480 update_of_primary_key_many_keys 4.00 0.01 0.00 0.01 256 update_with_key 184.00 0.48 0.47 0.95 30000 update_with_key_prefix 1.00 0.11 0.16 0.27 10000 wisc_benchmark 4.00 2.80 0.50 3.30 214 TOTALS 3547.00 447.71 153.59 601.30 2246526