Benchmark DBD suite: 2.15 Date of test: 2006-03-02 14:22:04 Running tests on: Linux 2.6.11.4-21.10-smp i686, SuSE 9.3 Pro Arguments: All tests Server version: MySQL 5.0.16 standard Hardware: 2 x Intel(R) Xeon(TM) CPU 2.80GHz 3ware Inc 3ware Inc 3ware 7xxx/8xxx-series PATA/SATA-RAID 2 x 200GByte Samsung SATA-HDD@7200 RPM 2048 MByte RAM alter-table: Total time: 20 wallclock secs ( 0.05 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.08 CPU) ATIS: Total time: 10 wallclock secs ( 6.30 usr 1.77 sys + 0.00 cusr 0.00 csys = 8.07 CPU) big-tables: Total time: 11 wallclock secs ( 3.29 usr 3.47 sys + 0.00 cusr 0.00 csys = 6.76 CPU) connect: Total time: 111 wallclock secs (30.28 usr 21.42 sys + 0.00 cusr 0.00 csys = 51.70 CPU) create: Total time: 387 wallclock secs ( 7.48 usr 3.72 sys + 0.00 cusr 0.00 csys = 11.20 CPU) insert: Total time: 1102 wallclock secs (307.33 usr 93.47 sys + 0.00 cusr 0.00 csys = 400.80 CPU) select: Total time: 102 wallclock secs (31.98 usr 8.19 sys + 0.00 cusr 0.00 csys = 40.17 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 7 wallclock secs ( 2.32 usr 1.05 sys + 0.00 cusr 0.00 csys = 3.37 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 8.00 0.02 0.00 0.02 100 alter_table_drop 8.00 0.02 0.01 0.03 91 connect 7.00 4.27 0.87 5.14 10000 connect+select_1_row 9.00 4.78 1.27 6.05 10000 connect+select_simple 7.00 4.47 1.18 5.65 10000 count 9.00 0.02 0.01 0.03 100 count_distinct 1.00 0.15 0.02 0.17 1000 count_distinct_2 0.00 0.13 0.04 0.17 1000 count_distinct_big 9.00 5.59 1.69 7.28 120 count_distinct_group 1.00 0.68 0.19 0.87 1000 count_distinct_group_on_key 0.00 0.17 0.04 0.21 1000 count_distinct_group_on_key_parts 1.00 0.69 0.20 0.89 1000 count_distinct_key_prefix 0.00 0.13 0.04 0.17 1000 count_group_on_key_parts 1.00 0.70 0.16 0.86 1000 count_on_key 21.00 6.04 1.37 7.41 50100 create+drop 120.00 4.53 1.27 5.80 10000 create_MANY_tables 119.00 1.17 0.25 1.42 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 121.00 1.24 1.82 3.06 10000 create_table 1.00 0.01 0.00 0.01 31 delete_all_many_keys 82.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 82.00 0.01 0.00 0.01 128 delete_key 1.00 0.14 0.16 0.30 10000 delete_range 7.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 2.00 0.19 0.15 0.34 10000 insert 44.00 6.08 5.95 12.03 350768 insert_duplicates 11.00 2.10 1.53 3.63 100000 insert_key 162.00 3.81 1.62 5.43 100000 insert_many_fields 4.00 0.14 0.05 0.19 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 3.00 0.01 0.00 0.01 60 min_max_on_key 15.00 10.15 2.36 12.51 85000 multiple_value_insert 2.00 0.23 0.01 0.24 100000 once_prepared_select 31.00 5.97 2.73 8.70 100000 order_by_big 24.00 14.96 4.65 19.61 10 order_by_big_key 20.00 15.20 4.83 20.03 10 order_by_big_key2 20.00 14.89 4.64 19.53 10 order_by_big_key_desc 20.00 15.19 4.78 19.97 10 order_by_big_key_diff 22.00 14.79 4.63 19.42 10 order_by_big_key_prefix 19.00 14.71 4.61 19.32 10 order_by_key2_diff 3.00 1.33 0.40 1.73 500 order_by_key_prefix 1.00 0.74 0.20 0.94 500 order_by_range 2.00 0.74 0.20 0.94 500 outer_join 3.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.01 0.00 0.01 10 outer_join_not_found 2.00 0.00 0.00 0.00 500 outer_join_on_key 1.00 0.00 0.00 0.00 10 prepared_select 38.00 12.23 3.17 15.40 100000 select_1_row 17.00 2.42 2.99 5.41 100000 select_1_row_cache 7.00 2.09 2.73 4.82 100000 select_2_rows 20.00 2.53 3.25 5.78 100000 select_big 19.00 14.82 4.65 19.47 80 select_big_str 10.00 3.49 1.91 5.40 10000 select_cache 1.00 1.13 0.27 1.40 10000 select_cache2 58.00 1.49 0.32 1.81 10000 select_column+column 20.00 2.33 2.37 4.70 100000 select_diff_key 0.00 0.07 0.02 0.09 500 select_distinct 2.00 1.21 0.32 1.53 800 select_group 2.00 0.81 0.19 1.00 2911 select_group_when_MANY_tables 25.00 0.34 0.23 0.57 10000 select_join 1.00 0.36 0.10 0.46 100 select_key 62.00 25.21 6.10 31.31 200000 select_key2 66.00 24.67 5.96 30.63 200000 select_key2_return_key 62.00 24.01 5.04 29.05 200000 select_key2_return_prim 65.00 24.00 5.24 29.24 200000 select_key_prefix 66.00 25.12 6.13 31.25 200000 select_key_prefix_join 4.00 3.28 0.90 4.18 100 select_key_return_key 60.00 24.79 5.34 30.13 200000 select_many_fields 7.00 3.14 3.42 6.56 2000 select_range 10.00 6.41 1.68 8.09 410 select_range_key2 4.00 2.64 0.64 3.28 25010 select_range_prefix 3.00 2.63 0.63 3.26 25010 select_simple 7.00 2.02 2.44 4.46 100000 select_simple_cache 7.00 1.88 2.41 4.29 100000 select_simple_join 0.00 0.43 0.11 0.54 500 update_big 14.00 0.00 0.00 0.00 10 update_of_key 14.00 0.84 0.93 1.77 50000 update_of_key_big 12.00 0.02 0.01 0.03 501 update_of_primary_key_many_keys 44.00 0.00 0.01 0.01 256 update_with_key 44.00 4.96 5.36 10.32 300000 update_with_key_prefix 13.00 3.03 1.92 4.95 100000 wisc_benchmark 2.00 1.69 0.55 2.24 114 TOTALS 1822.00 382.30 131.27 513.57 3425950