Benchmark DBD suite: 2.15 Date of test: 2005-03-01 7:45:19 Running tests on: Darwin 7.8.0 Power Macintosh Arguments: Comments: Limits from: mysql,pg,solid Server version: MySQL 4.1.10 standard Optimization: None Hardware: alter-table: Total time: 69 wallclock secs ( 0.20 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.27 CPU) ATIS: Total time: 20 wallclock secs ( 8.16 usr 9.70 sys + 0.00 cusr 0.00 csys = 17.86 CPU) big-tables: Total time: 34 wallclock secs ( 7.40 usr 22.33 sys + 0.00 cusr 0.00 csys = 29.73 CPU) connect: Total time: 140 wallclock secs (28.98 usr 39.39 sys + 0.00 cusr 0.00 csys = 68.37 CPU) create: Total time: 73 wallclock secs ( 2.85 usr 2.06 sys + 0.00 cusr 0.00 csys = 4.91 CPU) insert: Total time: 3272 wallclock secs (446.06 usr 381.01 sys + 0.00 cusr 0.00 csys = 827.07 CPU) select: Total time: 128 wallclock secs (39.10 usr 33.57 sys + 0.00 cusr 0.00 csys = 72.67 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 11 wallclock secs ( 2.35 usr 3.33 sys + 0.00 cusr 0.00 csys = 5.68 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 66.00 0.17 0.03 0.20 992 connect 9.00 5.84 1.56 7.40 10000 connect+select_1_row 13.00 6.70 2.10 8.80 10000 count 17.00 0.09 0.00 0.09 100 count_distinct 0.00 0.17 0.06 0.23 1000 count_distinct_2 0.00 0.16 0.07 0.23 1000 count_distinct_big 19.00 7.68 11.20 18.88 120 count_distinct_group 2.00 0.94 0.60 1.54 1000 count_distinct_group_on_key 0.00 0.17 0.09 0.26 1000 count_distinct_group_on_key_parts 2.00 0.97 0.54 1.51 1000 count_distinct_key_prefix 1.00 0.15 0.04 0.19 1000 count_group_on_key_parts 1.00 0.87 0.57 1.44 1000 count_on_key 29.00 6.65 3.20 9.85 50100 create+drop 23.00 0.97 0.72 1.69 10000 create_MANY_tables 14.00 0.46 0.16 0.62 5000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 26.00 1.22 0.69 1.91 10000 create_table 1.00 0.00 0.00 0.00 31 delete_all_many_keys 24.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 24.00 0.01 0.00 0.01 128 delete_key 2.00 0.22 0.25 0.47 10000 delete_range 6.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 4.00 0.10 0.11 0.21 5000 insert 64.00 5.98 9.85 15.83 350768 insert_duplicates 12.00 2.02 2.98 5.00 100000 insert_key 59.00 5.12 2.72 7.84 100000 insert_many_fields 5.00 0.16 0.05 0.21 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 5.00 0.01 0.01 0.02 60 min_max_on_key 38.00 12.69 5.13 17.82 85000 once_prepared_select 38.00 5.54 7.79 13.33 100000 order_by_big 64.00 22.56 35.47 58.03 10 order_by_big_key 56.00 23.23 32.57 55.80 10 order_by_big_key2 56.00 22.45 33.22 55.67 10 order_by_big_key_desc 55.00 23.21 32.15 55.36 10 order_by_big_key_diff 63.00 22.86 35.29 58.15 10 order_by_big_key_prefix 56.00 22.68 33.06 55.74 10 order_by_key2_diff 6.00 1.97 1.43 3.40 500 order_by_key_prefix 3.00 1.08 0.71 1.79 500 order_by_range 3.00 1.14 0.54 1.68 500 outer_join 4.00 0.00 0.01 0.01 10 outer_join_found 4.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 2.00 0.00 0.01 0.01 10 prepared_select 49.00 14.11 6.89 21.00 100000 select_1_row 26.00 3.72 7.36 11.08 100000 select_1_row_cache 11.00 2.74 6.43 9.17 100000 select_2_rows 37.00 3.40 7.01 10.41 100000 select_big 56.00 23.21 32.67 55.88 80 select_big_str 20.00 4.08 9.16 13.24 10000 select_cache 2.00 1.26 0.77 2.03 10000 select_cache2 50.00 1.05 0.41 1.46 10000 select_column+column 24.00 2.50 5.77 8.27 100000 select_diff_key 68.00 0.22 0.01 0.23 500 select_distinct 3.00 1.49 1.63 3.12 800 select_group 4.00 0.96 0.59 1.55 2701 select_group_when_MANY_tables 6.00 0.10 0.38 0.48 5000 select_join 1.00 0.40 0.66 1.06 100 select_key 394.00 34.77 16.55 51.32 200000 select_key2 438.00 38.31 15.77 54.08 200000 select_key2_return_key 426.00 37.41 12.63 50.04 200000 select_key2_return_prim 433.00 39.32 13.57 52.89 200000 select_key_prefix 185.00 33.47 16.02 49.49 200000 select_key_prefix_join 11.00 4.56 5.85 10.41 100 select_key_return_key 418.00 35.36 13.23 48.59 200000 select_many_fields 29.00 7.24 22.28 29.52 2000 select_range 23.00 8.59 11.55 20.14 410 select_range_key2 5.00 3.63 1.59 5.22 25010 select_range_prefix 6.00 3.52 1.63 5.15 25010 select_simple_join 1.00 0.56 0.60 1.16 500 update_big 22.00 0.00 0.00 0.00 10 update_of_key 22.00 1.12 1.43 2.55 50000 update_of_key_big 10.00 0.00 0.01 0.01 501 update_of_primary_key_many_keys 11.00 0.00 0.04 0.04 256 update_with_key 51.00 5.34 8.37 13.71 300000 update_with_key_prefix 17.00 5.09 2.56 7.65 100000 wisc_benchmark 5.00 1.85 2.30 4.15 114 TOTALS 3750.00 525.63 480.70 1006.33 3101541