Benchmark DBD suite: 2.14 Date of test: 2005-04-18 22:26:55 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=writeback,extents 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 833 wallclock secs ( 0.18 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.22 CPU) ATIS: Total time: 125 wallclock secs (31.20 usr 6.82 sys + 0.00 cusr 0.00 csys = 38.02 CPU) big-tables: Total time: 429 wallclock secs (59.84 usr 55.05 sys + 0.00 cusr 0.00 csys = 114.89 CPU) connect: Total time: 459 wallclock secs (276.55 usr 73.77 sys + 0.00 cusr 0.00 csys = 350.32 CPU) create: Total time: 383 wallclock secs ( 2.69 usr 1.21 sys + 0.00 cusr 0.00 csys = 3.90 CPU) insert: Total time: 609 wallclock secs (47.00 usr 10.97 sys + 0.00 cusr 0.00 csys = 57.97 CPU) select: Total time: 485 wallclock secs (34.04 usr 6.88 sys + 0.00 cusr 0.00 csys = 40.92 CPU) wisconsin: Total time: 195 wallclock secs ( 3.26 usr 0.95 sys + 0.00 cusr 0.00 csys = 4.21 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 453.00 0.09 0.02 0.11 992 alter_table_drop 360.00 0.06 0.01 0.07 496 connect 109.00 79.28 13.01 92.29 200000 connect+select_1_row 131.00 75.87 21.43 97.30 200000 connect+select_simple 116.00 83.15 16.52 99.67 200000 count 2.00 0.02 0.01 0.03 100 count_distinct 12.00 0.14 0.02 0.16 1000 count_distinct_2 22.00 0.15 0.03 0.18 1000 count_distinct_big 13.00 5.99 1.39 7.38 120 count_distinct_group 38.00 0.75 0.17 0.92 1000 count_distinct_group_on_key 13.00 0.20 0.03 0.23 1000 count_distinct_group_on_key_parts 39.00 0.77 0.16 0.93 1000 count_distinct_key_prefix 9.00 0.13 0.02 0.15 1000 count_group_on_key_parts 11.00 0.72 0.16 0.88 1000 count_on_key 83.00 6.47 1.15 7.62 50100 create+drop 125.00 0.75 0.34 1.09 10000 create_MANY_tables 64.00 0.53 0.17 0.70 10000 create_index 8.00 0.01 0.00 0.01 8 create_key+drop 127.00 0.97 0.36 1.33 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 3.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 3.00 0.01 0.00 0.01 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 66.00 0.29 0.17 0.46 10000 insert 496.00 1.36 1.16 2.52 80768 insert_duplicates 1.00 0.13 0.12 0.25 10000 insert_key 62.00 0.33 0.17 0.50 10000 insert_many_fields 278.00 2.83 0.84 3.67 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 43.00 10.85 1.92 12.77 85000 multiple_value_insert 0.00 0.03 0.00 0.03 10000 order_by_big 3.00 1.59 0.40 1.99 10 order_by_big_key 2.00 1.65 0.42 2.07 10 order_by_big_key2 2.00 1.64 0.42 2.06 10 order_by_big_key_desc 2.00 1.66 0.42 2.08 10 order_by_big_key_diff 2.00 1.60 0.39 1.99 10 order_by_big_key_prefix 2.00 1.61 0.40 2.01 10 order_by_key2_diff 2.00 1.39 0.34 1.73 500 order_by_key_prefix 1.00 0.73 0.19 0.92 500 order_by_range 1.00 0.76 0.18 0.94 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 2.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.42 4.50 7.92 200000 select_2_rows 16.00 3.35 4.58 7.93 200000 select_big 2.00 1.68 0.44 2.12 80 select_big_str 44.00 25.88 5.99 31.87 200000 select_column+column 17.00 2.65 3.97 6.62 200000 select_diff_key 9.00 0.09 0.01 0.10 500 select_distinct 18.00 6.30 1.28 7.58 4000 select_group 22.00 4.20 0.82 5.02 14111 select_group_when_MANY_tables 1.00 0.14 0.17 0.31 10000 select_join 3.00 1.99 0.40 2.39 500 select_key 4.00 2.76 0.52 3.28 20000 select_key2 5.00 2.59 0.52 3.11 20000 select_key2_return_key 5.00 2.62 0.39 3.01 20000 select_key2_return_prim 4.00 2.71 0.48 3.19 20000 select_key_prefix 5.00 2.64 0.52 3.16 20000 select_key_prefix_join 24.00 16.38 3.72 20.10 500 select_key_return_key 4.00 2.62 0.48 3.10 20000 select_many_fields 151.00 57.01 54.21 111.22 40000 select_query_cache 54.00 1.37 0.25 1.62 10000 select_query_cache2 54.00 1.36 0.25 1.61 10000 select_range 37.00 6.83 1.47 8.30 410 select_range_key2 7.00 2.86 0.56 3.42 25010 select_range_prefix 6.00 2.97 0.55 3.52 25010 select_simple 11.00 2.95 3.77 6.72 200000 select_simple_join 4.00 2.16 0.46 2.62 2500 update_big 3.00 0.00 0.00 0.00 10 update_of_key 31.00 0.07 0.07 0.14 5000 update_of_key_big 16.00 0.01 0.01 0.02 480 update_of_primary_key_many_keys 6.00 0.01 0.00 0.01 256 update_with_key 184.00 0.45 0.48 0.93 30000 update_with_key_prefix 1.00 0.11 0.16 0.27 10000 wisc_benchmark 5.00 2.77 0.50 3.27 214 TOTALS 3491.00 447.49 154.09 601.58 2246526