Benchmark DBD suite: 2.14 Date of test: 2005-04-19 0:27:59 Running tests on: Linux 2.6.11-iotest i686 Arguments: --create-options=type=innodb Comments: ext3 data=writeback,mballoc,delalloc,extents 2073944 kB Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 819 wallclock secs ( 0.18 usr 0.06 sys + 0.00 cusr 0.00 csys = 0.24 CPU) ATIS: Total time: 126 wallclock secs (31.46 usr 7.43 sys + 0.00 cusr 0.00 csys = 38.89 CPU) big-tables: Total time: 428 wallclock secs (60.67 usr 54.77 sys + 0.00 cusr 0.00 csys = 115.44 CPU) connect: Total time: 464 wallclock secs (289.36 usr 71.51 sys + 0.00 cusr 0.00 csys = 360.87 CPU) create: Total time: 382 wallclock secs ( 2.48 usr 1.21 sys + 0.00 cusr 0.00 csys = 3.69 CPU) insert: Total time: 609 wallclock secs (48.05 usr 11.11 sys + 0.00 cusr 0.00 csys = 59.16 CPU) select: Total time: 479 wallclock secs (34.10 usr 6.80 sys + 0.00 cusr 0.00 csys = 40.90 CPU) wisconsin: Total time: 196 wallclock secs ( 3.44 usr 1.00 sys + 0.00 cusr 0.00 csys = 4.44 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 443.00 0.10 0.02 0.12 992 alter_table_drop 357.00 0.07 0.01 0.08 496 connect 108.00 79.88 12.50 92.38 200000 connect+select_1_row 134.00 87.27 18.71 105.98 200000 connect+select_simple 118.00 83.82 17.16 100.98 200000 count 2.00 0.02 0.00 0.02 100 count_distinct 12.00 0.17 0.03 0.20 1000 count_distinct_2 20.00 0.17 0.03 0.20 1000 count_distinct_big 13.00 6.10 1.34 7.44 120 count_distinct_group 38.00 0.78 0.14 0.92 1000 count_distinct_group_on_key 12.00 0.19 0.02 0.21 1000 count_distinct_group_on_key_parts 38.00 0.77 0.17 0.94 1000 count_distinct_key_prefix 9.00 0.06 0.01 0.07 1000 count_group_on_key_parts 11.00 0.73 0.15 0.88 1000 count_on_key 82.00 6.49 1.22 7.71 50100 create+drop 126.00 0.74 0.31 1.05 10000 create_MANY_tables 63.00 0.52 0.17 0.69 10000 create_index 6.00 0.00 0.00 0.00 8 create_key+drop 127.00 0.93 0.37 1.30 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 2.00 0.01 0.00 0.01 1 delete_big 0.00 0.01 0.00 0.01 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 6.00 0.00 0.01 0.01 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 64.00 0.19 0.20 0.39 10000 insert 495.00 1.43 1.28 2.71 80768 insert_duplicates 1.00 0.13 0.11 0.24 10000 insert_key 62.00 0.33 0.17 0.50 10000 insert_many_fields 277.00 2.96 0.90 3.86 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.95 1.90 12.85 85000 multiple_value_insert 1.00 0.02 0.00 0.02 10000 order_by_big 2.00 1.69 0.38 2.07 10 order_by_big_key 2.00 1.71 0.41 2.12 10 order_by_big_key2 2.00 1.67 0.40 2.07 10 order_by_big_key_desc 2.00 1.74 0.40 2.14 10 order_by_big_key_diff 3.00 1.65 0.39 2.04 10 order_by_big_key_prefix 2.00 1.66 0.41 2.07 10 order_by_key2_diff 2.00 1.46 0.34 1.80 500 order_by_key_prefix 1.00 0.76 0.18 0.94 500 order_by_range 2.00 0.78 0.19 0.97 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 16.00 3.20 4.61 7.81 200000 select_2_rows 16.00 3.34 4.55 7.89 200000 select_big 3.00 1.76 0.41 2.17 80 select_big_str 44.00 25.56 6.11 31.67 200000 select_column+column 17.00 3.06 4.11 7.17 200000 select_diff_key 9.00 0.08 0.02 0.10 500 select_distinct 18.00 6.39 1.38 7.77 4000 select_group 23.00 4.29 0.90 5.19 14111 select_group_when_MANY_tables 2.00 0.10 0.16 0.26 10000 select_join 3.00 1.97 0.44 2.41 500 select_key 4.00 2.87 0.53 3.40 20000 select_key2 5.00 2.60 0.61 3.21 20000 select_key2_return_key 4.00 2.74 0.44 3.18 20000 select_key2_return_prim 5.00 2.72 0.47 3.19 20000 select_key_prefix 5.00 2.72 0.54 3.26 20000 select_key_prefix_join 24.00 16.48 4.05 20.53 500 select_key_return_key 5.00 2.79 0.47 3.26 20000 select_many_fields 151.00 57.71 53.87 111.58 40000 select_query_cache 54.00 1.27 0.26 1.53 10000 select_query_cache2 53.00 1.25 0.23 1.48 10000 select_range 39.00 6.86 1.46 8.32 410 select_range_key2 7.00 2.85 0.56 3.41 25010 select_range_prefix 6.00 2.97 0.59 3.56 25010 select_simple 11.00 3.23 3.76 6.99 200000 select_simple_join 3.00 2.18 0.52 2.70 2500 update_big 3.00 0.00 0.00 0.00 10 update_of_key 31.00 0.08 0.08 0.16 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.01 0.01 256 update_with_key 184.00 0.47 0.49 0.96 30000 update_with_key_prefix 1.00 0.12 0.14 0.26 10000 wisc_benchmark 6.00 2.86 0.48 3.34 214 TOTALS 3474.00 462.52 152.30 614.82 2246526