root@db:~/mysql-5.0.51a-linux-x86_64-glibc23/sql-bench# perl run-all-tests --server=MySQL Benchmark DBD suite: 2.15 Date of test: 2008-07-17 17:05:10 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: 13 wallclock secs ( 0.03 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.05 CPU) ATIS: Total time: 3 wallclock secs ( 2.28 usr 0.04 sys + 0.00 cusr 0.00 csys = 2.32 CPU) big-tables: Total time: 2 wallclock secs ( 1.23 usr 0.12 sys + 0.00 cusr 0.00 csys = 1.35 CPU) connect: Total time: 42 wallclock secs (11.68 usr 5.03 sys + 0.00 cusr 0.00 csys = 16.71 CPU) create: Total time: 290 wallclock secs ( 1.01 usr 0.43 sys + 0.00 cusr 0.00 csys = 1.44 CPU) insert: Total time: 354 wallclock secs (127.64 usr 19.28 sys + 0.00 cusr 0.00 csys = 146.92 CPU) select: Total time: 34 wallclock secs (12.21 usr 1.24 sys + 0.00 cusr 0.00 csys = 13.45 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 3 wallclock secs ( 1.04 usr 0.29 sys + 0.00 cusr 0.00 csys = 1.33 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 5.00 0.02 0.01 0.03 100 alter_table_drop 6.00 0.00 0.00 0.00 91 connect 2.00 1.76 0.37 2.13 10000 connect+select_1_row 4.00 1.82 0.49 2.31 10000 connect+select_simple 3.00 1.76 0.47 2.23 10000 count 3.00 0.02 0.00 0.02 100 count_distinct 0.00 0.06 0.01 0.07 1000 count_distinct_2 0.00 0.04 0.00 0.04 1000 count_distinct_big 2.00 1.99 0.03 2.02 120 count_distinct_group 0.00 0.27 0.00 0.27 1000 count_distinct_group_on_key 0.00 0.06 0.00 0.06 1000 count_distinct_group_on_key_parts 1.00 0.22 0.01 0.23 1000 count_distinct_key_prefix 0.00 0.05 0.02 0.07 1000 count_group_on_key_parts 0.00 0.25 0.01 0.26 1000 count_on_key 8.00 2.54 0.37 2.91 50100 create+drop 93.00 0.33 0.14 0.47 10000 create_MANY_tables 102.00 0.14 0.09 0.23 10000 create_index 1.00 0.00 0.00 0.00 8 create_key+drop 93.00 0.33 0.09 0.42 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 9.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 9.00 0.00 0.00 0.00 128 delete_key 0.00 0.08 0.04 0.12 10000 delete_range 2.00 0.00 0.00 0.00 12 drop_index 1.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.13 0.05 0.18 10000 insert 19.00 2.57 2.49 5.06 350768 insert_duplicates 5.00 0.77 0.76 1.53 100000 insert_key 16.00 1.15 0.80 1.95 100000 insert_many_fields 1.00 0.06 0.02 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.01 0.00 0.01 60 min_max_on_key 6.00 4.27 0.59 4.86 85000 multiple_value_insert 1.00 0.10 0.00 0.10 100000 once_prepared_select 23.00 1.92 0.71 2.63 100000 order_by_big 8.00 5.95 0.14 6.09 10 order_by_big_key 7.00 6.23 0.11 6.34 10 order_by_big_key2 7.00 5.91 0.13 6.04 10 order_by_big_key_desc 7.00 6.24 0.12 6.36 10 order_by_big_key_diff 7.00 5.96 0.10 6.06 10 order_by_big_key_prefix 7.00 5.98 0.07 6.05 10 order_by_key2_diff 0.00 0.55 0.00 0.55 500 order_by_key_prefix 1.00 0.32 0.00 0.32 500 order_by_range 0.00 0.27 0.01 0.28 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 14.00 4.79 0.78 5.57 100000 select_1_row 7.00 1.02 0.67 1.69 100000 select_1_row_cache 2.00 0.94 0.73 1.67 100000 select_2_rows 8.00 0.87 0.59 1.46 100000 select_big 7.00 5.99 0.09 6.08 80 select_big_str 2.00 0.93 0.26 1.19 10000 select_cache 0.00 0.53 0.03 0.56 10000 select_cache2 19.00 0.36 0.11 0.47 10000 select_column+column 8.00 0.83 0.54 1.37 100000 select_diff_key 0.00 0.04 0.00 0.04 500 select_distinct 0.00 0.44 0.00 0.44 800 select_group 1.00 0.32 0.01 0.33 2911 select_group_when_MANY_tables 1.00 0.08 0.06 0.14 10000 select_join 1.00 0.13 0.00 0.13 100 select_key 26.00 10.88 1.75 12.63 200000 select_key2 26.00 10.43 1.56 11.99 200000 select_key2_return_key 25.00 9.96 1.65 11.61 200000 select_key2_return_prim 25.00 10.42 1.60 12.02 200000 select_key_prefix 27.00 11.35 1.68 13.03 200000 select_key_prefix_join 1.00 1.13 0.01 1.14 100 select_key_return_key 25.00 11.13 1.77 12.90 200000 select_many_fields 1.00 1.17 0.10 1.27 2000 select_range 3.00 2.32 0.02 2.34 410 select_range_key2 2.00 1.11 0.08 1.19 25010 select_range_prefix 2.00 1.15 0.13 1.28 25010 select_simple 3.00 0.91 0.45 1.36 100000 select_simple_cache 3.00 0.84 0.46 1.30 100000 select_simple_join 0.00 0.15 0.01 0.16 500 update_big 6.00 0.00 0.00 0.00 10 update_of_key 4.00 0.34 0.40 0.74 50000 update_of_key_big 4.00 0.01 0.00 0.01 501 update_of_primary_key_many_keys 5.00 0.00 0.00 0.00 256 update_with_key 17.00 1.55 1.84 3.39 300000 update_with_key_prefix 5.00 1.38 0.73 2.11 100000 wisc_benchmark 1.00 0.87 0.02 0.89 114 TOTALS 747.00 154.50 26.38 180.88 3425950