Benchmark DBD suite: 2.15 Date of test: 2004-08-19 23:53:41 Running tests on: Linux 2.4.25-powerpc ppc Arguments: Comments: Limits from: Server version: MySQL 4.1.3 beta standard Optimization: None Hardware: alter-table: Total time: 144 wallclock secs ( 0.19 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.21 CPU) ATIS: Total time: 36 wallclock secs (12.65 usr 1.17 sys + 0.00 cusr 0.00 csys = 13.82 CPU) big-tables: Total time: 33 wallclock secs ( 8.63 usr 2.59 sys + 0.00 cusr 0.00 csys = 11.22 CPU) connect: Total time: 164 wallclock secs (71.99 usr 13.31 sys + 0.00 cusr 0.00 csys = 85.30 CPU) create: Total time: 218 wallclock secs ( 8.89 usr 0.97 sys + 0.00 cusr 0.00 csys = 9.86 CPU) insert: Total time: 2862 wallclock secs (746.44 usr 69.07 sys + 0.00 cusr 0.00 csys = 815.51 CPU) select: Total time: 1044 wallclock secs (81.62 usr 6.58 sys + 0.00 cusr 0.00 csys = 88.20 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 11 wallclock secs ( 3.64 usr 0.47 sys + 0.00 cusr 0.00 csys = 4.11 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 60.00 0.08 0.00 0.08 100 alter_table_drop 61.00 0.09 0.00 0.09 91 connect 13.00 9.47 0.60 10.07 10000 connect+select_1_row 21.00 12.54 1.01 13.55 10000 connect+select_simple 18.00 11.07 0.90 11.97 10000 count 31.00 0.06 0.00 0.06 100 count_distinct 27.00 0.55 0.05 0.60 1000 count_distinct_2 28.00 0.77 0.05 0.82 1000 count_distinct_big 50.00 11.50 1.23 12.73 120 count_distinct_group 28.00 1.92 0.18 2.10 1000 count_distinct_group_on_key 32.00 0.62 0.07 0.69 1000 count_distinct_group_on_key_parts 27.00 1.97 0.13 2.10 1000 count_distinct_key_prefix 22.00 0.48 0.02 0.50 1000 count_group_on_key_parts 37.00 1.57 0.13 1.70 1000 count_on_key 384.00 20.84 1.36 22.20 50100 create+drop 32.00 2.35 0.23 2.58 10000 create_MANY_tables 144.00 3.69 0.38 4.07 10000 create_index 12.00 0.00 0.00 0.00 8 create_key+drop 36.00 2.04 0.16 2.20 10000 create_table 0.00 0.03 0.00 0.03 31 delete_all_many_keys 357.00 0.06 0.01 0.07 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 357.00 0.06 0.01 0.07 128 delete_key 2.00 0.39 0.12 0.51 10000 delete_range 12.00 0.00 0.00 0.00 12 drop_index 11.00 0.00 0.00 0.00 8 drop_table 0.00 0.01 0.00 0.01 28 drop_table_when_MANY_tables 2.00 0.38 0.08 0.46 10000 insert 61.00 10.20 2.80 13.00 350768 insert_duplicates 15.00 3.51 0.77 4.28 100000 insert_key 417.00 13.16 1.84 15.00 100000 insert_many_fields 9.00 0.54 0.07 0.61 2000 insert_select_1_key 8.00 0.00 0.00 0.00 1 insert_select_2_keys 10.00 0.00 0.00 0.00 1 min_max 21.00 0.06 0.01 0.07 60 min_max_on_key 40.00 23.42 1.43 24.85 85000 multiple_value_insert 5.00 0.55 0.06 0.61 100000 once_prepared_select 31.00 8.99 1.77 10.76 100000 order_by_big 55.00 32.46 4.07 36.53 10 order_by_big_key 48.00 33.15 4.00 37.15 10 order_by_big_key2 45.00 32.62 4.06 36.68 10 order_by_big_key_desc 47.00 33.29 3.44 36.73 10 order_by_big_key_diff 48.00 32.23 4.04 36.27 10 order_by_big_key_prefix 45.00 32.48 4.24 36.72 10 order_by_key2_diff 4.00 2.81 0.33 3.14 500 order_by_key_prefix 3.00 1.54 0.11 1.65 500 order_by_range 3.00 1.74 0.18 1.92 500 outer_join 46.00 0.00 0.00 0.00 10 outer_join_found 44.00 0.00 0.01 0.01 10 outer_join_not_found 33.00 0.01 0.00 0.01 500 outer_join_on_key 40.00 0.01 0.00 0.01 10 prepared_select 61.00 29.89 2.09 31.98 100000 select_1_row 13.00 3.40 1.61 5.01 100000 select_1_row_cache 13.00 3.46 1.32 4.78 100000 select_2_rows 15.00 4.03 1.81 5.84 100000 select_big 46.00 32.39 4.31 36.70 80 select_big_str 36.00 18.28 2.47 20.75 10000 select_cache 115.00 4.57 0.24 4.81 10000 select_cache2 116.00 4.53 0.26 4.79 10000 select_column+column 16.00 3.82 1.33 5.15 100000 select_diff_key 152.00 0.46 0.02 0.48 500 select_distinct 9.00 2.36 0.30 2.66 800 select_group 45.00 2.20 0.16 2.36 2911 select_group_when_MANY_tables 4.00 0.43 0.12 0.55 10000 select_join 2.00 0.70 0.10 0.80 100 select_key 119.00 62.91 4.41 67.32 200000 select_key2 130.00 69.15 4.48 73.63 200000 select_key2_return_key 124.00 68.08 3.24 71.32 200000 select_key2_return_prim 129.00 65.82 4.01 69.83 200000 select_key_prefix 136.00 66.93 4.44 71.37 200000 select_key_prefix_join 13.00 6.19 0.44 6.63 100 select_key_return_key 113.00 61.77 3.69 65.46 200000 select_many_fields 23.00 8.07 2.52 10.59 2000 select_range 211.00 12.85 1.57 14.42 410 select_range_key2 20.00 7.78 0.58 8.36 25010 select_range_prefix 19.00 8.96 0.60 9.56 25010 select_simple 9.00 2.91 1.18 4.09 100000 select_simple_cache 10.00 3.00 1.08 4.08 100000 select_simple_join 2.00 0.88 0.08 0.96 500 update_big 39.00 0.00 0.00 0.00 10 update_of_key 19.00 1.94 0.56 2.50 50000 update_of_key_big 26.00 0.12 0.00 0.12 501 update_of_primary_key_many_keys 65.00 0.09 0.00 0.09 256 update_with_key 53.00 7.66 2.28 9.94 300000 update_with_key_prefix 22.00 6.53 1.19 7.72 100000 wisc_benchmark 4.00 2.61 0.24 2.85 114 TOTALS 4811.00 920.08 92.68 1012.76 3425950