Benchmark DBD suite: 2.14 Date of test: 2005-04-19 2:27:01 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: xfs defaults 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 1215 wallclock secs ( 0.27 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.34 CPU) ATIS: Total time: 198 wallclock secs (31.39 usr 6.94 sys + 0.00 cusr 0.00 csys = 38.33 CPU) big-tables: Total time: 1065 wallclock secs (62.67 usr 55.73 sys + 0.00 cusr 0.00 csys = 118.40 CPU) connect: Total time: 476 wallclock secs (306.15 usr 69.65 sys + 0.00 cusr 0.00 csys = 375.80 CPU) create: Total time: 1028 wallclock secs ( 7.71 usr 2.11 sys + 0.00 cusr 0.00 csys = 9.82 CPU) insert: Total time: 1343 wallclock secs (51.62 usr 11.97 sys + 0.00 cusr 0.00 csys = 63.59 CPU) select: Total time: 578 wallclock secs (36.47 usr 7.26 sys + 0.00 cusr 0.00 csys = 43.73 CPU) wisconsin: Total time: 483 wallclock secs ( 4.44 usr 1.30 sys + 0.00 cusr 0.00 csys = 5.74 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 669.00 0.16 0.03 0.19 992 alter_table_drop 510.00 0.07 0.02 0.09 496 connect 113.00 82.27 13.93 96.20 200000 connect+select_1_row 137.00 96.78 15.99 112.77 200000 connect+select_simple 122.00 87.15 17.36 104.51 200000 count 1.00 0.01 0.00 0.01 100 count_distinct 12.00 0.28 0.03 0.31 1000 count_distinct_2 20.00 0.30 0.04 0.34 1000 count_distinct_big 13.00 6.01 1.41 7.42 120 count_distinct_group 37.00 0.76 0.17 0.93 1000 count_distinct_group_on_key 13.00 0.28 0.03 0.31 1000 count_distinct_group_on_key_parts 38.00 0.92 0.19 1.11 1000 count_distinct_key_prefix 9.00 0.25 0.04 0.29 1000 count_group_on_key_parts 11.00 0.85 0.17 1.02 1000 count_on_key 85.00 7.75 1.38 9.13 50100 create+drop 350.00 2.37 0.63 3.00 10000 create_MANY_tables 171.00 1.73 0.34 2.07 10000 create_index 11.00 0.00 0.00 0.00 8 create_key+drop 329.00 2.68 0.67 3.35 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 4.00 0.00 0.00 0.00 1 delete_big 1.00 0.00 0.00 0.00 1 delete_big_many_keys 4.00 0.00 0.00 0.00 128 delete_key 8.00 0.04 0.03 0.07 1000 drop_index 9.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 176.00 0.79 0.31 1.10 10000 insert 1221.00 4.19 2.02 6.21 80768 insert_duplicates 1.00 0.18 0.14 0.32 10000 insert_key 167.00 1.03 0.27 1.30 10000 insert_many_fields 913.00 4.81 1.22 6.03 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.02 0.01 0.03 60 min_max_on_key 41.00 10.94 1.84 12.78 85000 multiple_value_insert 1.00 0.03 0.01 0.04 10000 order_by_big 2.00 1.64 0.39 2.03 10 order_by_big_key 2.00 1.67 0.43 2.10 10 order_by_big_key2 3.00 1.68 0.39 2.07 10 order_by_big_key_desc 2.00 1.72 0.42 2.14 10 order_by_big_key_diff 2.00 1.62 0.40 2.02 10 order_by_big_key_prefix 2.00 1.61 0.41 2.02 10 order_by_key2_diff 2.00 1.49 0.34 1.83 500 order_by_key_prefix 1.00 0.78 0.18 0.96 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.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.22 4.65 8.87 200000 select_2_rows 16.00 3.79 4.80 8.59 200000 select_big 2.00 1.70 0.44 2.14 80 select_big_str 45.00 26.14 5.49 31.63 200000 select_column+column 17.00 2.71 3.65 6.36 200000 select_diff_key 9.00 0.09 0.02 0.11 500 select_distinct 18.00 6.24 1.34 7.58 4000 select_group 22.00 4.33 0.79 5.12 14111 select_group_when_MANY_tables 2.00 0.14 0.16 0.30 10000 select_join 2.00 1.92 0.40 2.32 500 select_key 4.00 2.77 0.57 3.34 20000 select_key2 5.00 2.73 0.59 3.32 20000 select_key2_return_key 5.00 2.76 0.47 3.23 20000 select_key2_return_prim 5.00 2.81 0.44 3.25 20000 select_key_prefix 5.00 2.88 0.54 3.42 20000 select_key_prefix_join 24.00 16.19 3.76 19.95 500 select_key_return_key 4.00 2.81 0.47 3.28 20000 select_many_fields 152.00 57.86 54.51 112.37 40000 select_query_cache 53.00 1.25 0.23 1.48 10000 select_query_cache2 54.00 1.27 0.24 1.51 10000 select_range 44.00 6.76 1.49 8.25 410 select_range_key2 8.00 3.01 0.57 3.58 25010 select_range_prefix 5.00 3.02 0.53 3.55 25010 select_simple 11.00 3.09 3.78 6.87 200000 select_simple_join 4.00 2.17 0.45 2.62 2500 update_big 4.00 0.00 0.00 0.00 10 update_of_key 78.00 0.33 0.13 0.46 5000 update_of_key_big 22.00 0.03 0.02 0.05 480 update_of_primary_key_many_keys 7.00 0.01 0.01 0.02 256 update_with_key 467.00 1.61 0.74 2.35 30000 update_with_key_prefix 1.00 0.14 0.16 0.30 10000 wisc_benchmark 4.00 2.86 0.52 3.38 214 TOTALS 6339.00 493.28 153.37 646.65 2246526