Benchmark DBD suite: 2.12
Date of test:        2000-12-24 15:30:34
Running tests on:    Linux 2.2.14-my-SMP i686
Arguments:           
Comments:            Intel Xeon, 2x550 Mhz, 1G ram, key_buffer=16M
Limits from:         
Server version:      MySQL 3.23.29a gamma

ATIS: Total time: 44 wallclock secs ( 9.18 usr  4.06 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
alter-table: Total time: 468 wallclock secs ( 0.25 usr  0.12 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
big-tables: Total time: 31 wallclock secs ( 8.67 usr  6.87 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
connect: Total time: 79 wallclock secs (34.39 usr 17.84 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
create: Total time: 126 wallclock secs (10.09 usr  3.20 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
insert: Total time: 2227 wallclock secs (451.81 usr 170.75 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
select: Total time: 1379 wallclock secs (61.35 usr 18.95 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
wisconsin: Total time: 16 wallclock secs ( 3.25 usr  1.72 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                      263.00    0.10    0.05    0.00     992 
alter_table_drop                     197.00    0.05    0.03    0.00     496 
connect                               12.00    7.18    2.61    0.00   10000 
connect+select_1_row                  15.00    7.75    3.29    0.00   10000 
connect+select_simple                 14.00    7.39    3.61    0.00   10000 
count                                 47.00    0.05    0.00    0.00     100 
count_distinct                       119.00    0.66    0.17    0.00    2000 
count_distinct_big                   111.00    7.48    5.86    0.00     120 
count_distinct_group                  80.00    1.02    0.43    0.00    1000 
count_distinct_group_on_key           60.00    0.40    0.08    0.00    1000 
count_distinct_group_on_key_parts     81.00    0.79    0.41    0.00    1000 
count_group_on_key_parts              54.00    1.00    0.47    0.00    1000 
count_on_key                         559.00   17.07    3.00    0.00   50100 
create+drop                           29.00    2.43    0.82    0.00   10000 
create_MANY_tables                    29.00    2.27    0.46    0.00   10000 
create_index                           4.00    0.00    0.00    0.00       8 
create_key+drop                       40.00    3.97    0.87    0.00   10000 
create_table                           0.00    0.00    0.00    0.00      31 
delete_all                            20.00    0.00    0.00    0.00      12 
delete_all_many_keys                 151.00    0.03    0.01    0.00       1 
delete_big                             0.00    0.00    0.00    0.00       1 
delete_big_many_keys                 151.00    0.03    0.01    0.00     128 
delete_key                             4.00    0.56    0.45    0.00   10000 
drop_index                             4.00    0.00    0.00    0.00       8 
drop_table                             0.00    0.01    0.00    0.00      28 
drop_table_when_MANY_tables           12.00    0.63    0.43    0.00   10000 
insert                               131.00   22.93   14.02    0.00  350768 
insert_duplicates                     24.00    3.18    3.05    0.00  100000 
insert_key                           154.00   10.52    4.42    0.00  100000 
insert_many_fields                     9.00    0.44    0.07    0.00    2000 
insert_select_1_key                    7.00    0.00    0.00    0.00       1 
insert_select_2_keys                   9.00    0.00    0.00    0.00       1 
min_max                               32.00    0.01    0.00    0.00      60 
min_max_on_key                       238.00   27.34    5.17    0.00   85000 
multiple_value_insert                  9.00    1.88    0.06    0.00  100000 
order_by_big                          52.00   22.29   15.95    0.00      10 
order_by_big_key                      34.00   23.91   10.39    0.00      10 
order_by_big_key2                     33.00   22.58   10.06    0.00      10 
order_by_big_key_desc                 36.00   23.89   10.41    0.00      10 
order_by_big_key_diff                 50.00   22.07   16.43    0.00      10 
order_by_big_key_prefix               32.00   22.21   10.50    0.00      10 
order_by_key2_diff                     5.00    1.12    0.07    0.00     500 
order_by_key_prefix                    3.00    1.10    0.38    0.00     500 
order_by_range                         5.00    1.14    0.41    0.00     500 
outer_join                            72.00    0.00    0.00    0.00      10 
outer_join_found                      67.00    0.00    0.01    0.00      10 
outer_join_not_found                  50.00    0.00    0.00    0.00     500 
outer_join_on_key                     57.00    0.01    0.00    0.00      10 
select_1_row                           2.00    0.45    0.57    0.00   10000 
select_2_rows                          3.00    0.59    0.61    0.00   10000 
select_big                            62.00   32.48   15.99    0.00   10080 
select_column+column                   3.00    0.58    0.68    0.00   10000 
select_diff_key                      191.00    0.33    0.03    0.00     500 
select_distinct                       11.00    1.84    0.70    0.00     800 
select_group                          67.00    1.60    0.52    0.00    2911 
select_group_when_MANY_tables         16.00    0.79    0.62    0.00   10000 
select_join                            2.00    0.57    0.28    0.00     100 
select_key                           126.00   68.35   14.42    0.00  200000 
select_key2                          132.00   69.41   13.86    0.00  200000 
select_key_prefix                    134.00   71.19   14.71    0.00  200000 
select_key_prefix_join                13.00    4.13    1.96    0.00     100 
select_many_fields                    22.00    8.22    6.80    0.00    2000 
select_range                         194.00    9.08    3.79    0.00     410 
select_range_key2                     18.00    6.36    1.64    0.00   25010 
select_range_prefix                   20.00    6.82    1.38    0.00   25010 
select_simple                          2.00    0.47    0.71    0.00   10000 
select_simple_join                     2.00    0.68    0.19    0.00     500 
update_big                            64.00    0.00    0.00    0.00      10 
update_of_key                         23.00    2.80    2.29    0.00   50000 
update_of_key_big                     33.00    0.11    0.03    0.00     501 
update_of_primary_key_many_keys       65.00    0.02    0.01    0.00     256 
update_with_key                      113.00   17.01   12.17    0.00  300000 
update_with_key_prefix                32.00    5.68    4.36    0.00  100000 
wisc_benchmark                         4.00    1.80    0.69    0.00     114 
TOTALS                              4519.00  578.85  223.47    0.00 2046247