root@supernova2:~/mysql-5.0.51a-linux-i686-glibc23/sql-bench# perl run-all-tests --server=MySQL Benchmark DBD suite: 2.15 Date of test: 2008-07-17 17:46:46 Running tests on: Linux 2.6.18.8-524-1 i686 Arguments: Comments: Limits from: Server version: MySQL 5.0.22 Debian_0ubuntu6.06.10 log Optimization: None Hardware: alter-table: Total time: 32 wallclock secs ( 0.02 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.04 CPU) ATIS: Total time: 5 wallclock secs ( 3.59 usr 0.04 sys + 0.00 cusr 0.00 csys = 3.63 CPU) big-tables: Total time: 7 wallclock secs ( 2.64 usr 0.25 sys + 0.00 cusr 0.00 csys = 2.89 CPU) connect: Total time: 72 wallclock secs (14.95 usr 7.83 sys + 0.00 cusr 0.00 csys = 22.78 CPU) create: Total time: 493 wallclock secs ( 1.04 usr 0.53 sys + 0.00 cusr 0.00 csys = 1.57 CPU) insert: Total time: 638 wallclock secs (120.05 usr 15.43 sys + 0.00 cusr 0.00 csys = 135.48 CPU) select: Total time: 73 wallclock secs (15.25 usr 1.57 sys + 0.00 cusr 0.00 csys = 16.82 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 5 wallclock secs ( 1.18 usr 0.13 sys + 0.00 cusr 0.00 csys = 1.31 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 14.00 0.00 0.00 0.00 100 alter_table_drop 14.00 0.00 0.00 0.00 91 connect 4.00 2.18 0.57 2.75 10000 connect+select_1_row 5.00 1.14 0.28 1.42 10000 connect+select_simple 5.00 2.39 0.70 3.09 10000 count 9.00 0.00 0.00 0.00 100 count_distinct 0.00 0.02 0.00 0.02 1000 count_distinct_2 0.00 0.07 0.01 0.08 1000 count_distinct_big 5.00 3.75 0.05 3.80 120 count_distinct_group 0.00 0.32 0.00 0.32 1000 count_distinct_group_on_key 0.00 0.07 0.01 0.08 1000 count_distinct_group_on_key_parts 1.00 0.14 0.01 0.15 1000 count_distinct_key_prefix 0.00 0.00 0.00 0.00 1000 count_group_on_key_parts 1.00 0.30 0.01 0.31 1000 count_on_key 12.00 1.25 0.50 1.75 50100 create+drop 189.00 0.06 0.03 0.09 10000 create_MANY_tables 90.00 0.25 0.13 0.38 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 192.00 0.06 0.03 0.09 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 54.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 54.00 0.00 0.00 0.00 128 delete_key 1.00 0.00 0.03 0.03 10000 delete_range 4.00 0.00 0.00 0.00 12 drop_index 2.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 6.00 0.19 0.12 0.31 10000 insert 35.00 2.43 2.09 4.52 350768 insert_duplicates 9.00 2.04 1.29 3.33 100000 insert_key 64.00 2.04 0.99 3.03 100000 insert_many_fields 4.00 0.03 0.01 0.04 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 2.00 0.00 0.00 0.00 1 min_max 3.00 0.00 0.00 0.00 60 min_max_on_key 10.00 3.74 0.73 4.47 85000 multiple_value_insert 1.00 0.18 0.01 0.19 100000 once_prepared_select 16.00 0.27 0.12 0.39 100000 order_by_big 14.00 10.66 0.07 10.73 10 order_by_big_key 13.00 11.06 0.16 11.22 10 order_by_big_key2 12.00 10.93 0.12 11.05 10 order_by_big_key_desc 14.00 10.97 0.12 11.09 10 order_by_big_key_diff 14.00 10.92 0.12 11.04 10 order_by_big_key_prefix 12.00 10.92 0.11 11.03 10 order_by_key2_diff 1.00 0.72 0.03 0.75 500 order_by_key_prefix 1.00 0.40 0.01 0.41 500 order_by_range 1.00 0.28 0.01 0.29 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 1.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 prepared_select 20.00 1.71 0.54 2.25 100000 select_1_row 11.00 1.74 1.16 2.90 100000 select_1_row_cache 5.00 1.46 0.94 2.40 100000 select_2_rows 12.00 0.74 0.49 1.23 100000 select_big 12.00 11.09 0.22 11.31 80 select_big_str 6.00 0.60 0.28 0.88 10000 select_cache 1.00 0.69 0.11 0.80 10000 select_cache2 47.00 0.81 0.15 0.96 10000 select_column+column 12.00 1.85 1.33 3.18 100000 select_diff_key 1.00 0.00 0.00 0.00 500 select_distinct 0.00 0.70 0.00 0.70 800 select_group 2.00 0.35 0.02 0.37 2911 select_group_when_MANY_tables 16.00 0.48 0.21 0.69 10000 select_join 0.00 0.23 0.01 0.24 100 select_key 35.00 3.19 0.87 4.06 200000 select_key2 36.00 3.49 0.95 4.44 200000 select_key2_return_key 34.00 2.37 0.82 3.19 200000 select_key2_return_prim 40.00 6.09 1.41 7.50 200000 select_key_prefix 36.00 4.20 1.06 5.26 200000 select_key_prefix_join 3.00 2.07 0.01 2.08 100 select_key_return_key 35.00 3.37 0.96 4.33 200000 select_many_fields 3.00 2.61 0.24 2.85 2000 select_range 5.00 4.22 0.06 4.28 410 select_range_key2 2.00 0.97 0.10 1.07 25010 select_range_prefix 2.00 1.17 0.14 1.31 25010 select_simple 6.00 1.69 1.20 2.89 100000 select_simple_cache 6.00 1.15 0.88 2.03 100000 select_simple_join 0.00 0.24 0.00 0.24 500 update_big 8.00 0.00 0.00 0.00 10 update_of_key 7.00 0.34 0.31 0.65 50000 update_of_key_big 7.00 0.01 0.01 0.02 501 update_of_primary_key_many_keys 24.00 0.00 0.00 0.00 256 update_with_key 29.00 2.09 1.88 3.97 300000 update_with_key_prefix 11.00 1.39 0.77 2.16 100000 wisc_benchmark 2.00 1.17 0.13 1.30 114 TOTALS 1374.00 154.06 25.73 179.79 3425950