Benchmark DBD suite: 2.14 Date of test: 2005-04-18 18:23:54 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=writeback 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 861 wallclock secs ( 0.19 usr 0.06 sys + 0.00 cusr 0.00 csys = 0.25 CPU) ATIS: Total time: 125 wallclock secs (31.08 usr 6.96 sys + 0.00 cusr 0.00 csys = 38.04 CPU) big-tables: Total time: 432 wallclock secs (60.89 usr 56.41 sys + 0.00 cusr 0.00 csys = 117.30 CPU) connect: Total time: 469 wallclock secs (293.26 usr 72.78 sys + 0.00 cusr 0.00 csys = 366.04 CPU) create: Total time: 384 wallclock secs ( 2.60 usr 1.38 sys + 0.00 cusr 0.00 csys = 3.98 CPU) insert: Total time: 608 wallclock secs (48.42 usr 11.25 sys + 0.00 cusr 0.00 csys = 59.67 CPU) select: Total time: 478 wallclock secs (34.47 usr 6.87 sys + 0.00 cusr 0.00 csys = 41.34 CPU) wisconsin: Total time: 195 wallclock secs ( 3.38 usr 1.01 sys + 0.00 cusr 0.00 csys = 4.39 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 466.00 0.11 0.03 0.14 992 alter_table_drop 373.00 0.06 0.02 0.08 496 connect 113.00 81.39 13.49 94.88 200000 connect+select_1_row 134.00 86.95 18.55 105.50 200000 connect+select_simple 120.00 85.53 17.30 102.83 200000 count 2.00 0.01 0.00 0.01 100 count_distinct 11.00 0.13 0.03 0.16 1000 count_distinct_2 20.00 0.14 0.04 0.18 1000 count_distinct_big 13.00 6.30 1.35 7.65 120 count_distinct_group 38.00 0.77 0.16 0.93 1000 count_distinct_group_on_key 12.00 0.20 0.03 0.23 1000 count_distinct_group_on_key_parts 38.00 0.77 0.16 0.93 1000 count_distinct_key_prefix 9.00 0.15 0.02 0.17 1000 count_group_on_key_parts 11.00 0.74 0.16 0.90 1000 count_on_key 82.00 6.41 1.20 7.61 50100 create+drop 125.00 0.74 0.36 1.10 10000 create_MANY_tables 64.00 0.51 0.19 0.70 10000 create_index 8.00 0.00 0.00 0.00 8 create_key+drop 127.00 0.97 0.36 1.33 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.02 0.01 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 66.00 0.21 0.21 0.42 10000 insert 496.00 1.46 1.22 2.68 80768 insert_duplicates 1.00 0.18 0.14 0.32 10000 insert_key 62.00 0.35 0.16 0.51 10000 insert_many_fields 280.00 2.97 0.82 3.79 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.00 0.00 0.00 60 min_max_on_key 41.00 10.81 1.97 12.78 85000 multiple_value_insert 1.00 0.03 0.01 0.04 10000 order_by_big 3.00 1.66 0.41 2.07 10 order_by_big_key 2.00 1.71 0.41 2.12 10 order_by_big_key2 2.00 1.70 0.41 2.11 10 order_by_big_key_desc 2.00 1.73 0.43 2.16 10 order_by_big_key_diff 2.00 1.66 0.41 2.07 10 order_by_big_key_prefix 2.00 1.62 0.41 2.03 10 order_by_key2_diff 2.00 1.48 0.32 1.80 500 order_by_key_prefix 1.00 0.79 0.19 0.98 500 order_by_range 2.00 0.78 0.16 0.94 500 outer_join 2.00 0.01 0.01 0.02 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.53 4.64 8.17 200000 select_2_rows 16.00 3.58 4.77 8.35 200000 select_big 3.00 1.77 0.43 2.20 80 select_big_str 44.00 26.53 6.25 32.78 200000 select_column+column 17.00 2.54 3.85 6.39 200000 select_diff_key 8.00 0.07 0.01 0.08 500 select_distinct 18.00 6.25 1.33 7.58 4000 select_group 21.00 4.20 0.85 5.05 14111 select_group_when_MANY_tables 2.00 0.17 0.26 0.43 10000 select_join 3.00 1.84 0.39 2.23 500 select_key 4.00 2.80 0.56 3.36 20000 select_key2 5.00 2.72 0.58 3.30 20000 select_key2_return_key 5.00 2.65 0.50 3.15 20000 select_key2_return_prim 4.00 2.75 0.50 3.25 20000 select_key_prefix 5.00 2.91 0.51 3.42 20000 select_key_prefix_join 24.00 16.42 3.78 20.20 500 select_key_return_key 4.00 2.78 0.43 3.21 20000 select_many_fields 152.00 57.91 55.59 113.50 40000 select_query_cache 54.00 1.35 0.24 1.59 10000 select_query_cache2 53.00 1.30 0.26 1.56 10000 select_range 39.00 7.01 1.47 8.48 410 select_range_key2 8.00 3.00 0.52 3.52 25010 select_range_prefix 7.00 2.97 0.58 3.55 25010 select_simple 10.00 3.20 3.93 7.13 200000 select_simple_join 3.00 2.19 0.46 2.65 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 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 184.00 0.50 0.48 0.98 30000 update_with_key_prefix 0.00 0.12 0.16 0.28 10000 wisc_benchmark 5.00 2.80 0.51 3.31 214 TOTALS 3522.00 467.01 155.07 622.08 2246526