Benchmark DBD suite: 2.9 Date of test: 2000-11-18 18:20:34 Running tests on: Linux 2.2.13-SMP alpha Arguments: Comments: Alpha DS20 2x500 MHz, 2G memory, key_buffer=16M; gcc 2.95.2 + ccc Limits from: Server version: MySQL 3.23.28 gamma ATIS: Total time: 38 wallclock secs ( 8.93 usr 5.72 sys + 0.00 cusr 0.00 csys = 0.00 CPU) alter-table: Total time: 375 wallclock secs ( 0.30 usr 0.15 sys + 0.00 cusr 0.00 csys = 0.00 CPU) big-tables: Total time: 42 wallclock secs ( 9.09 usr 11.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) connect: Total time: 77 wallclock secs (34.21 usr 17.98 sys + 0.00 cusr 0.00 csys = 0.00 CPU) create: Total time: 134 wallclock secs (10.66 usr 4.31 sys + 0.00 cusr 0.00 csys = 0.00 CPU) insert: Total time: 1851 wallclock secs (450.58 usr 224.15 sys + 0.00 cusr 0.00 csys = 0.00 CPU) select: Total time: 1215 wallclock secs (57.43 usr 28.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU) wisconsin: Total time: 19 wallclock secs ( 3.77 usr 2.78 sys + 0.00 cusr 0.00 csys = 0.00 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 205.00 0.17 0.07 0.00 992 alter_table_drop 161.00 0.07 0.03 0.00 496 connect 14.00 8.15 2.36 0.00 10000 connect+select_1_row 17.00 8.55 3.39 0.00 10000 connect+select_simple 16.00 8.31 3.17 0.00 10000 count 49.00 0.03 0.01 0.00 100 count_distinct 86.00 0.71 0.21 0.00 2000 count_distinct_big 140.00 7.24 8.69 0.00 120 count_distinct_group 72.00 1.07 0.63 0.00 1000 count_distinct_group_on_key 42.00 0.45 0.15 0.00 1000 count_distinct_group_on_key_parts 72.00 1.08 0.62 0.00 1000 count_group_on_key_parts 39.00 0.99 0.61 0.00 1000 count_on_key 454.00 15.83 4.45 0.00 50100 create+drop 13.00 2.86 0.85 0.00 10000 create_MANY_tables 91.00 1.85 0.61 0.00 10000 create_index 4.00 0.00 0.00 0.00 8 create_key+drop 17.00 4.39 1.33 0.00 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all 11.00 0.00 0.00 0.00 12 delete_all_many_keys 49.00 0.01 0.01 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 49.00 0.01 0.01 0.00 128 delete_key 4.00 0.65 0.54 0.00 10000 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 7.00 0.63 0.62 0.00 10000 insert 137.00 26.71 20.07 0.00 350768 insert_duplicates 39.00 5.58 6.03 0.00 100000 insert_key 93.00 8.08 5.73 0.00 100000 insert_many_fields 14.00 0.34 0.16 0.00 2000 insert_select_1_key 4.00 0.00 0.00 0.00 1 insert_select_2_keys 7.00 0.00 0.00 0.00 1 min_max 21.00 0.02 0.00 0.00 60 min_max_on_key 186.00 25.42 7.61 0.00 85000 multiple_value_insert 7.00 2.19 0.05 0.00 100000 order_by_big 54.00 22.86 21.67 0.00 10 order_by_big_key 37.00 22.01 14.79 0.00 10 order_by_big_key2 37.00 22.02 14.86 0.00 10 order_by_big_key_desc 37.00 22.03 14.87 0.00 10 order_by_big_key_diff 52.00 23.11 21.71 0.00 10 order_by_key 3.00 1.17 0.64 0.00 500 order_by_key2_diff 5.00 2.05 1.25 0.00 500 order_by_range 5.00 1.17 0.65 0.00 500 outer_join 61.00 0.01 0.00 0.00 10 outer_join_found 55.00 0.00 0.00 0.00 10 outer_join_not_found 35.00 0.01 0.00 0.00 500 outer_join_on_key 40.00 0.00 0.00 0.00 10 select_1_row 3.00 0.41 1.01 0.00 10000 select_2_rows 3.00 0.38 0.89 0.00 10000 select_big 57.00 30.30 20.70 0.00 10080 select_column+column 3.00 0.27 0.75 0.00 10000 select_diff_key 154.00 0.23 0.06 0.00 500 select_distinct 11.00 1.72 0.95 0.00 800 select_group 52.00 1.62 0.67 0.00 2911 select_group_when_MANY_tables 6.00 0.92 0.90 0.00 10000 select_join 12.00 4.31 3.11 0.00 200 select_key 137.00 75.62 20.87 0.00 200000 select_key2 144.00 76.78 20.52 0.00 200000 select_key_prefix 144.00 76.89 20.33 0.00 200000 select_many_fields 28.00 8.73 10.85 0.00 2000 select_range 228.00 8.51 5.59 0.00 410 select_range_key2 20.00 6.50 2.29 0.00 25010 select_range_prefix 18.00 6.46 2.33 0.00 25010 select_simple 2.00 0.29 0.75 0.00 10000 select_simple_join 2.00 0.62 0.39 0.00 500 update_big 25.00 0.00 0.00 0.00 10 update_of_key 47.00 3.41 2.97 0.00 50256 update_of_key_big 18.00 0.04 0.04 0.00 501 update_with_key 134.00 21.08 18.70 0.00 300000 wisc_benchmark 4.00 1.92 0.94 0.00 114 TOTALS 3797.00 574.84 294.06 0.00 1946237