Benchmark DBD suite: 2.15 Date of test: 2004-08-20 2:29:07 Running tests on: Linux 2.4.25-powerpc ppc Arguments: Comments: Limits from: Server version: MySQL 4.0.20 standard Optimization: None Hardware: alter-table: Total time: 141 wallclock secs ( 0.11 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.11 CPU) ATIS: Total time: 32 wallclock secs (12.56 usr 1.55 sys + 0.00 cusr 0.00 csys = 14.11 CPU) big-tables: Total time: 25 wallclock secs ( 8.41 usr 2.76 sys + 0.00 cusr 0.00 csys = 11.17 CPU) connect: Total time: 151 wallclock secs (66.45 usr 13.03 sys + 0.00 cusr 0.00 csys = 79.48 CPU) create: Total time: 172 wallclock secs ( 8.62 usr 1.08 sys + 0.00 cusr 0.00 csys = 9.70 CPU) insert: Total time: 2664 wallclock secs (686.19 usr 66.57 sys + 0.00 cusr 0.00 csys = 752.76 CPU) select: Total time: 1046 wallclock secs (76.58 usr 6.10 sys + 0.00 cusr 0.00 csys = 82.68 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 10 wallclock secs ( 3.38 usr 0.50 sys + 0.00 cusr 0.00 csys = 3.88 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 60.00 0.02 0.00 0.02 100 alter_table_drop 59.00 0.04 0.00 0.04 91 connect 12.00 7.88 0.64 8.52 10000 connect+select_1_row 18.00 10.25 0.91 11.16 10000 connect+select_simple 15.00 10.36 0.77 11.13 10000 count 32.00 0.04 0.01 0.05 100 count_distinct 26.00 0.36 0.00 0.36 1000 count_distinct_2 26.00 0.77 0.03 0.80 1000 count_distinct_big 47.00 11.35 1.32 12.67 120 count_distinct_group 33.00 1.90 0.20 2.10 1000 count_distinct_group_on_key 30.00 0.44 0.01 0.45 1000 count_distinct_group_on_key_parts 33.00 1.89 0.17 2.06 1000 count_distinct_key_prefix 22.00 0.38 0.01 0.39 1000 count_group_on_key_parts 33.00 1.46 0.16 1.62 1000 count_on_key 349.00 17.72 0.97 18.69 50100 create+drop 34.00 1.88 0.24 2.12 10000 create_MANY_tables 97.00 3.80 0.34 4.14 10000 create_index 11.00 0.01 0.00 0.01 8 create_key+drop 36.00 2.11 0.20 2.31 10000 create_table 0.00 0.01 0.01 0.02 31 delete_all_many_keys 334.00 0.02 0.02 0.04 1 delete_big 0.00 0.01 0.00 0.01 1 delete_big_many_keys 334.00 0.02 0.01 0.03 128 delete_key 2.00 0.33 0.08 0.41 10000 delete_range 11.00 0.00 0.00 0.00 12 drop_index 11.00 0.01 0.00 0.01 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 2.00 0.33 0.09 0.42 10000 insert 54.00 9.29 2.77 12.06 350768 insert_duplicates 13.00 3.22 0.79 4.01 100000 insert_key 497.00 11.59 1.48 13.07 100000 insert_many_fields 8.00 0.81 0.08 0.89 2000 insert_select_1_key 4.00 0.00 0.00 0.00 1 insert_select_2_keys 6.00 0.00 0.00 0.00 1 min_max 21.00 0.09 0.00 0.09 60 min_max_on_key 136.00 21.63 1.30 22.93 85000 multiple_value_insert 4.00 0.56 0.03 0.59 100000 once_prepared_select 25.00 8.32 1.67 9.99 100000 order_by_big 51.00 32.43 4.03 36.46 10 order_by_big_key 46.00 33.10 4.03 37.13 10 order_by_big_key2 44.00 32.56 3.80 36.36 10 order_by_big_key_desc 47.00 33.36 3.88 37.24 10 order_by_big_key_diff 50.00 32.36 4.06 36.42 10 order_by_big_key_prefix 44.00 32.67 4.44 37.11 10 order_by_key2_diff 4.00 2.85 0.35 3.20 500 order_by_key_prefix 3.00 1.53 0.17 1.70 500 order_by_range 5.00 1.75 0.22 1.97 500 outer_join 39.00 0.00 0.00 0.00 10 outer_join_found 38.00 0.02 0.00 0.02 10 outer_join_not_found 27.00 0.02 0.00 0.02 500 outer_join_on_key 35.00 0.00 0.00 0.00 10 prepared_select 49.00 27.13 1.90 29.03 100000 select_1_row 12.00 3.35 1.52 4.87 100000 select_1_row_cache 11.00 2.60 1.28 3.88 100000 select_2_rows 15.00 3.64 1.83 5.47 100000 select_big 45.00 32.43 3.27 35.70 80 select_big_str 35.00 18.52 2.22 20.74 10000 select_cache 119.00 4.83 0.25 5.08 10000 select_cache2 119.00 4.88 0.32 5.20 10000 select_column+column 14.00 3.78 1.44 5.22 100000 select_diff_key 149.00 0.42 0.06 0.48 500 select_distinct 7.00 2.31 0.38 2.69 800 select_group 43.00 2.15 0.19 2.34 2911 select_group_when_MANY_tables 3.00 0.50 0.21 0.71 10000 select_join 2.00 0.73 0.06 0.79 100 select_key 96.00 56.76 4.20 60.96 200000 select_key2 105.00 61.75 4.04 65.79 200000 select_key2_return_key 100.00 53.30 3.41 56.71 200000 select_key2_return_prim 103.00 58.43 3.74 62.17 200000 select_key_prefix 109.00 59.64 4.38 64.02 200000 select_key_prefix_join 12.00 6.15 0.74 6.89 100 select_key_return_key 95.00 57.37 3.56 60.93 200000 select_many_fields 17.00 7.60 2.68 10.28 2000 select_range 139.00 12.55 1.47 14.02 410 select_range_key2 16.00 6.36 0.62 6.98 25010 select_range_prefix 15.00 6.55 0.57 7.12 25010 select_simple 10.00 3.18 1.17 4.35 100000 select_simple_cache 9.00 2.88 1.25 4.13 100000 select_simple_join 1.00 0.86 0.10 0.96 500 update_big 33.00 0.00 0.00 0.00 10 update_of_key 15.00 1.46 0.43 1.89 50000 update_of_key_big 21.00 0.02 0.00 0.02 501 update_of_primary_key_many_keys 71.00 0.02 0.00 0.02 256 update_with_key 44.00 6.67 2.44 9.11 300000 update_with_key_prefix 18.00 5.16 0.88 6.04 100000 wisc_benchmark 4.00 2.65 0.27 2.92 114 TOTALS 4524.00 848.18 90.17 938.35 3425950