Benchmark DBD suite: 2.15 Date of test: 2006-03-02 14:04:58 Running tests on: Linux 2.6.11.4-21.10-default i686 Server version: MySQL 4.1.10a Max Hardware: AMD Athlon(tm) XP 2400+ Seagate ST380011A IDE-HDD@7200 RPM 741/741GX/M741 Chipset 512 MByte RAM alter-table: Total time: 58 wallclock secs ( 0.08 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.09 CPU) ATIS: Total time: 19 wallclock secs ( 6.56 usr 1.24 sys + 0.00 cusr 0.00 csys = 7.80 CPU) big-tables: Total time: 22 wallclock secs ( 4.90 usr 2.48 sys + 0.00 cusr 0.00 csys = 7.38 CPU) connect: Total time: 134 wallclock secs (56.56 usr 11.57 sys + 0.00 cusr 0.00 csys = 68.13 CPU) create: Total time: 1320 wallclock secs ( 9.19 usr 0.95 sys + 0.00 cusr 0.00 csys = 10.14 CPU) insert: Total time: 1864 wallclock secs (527.44 usr 62.94 sys + 0.00 cusr 0.00 csys = 590.38 CPU) select: Total time: 499 wallclock secs (55.15 usr 5.91 sys + 0.00 cusr 0.00 csys = 61.06 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 7 wallclock secs ( 2.06 usr 0.65 sys + 0.00 cusr 0.00 csys = 2.71 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 25.00 0.03 0.00 0.03 100 alter_table_drop 24.00 0.04 0.01 0.05 91 connect 12.00 7.68 0.70 8.38 10000 connect+select_1_row 17.00 9.19 0.87 10.06 10000 connect+select_simple 15.00 8.45 0.76 9.21 10000 count 12.00 0.05 0.00 0.05 100 count_distinct 9.00 0.48 0.03 0.51 1000 count_distinct_2 10.00 0.55 0.03 0.58 1000 count_distinct_big 25.00 4.77 1.11 5.88 120 count_distinct_group 10.00 1.00 0.13 1.13 1000 count_distinct_group_on_key 11.00 0.48 0.04 0.52 1000 count_distinct_group_on_key_parts 10.00 1.01 0.14 1.15 1000 count_distinct_key_prefix 8.00 0.48 0.04 0.52 1000 count_group_on_key_parts 12.00 0.90 0.12 1.02 1000 count_on_key 135.00 17.58 1.08 18.66 50100 create+drop 405.00 2.85 0.27 3.12 10000 create_MANY_tables 500.00 2.59 0.25 2.84 10000 create_index 4.00 0.00 0.00 0.00 8 create_key+drop 410.00 2.91 0.25 3.16 10000 create_table 1.00 0.01 0.00 0.01 31 delete_all_many_keys 247.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 247.00 0.01 0.00 0.01 128 delete_key 2.00 0.25 0.07 0.32 10000 delete_range 7.00 0.00 0.00 0.00 12 drop_index 5.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.22 0.07 0.29 10000 insert 39.00 7.19 2.67 9.86 350768 insert_duplicates 10.00 2.26 0.78 3.04 100000 insert_key 278.00 11.38 1.63 13.01 100000 insert_many_fields 6.00 0.54 0.07 0.61 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 7.00 0.02 0.00 0.02 60 min_max_on_key 31.00 16.52 1.43 17.95 85000 multiple_value_insert 1.00 0.26 0.02 0.28 100000 once_prepared_select 27.00 8.45 1.55 10.00 100000 order_by_big 25.00 13.60 3.28 16.88 10 order_by_big_key 21.00 13.86 3.41 17.27 10 order_by_big_key2 19.00 13.65 3.17 16.82 10 order_by_big_key_desc 20.00 13.94 3.33 17.27 10 order_by_big_key_diff 21.00 13.66 3.15 16.81 10 order_by_big_key_prefix 20.00 13.71 3.16 16.87 10 order_by_key2_diff 3.00 1.34 0.31 1.65 500 order_by_key_prefix 1.00 0.77 0.15 0.92 500 order_by_range 2.00 0.79 0.18 0.97 500 outer_join 19.00 0.01 0.00 0.01 10 outer_join_found 17.00 0.00 0.00 0.00 10 outer_join_not_found 12.00 0.00 0.00 0.00 500 outer_join_on_key 12.00 0.00 0.00 0.00 10 prepared_select 55.00 25.55 1.94 27.49 100000 select_1_row 12.00 2.20 1.17 3.37 100000 select_1_row_cache 11.00 3.53 1.23 4.76 100000 select_2_rows 15.00 7.16 2.03 9.19 100000 select_big 19.00 13.69 3.26 16.95 80 select_big_str 23.00 10.93 1.93 12.86 10000 select_cache 42.00 4.36 0.33 4.69 10000 select_cache2 41.00 4.49 0.35 4.84 10000 select_column+column 14.00 1.67 0.77 2.44 100000 select_diff_key 58.00 0.24 0.03 0.27 500 select_distinct 5.00 1.25 0.24 1.49 800 select_group 16.00 1.47 0.14 1.61 2911 select_group_when_MANY_tables 3.00 0.62 0.11 0.73 10000 select_join 1.00 0.34 0.05 0.39 100 select_key 102.00 57.08 4.26 61.34 200000 select_key2 117.00 58.32 4.45 62.77 200000 select_key2_return_key 110.00 55.73 3.73 59.46 200000 select_key2_return_prim 113.00 56.67 4.14 60.81 200000 select_key_prefix 120.00 59.46 4.34 63.80 200000 select_key_prefix_join 5.00 2.77 0.66 3.43 100 select_key_return_key 97.00 49.36 3.84 53.20 200000 select_many_fields 16.00 4.35 2.41 6.76 2000 select_range 188.00 5.48 1.26 6.74 410 select_range_key2 14.00 5.92 0.46 6.38 25010 select_range_prefix 15.00 6.00 0.47 6.47 25010 select_simple 8.00 3.26 1.26 4.52 100000 select_simple_cache 7.00 2.48 0.84 3.32 100000 select_simple_join 1.00 0.46 0.08 0.54 500 update_big 12.00 0.01 0.00 0.01 10 update_of_key 21.00 2.21 0.43 2.64 50000 update_of_key_big 10.00 0.06 0.01 0.07 501 update_of_primary_key_many_keys 50.00 0.04 0.01 0.05 256 update_with_key 44.00 7.61 2.39 10.00 300000 update_with_key_prefix 16.00 5.53 1.18 6.71 100000 wisc_benchmark 3.00 1.39 0.40 1.79 114 TOTALS 4145.00 655.19 84.46 739.65 3425950