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 16:02:56 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: 23 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.01 CPU) ATIS: Total time: 3 wallclock secs ( 2.23 usr 0.12 sys + 0.00 cusr 0.00 csys = 2.35 CPU) big-tables: Total time: 3 wallclock secs ( 1.27 usr 0.14 sys + 0.00 cusr 0.00 csys = 1.41 CPU) connect: Total time: 43 wallclock secs (11.53 usr 5.71 sys + 0.00 cusr 0.00 csys = 17.24 CPU) create: Total time: 377 wallclock secs ( 1.19 usr 0.48 sys + 0.00 cusr 0.00 csys = 1.67 CPU) insert: Total time: 430 wallclock secs (125.96 usr 18.05 sys + 0.00 cusr 0.00 csys = 144.01 CPU) select: Total time: 34 wallclock secs (12.24 usr 1.25 sys + 0.00 cusr 0.00 csys = 13.49 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 3 wallclock secs ( 1.14 usr 0.27 sys + 0.00 cusr 0.00 csys = 1.41 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 10.00 0.00 0.00 0.00 100 alter_table_drop 10.00 0.01 0.00 0.01 91 connect 3.00 1.77 0.37 2.14 10000 connect+select_1_row 3.00 1.79 0.43 2.22 10000 connect+select_simple 3.00 1.72 0.40 2.12 10000 count 3.00 0.02 0.01 0.03 100 count_distinct 0.00 0.04 0.02 0.06 1000 count_distinct_2 0.00 0.06 0.00 0.06 1000 count_distinct_big 2.00 2.01 0.02 2.03 120 count_distinct_group 0.00 0.26 0.00 0.26 1000 count_distinct_group_on_key 0.00 0.07 0.00 0.07 1000 count_distinct_group_on_key_parts 1.00 0.26 0.01 0.27 1000 count_distinct_key_prefix 0.00 0.07 0.00 0.07 1000 count_group_on_key_parts 0.00 0.24 0.01 0.25 1000 count_on_key 8.00 2.55 0.29 2.84 50100 create+drop 123.00 0.35 0.13 0.48 10000 create_MANY_tables 124.00 0.24 0.07 0.31 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 128.00 0.43 0.18 0.61 10000 create_table 1.00 0.00 0.00 0.00 31 delete_all_many_keys 42.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 42.00 0.01 0.00 0.01 128 delete_key 0.00 0.04 0.10 0.14 10000 delete_range 2.00 0.01 0.00 0.01 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 0.00 0.10 0.03 0.13 10000 insert 19.00 2.73 2.25 4.98 350768 insert_duplicates 5.00 1.09 0.61 1.70 100000 insert_key 41.00 1.45 0.62 2.07 100000 insert_many_fields 1.00 0.07 0.01 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.02 0.00 0.02 60 min_max_on_key 6.00 3.94 0.70 4.64 85000 multiple_value_insert 1.00 0.10 0.00 0.10 100000 once_prepared_select 23.00 1.80 0.68 2.48 100000 order_by_big 7.00 5.98 0.11 6.09 10 order_by_big_key 7.00 6.17 0.16 6.33 10 order_by_big_key2 7.00 5.97 0.09 6.06 10 order_by_big_key_desc 7.00 6.23 0.11 6.34 10 order_by_big_key_diff 7.00 5.95 0.11 6.06 10 order_by_big_key_prefix 7.00 5.98 0.08 6.06 10 order_by_key2_diff 1.00 0.52 0.00 0.52 500 order_by_key_prefix 0.00 0.29 0.01 0.30 500 order_by_range 1.00 0.33 0.01 0.34 500 outer_join 1.00 0.00 0.00 0.00 10 outer_join_found 1.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 0.00 0.00 0.00 0.00 10 prepared_select 14.00 4.73 0.66 5.39 100000 select_1_row 7.00 0.92 0.70 1.62 100000 select_1_row_cache 3.00 0.75 0.82 1.57 100000 select_2_rows 7.00 1.18 0.57 1.75 100000 select_big 7.00 5.97 0.08 6.05 80 select_big_str 2.00 1.09 0.24 1.33 10000 select_cache 0.00 0.49 0.08 0.57 10000 select_cache2 19.00 0.47 0.08 0.55 10000 select_column+column 8.00 0.85 0.73 1.58 100000 select_diff_key 0.00 0.01 0.02 0.03 500 select_distinct 0.00 0.43 0.01 0.44 800 select_group 0.00 0.30 0.01 0.31 2911 select_group_when_MANY_tables 2.00 0.07 0.07 0.14 10000 select_join 0.00 0.13 0.00 0.13 100 select_key 24.00 10.14 1.52 11.66 200000 select_key2 26.00 10.18 1.62 11.80 200000 select_key2_return_key 24.00 10.40 1.66 12.06 200000 select_key2_return_prim 26.00 10.38 1.56 11.94 200000 select_key_prefix 27.00 10.35 1.67 12.02 200000 select_key_prefix_join 2.00 1.14 0.00 1.14 100 select_key_return_key 25.00 10.49 1.41 11.90 200000 select_many_fields 2.00 1.20 0.13 1.33 2000 select_range 3.00 2.30 0.02 2.32 410 select_range_key2 1.00 1.01 0.20 1.21 25010 select_range_prefix 2.00 1.16 0.06 1.22 25010 select_simple 3.00 0.77 0.71 1.48 100000 select_simple_cache 3.00 0.69 0.74 1.43 100000 select_simple_join 0.00 0.15 0.00 0.15 500 update_big 6.00 0.00 0.00 0.00 10 update_of_key 5.00 0.35 0.34 0.69 50000 update_of_key_big 5.00 0.00 0.00 0.00 501 update_of_primary_key_many_keys 22.00 0.00 0.00 0.00 256 update_with_key 18.00 2.00 1.99 3.99 300000 update_with_key_prefix 6.00 1.31 0.64 1.95 100000 wisc_benchmark 1.00 0.87 0.04 0.91 114 TOTALS 954.00 152.96 26.00 178.96 3425950