昨日行ったテスト結果を以下に示します。
insert のところで、長い間出力がなく、動いていないのかと思ってしまいました。output ディレクトリのグループを変更しているのは、ここにテスト中にファイルを書き出すからです。つまり、インストール先のテストディレクトリでテストしてしまいました。
insert のところで、長い間出力がなく、動いていないのかと思ってしまいました。output ディレクトリのグループを変更しているのは、ここにテスト中にファイルを書き出すからです。つまり、インストール先のテストディレクトリでテストしてしまいました。
# chgrp user /usr/local/mysql/sql-bench/output # chmod 0775 /usr/local/mysql/sql-bench/output $ PATH=$PATH:/usr/local/mysql/bin $ LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql $ export PATH LD_LIBRARY_PATH $ cd /usr/local/mysql/sql-bench $ $ perl run-all-tests |tee ~/Test.log Benchmark DBD suite: 2.15 Date of test: 2006-12-17 22:31:37 Running tests on: Linux 2.6.11-co-0.6.4 i686 Arguments: Comments: Limits from: Server version: MySQL 5.0.27 log/ Optimization: None Hardware: alter-table: Total time: 22 wallclock secs ( 0.08 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.08 CPU) ATIS: Total time: 35 wallclock secs ( 1.56 usr 7.69 sys + 0.00 cusr 0.00 csys = 9.25 CPU) big-tables: Total time: 21 wallclock secs ( 1.93 usr 7.50 sys + 0.00 cusr 0.00 csys = 9.43 CPU) connect: Total time: 211 wallclock secs (26.67 usr 51.00 sys + 0.00 cusr 0.00 csys = 77.67 CPU) create: Total time: 138 wallclock secs ( 8.17 usr 1.31 sys + 0.00 cusr 0.00 csys = 9.48 CPU) insert: Total time: 2082 wallclock secs (141.46 usr 525.80 sys + 0.00 cusr 0.00 csys = 667.26 CPU) select: Total time: 631 wallclock secs ( 7.24 usr 55.98 sys + 0.00 cusr 0.00 csys = 63.22 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 18 wallclock secs ( 3.30 usr 2.45 sys + 0.00 cusr 0.00 csys = 5.75 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 9.00 0.00 0.00 0.00 100 alter_table_drop 9.00 0.00 0.00 0.00 91 connect 17.00 4.06 5.46 9.52 10000 connect+select_1_row 21.00 5.11 5.51 10.62 10000 connect+select_simple 20.00 4.61 5.87 10.48 10000 count 14.00 0.00 0.03 0.03 100 count_distinct 14.00 0.08 0.32 0.40 1000 count_distinct_2 27.00 0.08 0.44 0.52 1000 count_distinct_big 111.00 0.75 7.00 7.75 120 count_distinct_group 24.00 0.06 1.30 1.36 1000 count_distinct_group_on_key 20.00 0.17 0.36 0.53 1000 count_distinct_group_on_key_parts 23.00 0.14 1.14 1.28 1000 count_distinct_key_prefix 12.00 0.03 0.24 0.27 1000 count_group_on_key_parts 18.00 0.06 0.99 1.05 1000 count_on_key 181.00 1.63 13.38 15.01 50100 create+drop 14.00 2.00 0.14 2.14 10000 create_MANY_tables 64.00 1.96 0.07 2.03 10000 create_index 1.00 0.00 0.00 0.00 8 create_key+drop 15.00 2.82 0.25 3.07 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 109.00 0.09 0.00 0.09 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 109.00 0.09 0.00 0.09 128 delete_key 4.00 0.63 0.14 0.77 10000 delete_range 6.00 0.00 0.00 0.00 12 drop_index 2.00 0.04 0.00 0.04 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 15.00 1.03 0.09 1.12 10000 insert 143.00 22.78 2.38 25.16 350768 insert_duplicates 34.00 6.34 0.63 6.97 100000 insert_key 94.00 10.88 0.69 11.57 100000 insert_many_fields 6.00 0.38 0.01 0.39 2000 insert_select_1_key 4.00 0.00 0.00 0.00 1 insert_select_2_keys 5.00 0.00 0.00 0.00 1 min_max 9.00 0.00 0.01 0.01 60 min_max_on_key 41.00 2.38 20.01 22.39 85000 multiple_value_insert 4.00 0.29 0.14 0.43 100000 once_prepared_select 52.00 2.72 12.80 15.52 100000 order_by_big 30.00 4.28 17.85 22.13 10 order_by_big_key 29.00 3.87 19.52 23.39 10 order_by_big_key2 26.00 3.09 18.63 21.72 10 order_by_big_key_desc 28.00 2.80 19.90 22.70 10 order_by_big_key_diff 29.00 4.12 17.95 22.07 10 order_by_big_key_prefix 27.00 3.22 18.07 21.29 10 order_by_key2_diff 3.00 0.09 1.85 1.94 500 order_by_key_prefix 2.00 0.12 1.09 1.21 500 order_by_range 2.00 0.08 1.07 1.15 500 outer_join 28.00 0.00 0.00 0.00 10 outer_join_found 27.00 0.00 0.02 0.02 10 outer_join_not_found 28.00 0.00 0.00 0.00 500 outer_join_on_key 23.00 0.00 0.00 0.00 10 prepared_select 67.00 3.46 25.58 29.04 100000 select_1_row 23.00 1.88 4.87 6.75 100000 select_1_row_cache 23.00 1.62 5.20 6.82 100000 select_2_rows 25.00 1.89 5.67 7.56 100000 select_big 26.00 2.86 18.70 21.56 80 select_big_str 11.00 1.93 4.71 6.64 10000 select_cache 103.00 0.40 3.20 3.60 10000 select_cache2 102.00 0.32 3.03 3.35 10000 select_column+column 25.00 2.32 4.94 7.26 100000 select_diff_key 0.00 0.03 0.12 0.15 500 select_distinct 10.00 0.09 1.36 1.45 800 select_group 27.00 0.16 1.43 1.59 2911 select_group_when_MANY_tables 30.00 0.36 0.76 1.12 10000 select_join 2.00 0.06 0.42 0.48 100 select_key 132.00 4.73 31.29 36.02 200000 select_key2 143.00 9.07 52.71 61.78 200000 select_key2_return_key 140.00 7.25 46.41 53.66 200000 select_key2_return_prim 141.00 9.84 73.40 83.24 200000 select_key_prefix 143.00 8.45 45.45 53.90 200000 select_key_prefix_join 9.00 0.35 3.78 4.13 100 select_key_return_key 127.00 8.17 64.31 72.48 200000 select_many_fields 15.00 1.55 7.49 9.04 2000 select_range 74.00 0.95 7.87 8.82 410 select_range_key2 15.00 0.50 5.71 6.21 25010 select_range_prefix 16.00 0.58 5.13 5.71 25010 select_simple 23.00 1.64 4.17 5.81 100000 select_simple_cache 23.00 1.61 4.59 6.20 100000 select_simple_join 1.00 0.05 0.64 0.69 500 update_big 14.00 0.00 0.00 0.00 10 update_of_key 21.00 3.18 0.33 3.51 50000 update_of_key_big 12.00 0.02 0.00 0.02 501 update_of_primary_key_many_keys 19.00 0.06 0.00 0.06 256 update_with_key 104.00 16.13 2.19 18.32 300000 update_with_key_prefix 44.00 4.22 9.88 14.10 100000 wisc_benchmark 5.00 1.12 2.25 3.37 114 TOTALS 3228.00 189.73 642.94 832.67 3425950 $
トータル
