Benchmark DBD suite: 2.15 Date of test: 2006-03-02 12:25:34 Running tests on: Linux 2.6.15.4 i686, Debian 3.1 Arguments: All tests Server version: MySQL 4.0.24_Debian 10sarge1 log Hardware: Dual Core AMD Opteron(tm) Processor 270 (2000 MHz) 3Ware SATAII-RAID-Controller 9550SX-4LP 4x WD Raptor RAID5 (1x HotSpare), 74 GByte, 10k RPM 2048 Mbyte RAM alter-table: Total time: 49 wallclock secs ( 0.02 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.04 CPU) ATIS: Total time: 6 wallclock secs ( 4.38 usr 1.13 sys + 0.00 cusr 0.00 csys = 5.51 CPU) big-tables: Total time: 7 wallclock secs ( 2.42 usr 2.17 sys + 0.00 cusr 0.00 csys = 4.59 CPU) connect: Total time: 63 wallclock secs (19.23 usr 7.69 sys + 0.00 cusr 0.00 csys = 26.92 CPU) create: Total time: 485 wallclock secs ( 0.83 usr 0.21 sys + 0.00 cusr 0.00 csys = 1.04 CPU) insert: Total time: 1174 wallclock secs (208.92 usr 45.48 sys + 0.00 cusr 0.00 csys = 254.40 CPU) select: Total time: 58 wallclock secs (21.90 usr 4.24 sys + 0.00 cusr 0.00 csys = 26.14 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 5 wallclock secs ( 1.63 usr 0.80 sys + 0.00 cusr 0.00 csys = 2.43 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 22.00 0.01 0.00 0.01 100 alter_table_drop 20.00 0.01 0.00 0.01 91 connect 3.00 2.17 0.23 2.40 10000 connect+select_1_row 5.00 2.40 0.36 2.76 10000 connect+select_simple 4.00 2.34 0.33 2.67 10000 count 9.00 0.02 0.00 0.02 100 count_distinct 0.00 0.09 0.01 0.10 1000 count_distinct_2 1.00 0.08 0.02 0.10 1000 count_distinct_big 6.00 4.25 1.08 5.33 120 count_distinct_group 1.00 0.52 0.10 0.62 1000 count_distinct_group_on_key 0.00 0.10 0.01 0.11 1000 count_distinct_group_on_key_parts 0.00 0.52 0.10 0.62 1000 count_distinct_key_prefix 0.00 0.08 0.03 0.11 1000 count_group_on_key_parts 0.00 0.51 0.11 0.62 1000 count_on_key 15.00 3.98 0.47 4.45 50100 create+drop 118.00 0.06 0.03 0.09 10000 create_MANY_tables 239.00 0.47 0.07 0.54 10000 create_index 3.00 0.00 0.00 0.00 8 create_key+drop 124.00 0.11 0.02 0.13 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 202.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 202.00 0.00 0.00 0.00 128 delete_key 1.00 0.06 0.04 0.10 10000 delete_range 10.00 0.00 0.00 0.00 12 drop_index 4.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 2.00 0.05 0.04 0.09 10000 insert 29.00 3.45 2.01 5.46 350768 insert_duplicates 7.00 1.48 0.48 1.96 100000 insert_key 291.00 1.96 0.52 2.48 100000 insert_many_fields 3.00 0.08 0.01 0.09 2000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 1.00 0.00 0.00 0.00 1 min_max 2.00 0.03 0.00 0.03 60 min_max_on_key 10.00 6.33 0.90 7.23 85000 multiple_value_insert 1.00 0.20 0.00 0.20 100000 order_by_big 18.00 12.10 2.94 15.04 10 order_by_big_key 15.00 12.37 3.10 15.47 10 order_by_big_key2 15.00 12.13 2.95 15.08 10 order_by_big_key_desc 16.00 12.53 2.92 15.45 10 order_by_big_key_diff 17.00 12.11 2.90 15.01 10 order_by_big_key_prefix 15.00 12.07 2.96 15.03 10 order_by_key2_diff 2.00 1.08 0.25 1.33 500 order_by_key_prefix 0.00 0.52 0.13 0.65 500 order_by_range 2.00 0.62 0.08 0.70 500 outer_join 1.00 0.00 0.00 0.00 10 outer_join_found 1.00 0.00 0.00 0.00 10 outer_join_not_found 1.00 0.00 0.00 0.00 500 outer_join_on_key 1.00 0.00 0.00 0.00 10 select_1_row 10.00 1.92 1.14 3.06 100000 select_1_row_cache 4.00 1.38 1.05 2.43 100000 select_2_rows 10.00 2.10 1.29 3.39 100000 select_big 15.00 12.27 2.94 15.21 80 select_big_str 5.00 2.18 0.51 2.69 10000 select_cache 1.00 0.77 0.13 0.90 10000 select_cache2 28.00 0.93 0.09 1.02 10000 select_column+column 10.00 1.64 0.93 2.57 100000 select_diff_key 40.00 0.04 0.00 0.04 500 select_distinct 1.00 0.88 0.19 1.07 800 select_group 1.00 0.57 0.11 0.68 2911 select_group_when_MANY_tables 2.00 0.14 0.05 0.19 10000 select_join 1.00 0.25 0.06 0.31 100 select_key 35.00 16.66 3.02 19.68 200000 select_key2 36.00 16.35 3.06 19.41 200000 select_key2_return_key 34.00 16.26 2.26 18.52 200000 select_key2_return_prim 35.00 16.25 2.66 18.91 200000 select_key_prefix 35.00 16.83 2.83 19.66 200000 select_key_prefix_join 3.00 2.30 0.63 2.93 100 select_key_return_key 34.00 16.57 2.54 19.11 200000 select_many_fields 4.00 2.34 2.16 4.50 2000 select_range 7.00 4.70 1.26 5.96 410 select_range_key2 3.00 1.80 0.35 2.15 25010 select_range_prefix 2.00 1.81 0.34 2.15 25010 select_simple 6.00 1.61 0.97 2.58 100000 select_simple_cache 5.00 1.48 0.88 2.36 100000 select_simple_join 0.00 0.29 0.08 0.37 500 update_big 10.00 0.00 0.00 0.00 10 update_of_key 26.00 0.44 0.27 0.71 50000 update_of_key_big 12.00 0.00 0.00 0.00 501 update_of_primary_key_many_keys 128.00 0.00 0.01 0.01 256 update_with_key 44.00 3.40 1.61 5.01 300000 update_with_key_prefix 8.00 1.77 1.24 3.01 100000 wisc_benchmark 2.00 1.27 0.63 1.90 114 TOTALS 2037.00 254.09 60.49 314.58 3225950