root@db:~/mysql-5.0.51a-linux-x86_64-icc-glibc23/sql-bench# perl run-all-tests --server=MySQL Benchmark DBD suite: 2.15 Date of test: 2008-07-25 12:35:26 Running tests on: Linux 2.6.24-16-server x86_64 Arguments: Comments: Limits from: Server version: MySQL 5.0.51a 3ubuntu5.1/ Optimization: None Hardware: alter-table: Total time: 9 wallclock secs ( 0.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.02 CPU) ATIS: Total time: 2 wallclock secs ( 2.31 usr 0.13 sys + 0.00 cusr 0.00 csys = 2.44 CPU) big-tables: Total time: 3 wallclock secs ( 1.24 usr 0.16 sys + 0.00 cusr 0.00 csys = 1.40 CPU) connect: Total time: 43 wallclock secs (11.58 usr 5.49 sys + 0.00 cusr 0.00 csys = 17.07 CPU) create: Total time: 56 wallclock secs ( 1.04 usr 0.42 sys + 0.00 cusr 0.00 csys = 1.46 CPU) insert: Total time: 360 wallclock secs (126.88 usr 17.89 sys + 0.00 cusr 0.00 csys = 144.77 CPU) select: Total time: 35 wallclock secs (12.76 usr 1.35 sys + 0.00 cusr 0.00 csys = 14.11 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 3 wallclock secs ( 1.06 usr 0.19 sys + 0.00 cusr 0.00 csys = 1.25 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 4.00 0.01 0.00 0.01 100 alter_table_drop 4.00 0.00 0.00 0.00 91 connect 3.00 1.69 0.20 1.89 10000 connect+select_1_row 4.00 2.17 0.41 2.58 10000 connect+select_simple 3.00 1.85 0.58 2.43 10000 count 3.00 0.04 0.00 0.04 100 count_distinct 0.00 0.07 0.00 0.07 1000 count_distinct_2 0.00 0.06 0.00 0.06 1000 count_distinct_big 3.00 2.01 0.02 2.03 120 count_distinct_group 0.00 0.27 0.01 0.28 1000 count_distinct_group_on_key 0.00 0.08 0.02 0.10 1000 count_distinct_group_on_key_parts 1.00 0.25 0.01 0.26 1000 count_distinct_key_prefix 0.00 0.05 0.01 0.06 1000 count_group_on_key_parts 0.00 0.27 0.00 0.27 1000 count_on_key 8.00 2.68 0.38 3.06 50100 create+drop 17.00 0.32 0.17 0.49 10000 create_MANY_tables 19.00 0.28 0.06 0.34 10000 create_index 1.00 0.00 0.00 0.00 8 create_key+drop 18.00 0.33 0.10 0.43 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 15.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 15.00 0.00 0.00 0.00 128 delete_key 0.00 0.09 0.11 0.20 10000 delete_range 2.00 0.00 0.00 0.00 12 drop_index 0.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 1.00 0.04 0.02 0.06 10000 insert 18.00 2.67 2.40 5.07 350768 insert_duplicates 4.00 0.70 0.71 1.41 100000 insert_key 18.00 1.45 0.68 2.13 100000 insert_many_fields 1.00 0.05 0.03 0.08 2000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 1.00 0.00 0.00 0.00 1 min_max 1.00 0.00 0.00 0.00 60 min_max_on_key 7.00 4.27 0.75 5.02 85000 multiple_value_insert 1.00 0.08 0.02 0.10 100000 once_prepared_select 23.00 1.78 0.60 2.38 100000 order_by_big 7.00 5.98 0.08 6.06 10 order_by_big_key 8.00 6.16 0.09 6.25 10 order_by_big_key2 7.00 6.02 0.09 6.11 10 order_by_big_key_desc 7.00 6.16 0.10 6.26 10 order_by_big_key_diff 7.00 5.97 0.11 6.08 10 order_by_big_key_prefix 7.00 6.08 0.08 6.16 10 order_by_key2_diff 1.00 0.57 0.00 0.57 500 order_by_key_prefix 0.00 0.37 0.00 0.37 500 order_by_range 1.00 0.30 0.00 0.30 500 outer_join 1.00 0.00 0.00 0.00 10 outer_join_found 0.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 prepared_select 15.00 5.29 0.64 5.93 100000 select_1_row 7.00 0.96 0.53 1.49 100000 select_1_row_cache 2.00 0.73 0.67 1.40 100000 select_2_rows 8.00 0.97 0.83 1.80 100000 select_big 6.00 5.96 0.11 6.07 80 select_big_str 2.00 0.84 0.27 1.11 10000 select_cache 1.00 0.47 0.13 0.60 10000 select_cache2 19.00 0.56 0.05 0.61 10000 select_column+column 8.00 0.78 0.70 1.48 100000 select_diff_key 0.00 0.03 0.00 0.03 500 select_distinct 1.00 0.43 0.02 0.45 800 select_group 0.00 0.30 0.04 0.34 2911 select_group_when_MANY_tables 1.00 0.07 0.07 0.14 10000 select_join 0.00 0.13 0.00 0.13 100 select_key 25.00 10.14 1.58 11.72 200000 select_key2 26.00 10.92 1.41 12.33 200000 select_key2_return_key 25.00 9.92 1.59 11.51 200000 select_key2_return_prim 25.00 10.19 1.48 11.67 200000 select_key_prefix 26.00 10.61 1.25 11.86 200000 select_key_prefix_join 1.00 1.14 0.00 1.14 100 select_key_return_key 24.00 10.46 1.56 12.02 200000 select_many_fields 2.00 1.19 0.13 1.32 2000 select_range 3.00 2.31 0.04 2.35 410 select_range_key2 1.00 1.22 0.10 1.32 25010 select_range_prefix 2.00 1.10 0.10 1.20 25010 select_simple 3.00 0.85 0.65 1.50 100000 select_simple_cache 3.00 0.73 0.65 1.38 100000 select_simple_join 0.00 0.16 0.00 0.16 500 update_big 6.00 0.00 0.00 0.00 10 update_of_key 3.00 0.35 0.25 0.60 50000 update_of_key_big 5.00 0.00 0.01 0.01 501 update_of_primary_key_many_keys 6.00 0.00 0.00 0.00 256 update_with_key 16.00 2.06 2.10 4.16 300000 update_with_key_prefix 6.00 1.40 0.75 2.15 100000 wisc_benchmark 1.00 0.87 0.04 0.91 114 TOTALS 523.00 154.31 25.59 179.90 3425950