run-pg-linux_2.0.36_i686-cmp-mysql,pg,solid

开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip

Benchmark DBD suite: 2.0b
Date of test:        1999-03-09 18:59:51
Running tests on:    Linux 2.0.36 i686
Arguments:           --force
Comments:            
Limits from:         mysql,pg,solid
Server version:      PostgreSQL 6.4

ATIS: Estimated total time: 1520 wallclock secs (16.64 usr  1.66 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)
alter-table: Total time:  4 wallclock secs ( 0.80 usr  0.07 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)
big-tables: Total time: 470 wallclock secs ( 7.63 usr  0.60 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)
connect: Total time: 349 wallclock secs (42.65 usr 10.17 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)
create: Total time: 168 wallclock secs ( 6.14 usr  0.53 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)
insert: Estimated total time: 133319 wallclock secs (625.54 usr 64.54 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)
select: Estimated total time: 2069 wallclock secs (51.44 usr  5.76 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)
wisconsin: Total time: 452 wallclock secs (22.00 usr  2.22 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

All 8 test executed successfully
Tests with estimated time have a + at end of line

Totals per operation:
Operation             seconds     usr     sys     cpu   tests
alter_table_add             1    0.15    0.00    0.00     293 
connect                    84    9.71    2.81    0.00   10000 
connect+select            210   17.17    5.07    0.00   10000 
count                     156    0.04    0.01    0.00     100 
count_on_key             1685   27.36    3.43    0.00   50100 +
create+drop                46    1.86    0.23    0.00    1000 
create_index                1    0.00    0.00    0.00       7 
create_key+drop            33    1.56    0.14    0.00    1000 
create_table               68    1.54    0.11    0.00    1031 
delete_big                 76    0.01    0.00    0.00      15 
delete_key                634    0.32    0.09    0.00     500 
drop_index                  0    0.00    0.00    0.00       7 
drop_table                 17    0.62    0.03    0.00    1028 
insert                   1213  198.22   22.62    0.00  350768 
insert_duplicates         164   46.42    5.41    0.00  300000 
insert_key                944   57.30    6.79    0.00  100000 
insert_many_fields        123    1.37    0.14    0.00    2000 
min_max                    49    0.04    0.00    0.00      60 
min_max_on_key           2153   18.34    1.75    0.00   73000 +
order_by                  269   26.89    1.27    0.00      10 
order_by_key              265   26.66    1.20    0.00      10 
select                     35   10.00    1.13    0.00   20000 
select_big                136   32.59    2.75    0.00   10080 
select_distinct           139    2.82    0.22    0.00     800 
select_group             5688    2.22    0.22    0.00    3101 
select_join              1262    5.94    0.52    0.00     200 +
select_key                634  122.95   13.45    0.00  200000 +
select_key_prefix         639  123.46   13.29    0.00  200000 +
select_many_fields        347    6.25    0.46    0.00    2000 
select_range            34472    3.80    0.07    0.00   25410 ++
select_range_prefix     34462    6.24    0.56    0.00   25000 ++
select_simple_join          6    1.02    0.10    0.00     500 
update_key                443    0.23    0.03    0.00     500 
update_key_big            978    0.34    0.06    0.00     501 
update_of_key            3569    0.14    0.03    0.00     256 
wisc_benchmark            310    5.05    0.37    0.00     114 
TOTALS                  91311  758.63   84.36    0.00 1389391 +++++++++