Benchmark DBD suite: 2.15 Date of test: 2008-04-15 7:22:34 Running tests on: Linux 2.6.9-42.0.8.ELsmp x86_64 Arguments: Comments: Limits from: Server version: MySQL 5.0.27 log/ Optimization: None Hardware: alter-table: Total time: 45 wallclock secs ( 0.07 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.09 CPU) ATIS: Total time: 22 wallclock secs ( 4.66 usr 0.85 sys + 0.00 cusr 0.00 csys = 5.51 CPU) big-tables: Total time: 13 wallclock secs ( 4.47 usr 1.40 sys + 0.00 cusr 0.00 csys = 5.87 CPU) connect: Total time: 76 wallclock secs (26.85 usr 16.25 sys + 0.00 cusr 0.00 csys = 43.10 CPU) create: Warning: Can't execute create. Check the file 'output/create-mysql-Linux_2.6.9_42.0.8.ELsmp_x86_64' Failed (output/create-mysql-Linux_2.6.9_42.0.8.ELsmp_x86_64) insert: Total time: 904 wallclock secs (284.97 usr 66.71 sys + 0.00 cusr 0.00 csys = 351.68 CPU) select: Total time: 361 wallclock secs (28.29 usr 4.79 sys + 0.00 cusr 0.00 csys = 33.08 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 6 wallclock secs ( 1.82 usr 0.75 sys + 0.00 cusr 0.00 csys = 2.57 CPU) Of 9 tests, 1 tests didn't work Totals per operation: Operation seconds usr sys cpu tests alter_table_add 20.00 0.01 0.00 0.01 100 alter_table_drop 17.00 0.02 0.00 0.02 91 connect 5.00 3.48 0.88 4.36 10000 connect+select_1_row 7.00 3.66 1.15 4.81 10000 connect+select_simple 6.00 3.51 1.07 4.58 10000 count 13.00 0.03 0.00 0.03 100 count_distinct 11.00 0.17 0.04 0.21 1000 count_distinct_2 16.00 0.20 0.01 0.21 1000 count_distinct_big 42.00 3.84 0.55 4.39 120 count_distinct_group 13.00 0.58 0.07 0.65 1000 count_distinct_group_on_key 14.00 0.17 0.04 0.21 1000 count_distinct_group_on_key_parts 13.00 0.51 0.06 0.57 1000 count_distinct_key_prefix 10.00 0.15 0.01 0.16 1000 count_group_on_key_parts 17.00 0.64 0.07 0.71 1000 count_on_key 133.00 6.25 1.16 7.41 50100 create_index 3.00 0.00 0.00 0.00 8 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 63.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 63.00 0.01 0.00 0.01 128 delete_key 1.00 0.22 0.17 0.39 10000 delete_range 4.00 0.00 0.00 0.00 12 drop_index 5.00 0.01 0.00 0.01 8 drop_table 0.00 0.00 0.00 0.00 28 insert 40.00 6.94 5.97 12.91 350768 insert_duplicates 10.00 1.84 1.76 3.60 100000 insert_key 68.00 3.60 1.82 5.42 100000 insert_many_fields 3.00 0.13 0.04 0.17 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 3.00 0.00 0.00 0.00 1 min_max 9.00 0.02 0.00 0.02 60 min_max_on_key 17.00 9.75 1.72 11.47 85000 multiple_value_insert 2.00 0.23 0.03 0.26 100000 once_prepared_select 17.00 5.76 2.44 8.20 100000 order_by_big 18.00 11.29 1.70 12.99 10 order_by_big_key 15.00 12.04 1.81 13.85 10 order_by_big_key2 13.00 11.27 1.74 13.01 10 order_by_big_key_desc 15.00 12.00 1.78 13.78 10 order_by_big_key_diff 17.00 11.35 1.59 12.94 10 order_by_big_key_prefix 13.00 11.10 1.74 12.84 10 order_by_key2_diff 2.00 1.01 0.13 1.14 500 order_by_key_prefix 1.00 0.57 0.06 0.63 500 order_by_range 2.00 0.68 0.08 0.76 500 outer_join 19.00 0.00 0.00 0.00 10 outer_join_found 18.00 0.00 0.01 0.01 10 outer_join_not_found 20.00 0.01 0.00 0.01 500 outer_join_on_key 18.00 0.00 0.00 0.00 10 prepared_select 24.00 12.03 2.47 14.50 100000 select_1_row 10.00 2.41 2.05 4.46 100000 select_1_row_cache 9.00 2.57 2.09 4.66 100000 select_2_rows 11.00 2.97 2.29 5.26 100000 select_big 15.00 11.82 1.69 13.51 80 select_big_str 4.00 1.65 0.69 2.34 10000 select_cache 39.00 1.40 0.23 1.63 10000 select_cache2 39.00 1.22 0.21 1.43 10000 select_column+column 11.00 2.40 2.10 4.50 100000 select_diff_key 0.00 0.06 0.02 0.08 500 select_distinct 7.00 0.84 0.12 0.96 800 select_group 20.00 0.71 0.10 0.81 2911 select_join 1.00 0.28 0.04 0.32 100 select_key 47.00 26.27 5.07 31.34 200000 select_key2 49.00 25.59 5.17 30.76 200000 select_key2_return_key 43.00 23.25 4.68 27.93 200000 select_key2_return_prim 46.00 24.40 4.96 29.36 200000 select_key_prefix 48.00 25.06 5.23 30.29 200000 select_key_prefix_join 6.00 2.21 0.35 2.56 100 select_key_return_key 43.00 23.88 4.64 28.52 200000 select_many_fields 9.00 4.34 1.36 5.70 2000 select_range 45.00 4.80 0.70 5.50 410 select_range_key2 6.00 2.48 0.38 2.86 25010 select_range_prefix 7.00 2.76 0.46 3.22 25010 select_simple 7.00 2.21 2.00 4.21 100000 select_simple_cache 6.00 1.99 1.93 3.92 100000 select_simple_join 1.00 0.39 0.07 0.46 500 update_big 12.00 0.00 0.00 0.00 10 update_of_key 7.00 1.18 0.99 2.17 50000 update_of_key_big 8.00 0.01 0.02 0.03 501 update_of_primary_key_many_keys 12.00 0.01 0.01 0.02 256 update_with_key 36.00 6.85 5.93 12.78 300000 update_with_key_prefix 13.00 3.74 2.07 5.81 100000 wisc_benchmark 2.00 1.21 0.21 1.42 114 TOTALS 1461.00 346.05 90.03 436.08 3375950