Benchmark DBD suite: 2.15 Date of test: 2006-03-02 11:15:05 Running tests on: Linux 2.6.11.4-20a-smp i686, SuSE 9.3 Pro Arguments: All Tests Server version: MySQL 4.1.10a Max (SuSE RPM) Hardware: Intel(R) Pentium(R) 4 CPU 3.00GHz 3ware Inc 3ware Inc 3ware 7xxx/8xxx-series PATA/SATA-RAID RAID 1, 2x Samsung SATA HDD@7200 RPM with 200 GBytes 1024 MByte RAM Tyan 5112 mainboard alter-table: Total time: 40 wallclock secs ( 0.04 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.07 CPU) ATIS: Total time: 18 wallclock secs ( 6.24 usr 2.20 sys + 0.00 cusr 0.00 csys = 8.44 CPU) big-tables: Total time: 16 wallclock secs ( 4.61 usr 4.18 sys + 0.00 cusr 0.00 csys = 8.79 CPU) connect: Total time: 101 wallclock secs (38.79 usr 20.36 sys + 0.00 cusr 0.00 csys = 59.15 CPU) create: Total time: 244 wallclock secs ( 3.81 usr 1.28 sys + 0.00 cusr 0.00 csys = 5.09 CPU) insert: Total time: 1384 wallclock secs (387.86 usr 107.69 sys + 0.00 cusr 0.00 csys = 495.55 CPU) select: Total time: 352 wallclock secs (38.97 usr 9.33 sys + 0.00 cusr 0.00 csys = 48.30 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 8 wallclock secs ( 2.43 usr 1.18 sys + 0.00 cusr 0.00 csys = 3.61 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 18.00 0.01 0.00 0.01 100 alter_table_drop 16.00 0.01 0.01 0.02 91 connect 7.00 4.68 0.85 5.53 10000 connect+select_1_row 10.00 5.54 1.15 6.69 10000 connect+select_simple 9.00 5.12 1.10 6.22 10000 count 9.00 0.02 0.01 0.03 100 count_distinct 11.00 0.24 0.04 0.28 1000 count_distinct_2 15.00 0.26 0.04 0.30 1000 count_distinct_big 20.00 5.06 1.77 6.83 120 count_distinct_group 11.00 0.77 0.18 0.95 1000 count_distinct_group_on_key 14.00 0.27 0.05 0.32 1000 count_distinct_group_on_key_parts 11.00 0.75 0.20 0.95 1000 count_distinct_key_prefix 8.00 0.25 0.03 0.28 1000 count_group_on_key_parts 14.00 0.71 0.19 0.90 1000 count_on_key 129.00 9.45 1.56 11.01 50100 create+drop 77.00 1.23 0.34 1.57 10000 create_MANY_tables 86.00 1.09 0.24 1.33 10000 create_index 3.00 0.00 0.00 0.00 8 create_key+drop 77.00 0.66 0.20 0.86 10000 create_table 1.00 0.00 0.00 0.00 31 delete_all_many_keys 124.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 124.00 0.00 0.00 0.00 128 delete_key 3.00 0.31 0.16 0.47 10000 delete_range 7.00 0.00 0.00 0.00 12 drop_index 3.00 0.01 0.00 0.01 8 drop_table 0.00 0.01 0.00 0.01 28 drop_table_when_MANY_tables 2.00 0.28 0.19 0.47 10000 insert 48.00 10.26 6.40 16.66 350768 insert_duplicates 11.00 3.27 1.79 5.06 100000 insert_key 227.00 6.87 2.04 8.91 100000 insert_many_fields 4.00 0.31 0.04 0.35 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 6.00 0.02 0.00 0.02 60 min_max_on_key 23.00 13.38 2.64 16.02 85000 multiple_value_insert 2.00 0.23 0.02 0.25 100000 once_prepared_select 22.00 7.26 3.10 10.36 100000 order_by_big 21.00 13.36 5.09 18.45 10 order_by_big_key 20.00 14.26 5.76 20.02 10 order_by_big_key2 19.00 13.48 5.52 19.00 10 order_by_big_key_desc 20.00 14.07 5.95 20.02 10 order_by_big_key_diff 21.00 13.42 5.02 18.44 10 order_by_big_key_prefix 19.00 13.66 5.68 19.34 10 order_by_key2_diff 2.00 1.22 0.38 1.60 500 order_by_key_prefix 1.00 0.66 0.20 0.86 500 order_by_range 2.00 0.67 0.20 0.87 500 outer_join 19.00 0.00 0.00 0.00 10 outer_join_found 19.00 0.00 0.00 0.00 10 outer_join_not_found 13.00 0.00 0.00 0.00 500 outer_join_on_key 15.00 0.01 0.00 0.01 10 prepared_select 35.00 16.82 3.46 20.28 100000 select_1_row 13.00 2.94 2.64 5.58 100000 select_1_row_cache 12.00 3.38 2.83 6.21 100000 select_2_rows 14.00 3.70 3.17 6.87 100000 select_big 19.00 13.46 5.60 19.06 80 select_big_str 8.00 4.15 1.07 5.22 10000 select_cache 31.00 1.94 0.34 2.28 10000 select_cache2 31.00 1.94 0.33 2.27 10000 select_column+column 13.00 3.59 2.60 6.19 100000 select_diff_key 43.00 0.14 0.03 0.17 500 select_distinct 4.00 1.16 0.33 1.49 800 select_group 17.00 1.00 0.22 1.22 2911 select_group_when_MANY_tables 2.00 0.55 0.31 0.86 10000 select_join 1.00 0.34 0.12 0.46 100 select_key 66.00 33.61 7.05 40.66 200000 select_key2 71.00 36.36 7.27 43.63 200000 select_key2_return_key 65.00 33.21 5.74 38.95 200000 select_key2_return_prim 68.00 39.70 6.04 45.74 200000 select_key_prefix 71.00 36.43 7.23 43.66 200000 select_key_prefix_join 6.00 2.92 1.14 4.06 100 select_key_return_key 62.00 33.76 6.20 39.96 200000 select_many_fields 12.00 4.30 4.14 8.44 2000 select_range 60.00 6.00 2.19 8.19 410 select_range_key2 9.00 3.59 0.72 4.31 25010 select_range_prefix 9.00 3.60 0.73 4.33 25010 select_simple 8.00 2.97 2.44 5.41 100000 select_simple_cache 7.00 2.71 2.51 5.22 100000 select_simple_join 1.00 0.40 0.19 0.59 500 update_big 12.00 0.00 0.00 0.00 10 update_of_key 19.00 1.84 0.88 2.72 50000 update_of_key_big 10.00 0.03 0.01 0.04 501 update_of_primary_key_many_keys 44.00 0.03 0.01 0.04 256 update_with_key 50.00 9.73 5.59 15.32 300000 update_with_key_prefix 17.00 5.13 2.11 7.24 100000 wisc_benchmark 3.00 1.51 0.64 2.15 114 TOTALS 2261.00 476.08 144.02 620.10 3425950