ush sql-bench # ./run-all-tests --password="microsoft" --user="root" Benchmark DBD suite: 2.15 Date of test: 2006-03-02 0:29:56 Running tests on: Linux 2.6.14-hardened-r5 i686 Arguments: Comments: Limits from: Server version: MySQL 4.1.14 log/ Optimization: None Hardware: alter-table: Total time: 153 wallclock secs ( 0.07 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.09 CPU) ATIS: Total time: 20 wallclock secs ( 4.24 usr 1.86 sys + 0.00 cusr 0.00 csys = 6.10 CPU) big-tables: Total time: 27 wallclock secs ( 5.52 usr 4.09 sys + 0.00 cusr 0.00 csys = 9.61 CPU) connect: Total time: 126 wallclock secs (48.84 usr 15.34 sys + 0.00 cusr 0.00 csys = 64.18 CPU) create: Total time: 796 wallclock secs ( 6.04 usr 1.20 sys + 0.00 cusr 0.00 csys = 7.24 CPU) insert: Total time: 2327 wallclock secs (383.59 usr 86.64 sys + 0.00 cusr 0.00 csys = 470.23 CPU) select: Total time: 489 wallclock secs (39.62 usr 9.41 sys + 0.00 cusr 0.00 csys = 49.03 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 10 wallclock secs ( 1.74 usr 0.80 sys + 0.00 cusr 0.00 csys = 2.54 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 66.00 0.02 0.02 0.04 100 alter_table_drop 65.00 0.02 0.00 0.02 91 connect 13.00 7.97 0.78 8.75 10000 connect+select_1_row 16.00 8.07 1.06 9.13 10000 connect+select_simple 16.00 7.57 0.95 8.52 10000 count 13.00 0.02 0.00 0.02 100 count_distinct 12.00 0.32 0.03 0.35 1000 count_distinct_2 11.00 0.40 0.04 0.44 1000 count_distinct_big 107.00 2.34 2.28 4.62 120 count_distinct_group 11.00 0.60 0.28 0.88 1000 count_distinct_group_on_key 15.00 0.35 0.07 0.42 1000 count_distinct_group_on_key_parts 11.00 0.70 0.22 0.92 1000 count_distinct_key_prefix 11.00 0.37 0.05 0.42 1000 count_group_on_key_parts 16.00 0.56 0.27 0.83 1000 count_on_key 165.00 13.27 1.29 14.56 50100 create+drop 226.00 1.30 0.30 1.60 10000 create_MANY_tables 271.00 2.42 0.30 2.72 10000 create_index 11.00 0.00 0.00 0.00 8 create_key+drop 227.00 1.04 0.18 1.22 10000 create_table 1.00 0.02 0.00 0.02 31 delete_all_many_keys 385.00 0.04 0.02 0.06 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 385.00 0.03 0.02 0.05 128 delete_key 2.00 0.24 0.10 0.34 10000 delete_range 13.00 0.00 0.00 0.00 12 drop_index 11.00 0.00 0.00 0.00 8 drop_table 0.00 0.01 0.00 0.01 28 drop_table_when_MANY_tables 14.00 0.42 0.10 0.52 10000 insert 79.00 9.64 3.90 13.54 350768 insert_duplicates 14.00 2.32 0.98 3.30 100000 insert_key 444.00 11.12 2.33 13.45 100000 insert_many_fields 9.00 0.40 0.07 0.47 2000 insert_select_1_key 3.00 0.00 0.00 0.00 1 insert_select_2_keys 10.00 0.00 0.00 0.00 1 min_max 9.00 0.02 0.00 0.02 60 min_max_on_key 25.00 13.25 1.78 15.03 85000 multiple_value_insert 2.00 0.34 0.02 0.36 100000 once_prepared_select 27.00 6.71 2.46 9.17 100000 order_by_big 22.00 6.88 5.43 12.31 10 order_by_big_key 16.00 7.01 5.57 12.58 10 order_by_big_key2 15.00 6.81 5.35 12.16 10 order_by_big_key_desc 17.00 7.14 5.38 12.52 10 order_by_big_key_diff 18.00 6.99 5.14 12.13 10 order_by_big_key_prefix 16.00 6.87 5.27 12.14 10 order_by_key2_diff 2.00 0.73 0.44 1.17 500 order_by_key_prefix 2.00 0.42 0.18 0.60 500 order_by_range 1.00 0.56 0.24 0.80 500 outer_join 23.00 0.00 0.00 0.00 10 outer_join_found 21.00 0.01 0.00 0.01 10 outer_join_not_found 15.00 0.00 0.00 0.00 500 outer_join_on_key 19.00 0.00 0.00 0.00 10 prepared_select 53.00 22.09 2.44 24.53 100000 select_1_row 12.00 2.98 1.93 4.91 100000 select_1_row_cache 11.00 2.72 1.78 4.50 100000 select_2_rows 13.00 3.44 2.03 5.47 100000 select_big 16.00 6.83 5.38 12.21 80 select_big_str 19.00 8.65 1.99 10.64 10000 select_cache 44.00 3.31 0.39 3.70 10000 select_cache2 43.00 3.37 0.34 3.71 10000 select_column+column 12.00 2.76 1.72 4.48 100000 select_diff_key 60.00 0.19 0.03 0.22 500 select_distinct 4.00 0.75 0.36 1.11 800 select_group 20.00 1.02 0.17 1.19 2911 select_group_when_MANY_tables 58.00 0.86 0.32 1.18 10000 select_join 1.00 0.19 0.11 0.30 100 select_key 81.00 39.52 4.81 44.33 200000 select_key2 92.00 44.16 5.24 49.40 200000 select_key2_return_key 84.00 41.30 4.24 45.54 200000 select_key2_return_prim 88.00 43.26 4.54 47.80 200000 select_key_prefix 94.00 44.50 5.22 49.72 200000 select_key_prefix_join 6.00 1.61 0.99 2.60 100 select_key_return_key 75.00 38.72 4.41 43.13 200000 select_many_fields 18.00 5.12 4.02 9.14 2000 select_range 134.00 3.03 2.51 5.54 410 select_range_key2 12.00 4.48 0.55 5.03 25010 select_range_prefix 12.00 4.46 0.60 5.06 25010 select_simple 7.00 2.49 1.56 4.05 100000 select_simple_cache 7.00 2.19 1.54 3.73 100000 select_simple_join 1.00 0.29 0.12 0.41 500 update_big 26.00 0.00 0.00 0.00 10 update_of_key 40.00 1.93 0.63 2.56 50000 update_of_key_big 19.00 0.05 0.02 0.07 501 update_of_primary_key_many_keys 146.00 0.03 0.00 0.03 256 update_with_key 70.00 7.55 2.86 10.41 300000 update_with_key_prefix 22.00 5.51 1.15 6.66 100000 wisc_benchmark 2.00 1.01 0.38 1.39 114 TOTALS 4305.00 485.69 117.28 602.97 3425950 ush sql-bench #