Comparative Mysql DragonFlyBsd v1.0 / FreeBSD v4.10

rmkml rmkml at wanadoo.fr
Sat Jul 17 18:44:02 PDT 2004


my two same hardware is :
CM Intel S845WD1
PIV 2.8Ghz (no htt) 533Mhz
512Mo ECC
250G Ide Maxtor
Ctrl IDE ATA100 Intel


on freebsd v4.10 (hardware A)
        default install
        # pkg_add -r
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.10-release/databases/mysql-client-4.0.18_1.tgz

        # pkg_add -r
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.10-release/databases/mysql-scripts-4.0.18.tg

        # pkg_add -r
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.10-release/databases/mysql-server-4.0.18_1.tgz

        # cd /usr/local ; /usr/local/bin/mysqld_safe &
        # cd ~/sql-bench ; perl run-all-tests # extracted in mysql4020 !

and dragonfly v1.0 (hardware B)
        default install
        enabled crond & syslogd
        # pkg_add -r http://gobsd.com/packages/All/mysql-client-4.0.20.tgz
        # pkg_add -r http://gobsd.com/packages/All/mysql-scripts-4.0.20.tgz
        # pkg_add -r http://gobsd.com/packages/All/mysql-server-4.0.20.tgz
        # cd /usr/local ; /usr/local/bin/mysqld_safe &
        # cd /usr/local/lib/perl5/site_perl/5.005/
        # ln -s i386-freebsd i386-dragonfly
        # cd ~/sql-bench ; perl run-all-tests # extracted in mysql4020




FreeBSD v4.10 results :

Benchmark DBD suite: 2.15
Date of test:        2004-07-18  2:41:51
Running tests on:    FreeBSD 4.10-RELEASE i386
Arguments:
Comments:
Limits from:
Server version:      MySQL 4.0.18
Optimization:        None
Hardware:

ATIS: Total time: 19 wallclock secs ( 3.76 usr  1.97 sys +  0.00 cusr  0.00
csys =  0.00 CPU)
alter-table: Total time: 11 wallclock secs ( 0.08 usr  0.01 sys +  0.00
cusr  0.00 csys =  0.00 CPU)
big-tables: Total time: 28 wallclock secs ( 4.76 usr  9.38 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
connect: Total time: 107 wallclock secs (34.46 usr 16.09 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
create: Total time: 81 wallclock secs ( 5.47 usr  0.89 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
insert: Total time: 2239 wallclock secs (328.05 usr 236.35 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
select: Total time: 520 wallclock secs (33.17 usr  8.09 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
transactions: Test skipped because the database doesn't support transactions

wisconsin: Total time:  6 wallclock secs ( 1.15 usr  0.57 sys +  0.00 cusr
0.00 csys =  0.00 CPU)

All 9 test executed successfully

Totals per operation:
Operation             seconds     usr     sys     cpu   tests
alter_table_add                        5.00    0.03    0.00    0.00     100
alter_table_drop                       4.00    0.02    0.01    0.00      91
connect                                9.00    4.36    0.86    0.00   10000
connect+select_1_row                  11.00    5.33    1.05    0.00   10000
connect+select_simple                 10.00    5.09    1.04    0.00   10000
count                                  9.00    0.02    0.02    0.00     100
count_distinct                        16.00    0.28    0.02    0.00    1000
count_distinct_2                      17.00    0.33    0.04    0.00    1000
count_distinct_big                    26.00    2.99    2.31    0.00     120
count_distinct_group                  29.00    0.62    0.16    0.00    1000
count_distinct_group_on_key           19.00    0.23    0.09    0.00    1000
count_distinct_group_on_key_parts     28.00    0.62    0.17    0.00    1000
count_distinct_key_prefix             13.00    0.24    0.04    0.00    1000
count_group_on_key_parts              19.00    0.46    0.18    0.00    1000
count_on_key                         190.00    8.94    1.44    0.00   50100
create+drop                           23.00    1.58    0.25    0.00   10000
create_MANY_tables                    30.00    1.38    0.11    0.00   10000
create_index                           1.00    0.00    0.00    0.00       8
create_key+drop                       22.00    1.84    0.23    0.00   10000
create_table                           0.00    0.00    0.00    0.00      31
delete_all_many_keys                 257.00    0.02    0.00    0.00       1
delete_big                             0.00    0.00    0.00    0.00       1
delete_big_many_keys                 257.00    0.02    0.00    0.00     128
delete_key                             2.00    0.27    0.14    0.00   10000
delete_range                           4.00    0.00    0.00    0.00      12
drop_index                             1.00    0.00    0.00    0.00       8
drop_table                             0.00    0.00    0.00    0.00      28
drop_table_when_MANY_tables            2.00    0.21    0.12    0.00   10000
insert                                47.00    7.45    3.90    0.00  350768
insert_duplicates                     10.00    1.75    0.96    0.00  100000
insert_key                           462.00    6.80    2.14    0.00  100000
insert_many_fields                     3.00    0.20    0.08    0.00    2000
insert_select_1_key                    2.00    0.00    0.00    0.00       1
insert_select_2_keys                   2.00    0.00    0.00    0.00       1
min_max                                9.00    0.01    0.02    0.00      60
min_max_on_key                        73.00   11.74    1.90    0.00   85000
multiple_value_insert                  2.00    0.69    0.05    0.00  100000
order_by_big                          52.00    8.76   17.91    0.00      10
order_by_big_key                      69.00   10.63   27.50    0.00      10
order_by_big_key2                     67.00    9.95   27.73    0.00      10
order_by_big_key_desc                 69.00   10.31   28.05    0.00      10
order_by_big_key_diff                 57.00    9.29   20.43    0.00      10
order_by_big_key_prefix               67.00   10.01   26.96    0.00      10
order_by_key2_diff                     3.00    0.77    0.30    0.00     500
order_by_key_prefix                    1.00    0.43    0.16    0.00     500
order_by_range                         2.00    0.45    0.22    0.00     500
outer_join                            25.00    0.01    0.00    0.00      10
outer_join_found                      24.00    0.00    0.00    0.00      10
outer_join_not_found                  15.00    0.00    0.01    0.00     500
outer_join_on_key                     18.00    0.00    0.00    0.00      10
select_1_row                          12.00    2.77    1.95    0.00  100000
select_1_row_cache                    10.00    2.12    1.61    0.00  100000
select_2_rows                         12.00    2.82    2.69    0.00  100000
select_big                            55.00    9.54   21.65    0.00      80
select_big_str                        15.00    5.79    1.70    0.00   10000
select_cache                          39.00    2.38    0.38    0.00   10000
select_cache2                         41.00    2.67    0.32    0.00   10000
select_column+column                  13.00    2.56    2.23    0.00  100000
select_diff_key                       45.00    0.19    0.00    0.00     500
select_distinct                        5.00    0.77    0.20    0.00     800
select_group                          23.00    0.79    0.17    0.00    2911
select_group_when_MANY_tables          4.00    0.47    0.19    0.00   10000
select_join                            1.00    0.16    0.16    0.00     100
select_key                            80.00   35.18    7.93    0.00  200000
select_key2                           84.00   36.64    8.36    0.00  200000
select_key2_return_key                78.00   35.05    6.98    0.00  200000
select_key2_return_prim               83.00   36.41    7.28    0.00  200000
select_key_prefix                     84.00   36.51    8.27    0.00  200000
select_key_prefix_join                 6.00    1.60    1.18    0.00     100
select_key_return_key                 77.00   34.49    7.01    0.00  200000
select_many_fields                    25.00    4.56    9.30    0.00    2000
select_range                          47.00    3.39    1.34    0.00     410
select_range_key2                      8.00    3.19    0.66    0.00   25010
select_range_prefix                   10.00    3.13    0.77    0.00   25010
select_simple                          8.00    2.05    1.55    0.00  100000
select_simple_cache                    7.00    1.59    1.42    0.00  100000
select_simple_join                     1.00    0.23    0.16    0.00     500
update_big                            12.00    0.00    0.01    0.00      10
update_of_key                         11.00    1.83    0.88    0.00   50000
update_of_key_big                      8.00    0.02    0.01    0.00     501
update_of_primary_key_many_keys      189.00    0.03    0.01    0.00     256
update_with_key                       46.00    7.66    5.45    0.00  300000
update_with_key_prefix                21.00    5.47    3.22    0.00  100000
wisc_benchmark                         1.00    0.69    0.21    0.00     114
TOTALS                              3244.00  406.88  271.85    0.00 3225950




DragonFly v1.0 results :

Benchmark DBD suite: 2.15
Date of test:        2004-07-18  4:40:18
Running tests on:    DragonFly 1.0-RELEASE i386
Arguments:
Comments:
Limits from:
Server version:      MySQL 4.0.20
Optimization:        None
Hardware:

ATIS: Total time: 20 wallclock secs ( 3.63 usr  1.84 sys +  0.00 cusr  0.00
csys =  0.00 CPU)
alter-table: Total time: 12 wallclock secs ( 0.02 usr  0.02 sys +  0.00
cusr  0.00 csys =  0.00 CPU)
big-tables: Total time: 15 wallclock secs ( 4.48 usr  3.62 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
connect: Total time: 108 wallclock secs (34.82 usr 14.95 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
create: Total time: 86 wallclock secs ( 5.02 usr  0.97 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
insert: Total time: 2708 wallclock secs (331.78 usr 165.47 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
select: Total time: 537 wallclock secs (33.06 usr  7.75 sys +  0.00 cusr
0.00 csys =  0.00 CPU)
transactions: Test skipped because the database doesn't support transactions

wisconsin: Total time:  6 wallclock secs ( 1.06 usr  0.72 sys +  0.00 cusr
0.00 csys =  0.00 CPU)

All 9 test executed successfully

Totals per operation:
Operation             seconds     usr     sys     cpu   tests
alter_table_add                        4.00    0.01    0.02    0.00     100
alter_table_drop                       4.00    0.00    0.01    0.00      91
connect                                9.00    4.53    0.68    0.00   10000
connect+select_1_row                  12.00    5.45    0.89    0.00   10000
connect+select_simple                 11.00    5.27    1.00    0.00   10000
count                                 10.00    0.06    0.00    0.00     100
count_distinct                        16.00    0.17    0.02    0.00    1000
count_distinct_2                      16.00    0.24    0.04    0.00    1000
count_distinct_big                    27.00    2.80    1.62    0.00     120
count_distinct_group                  35.00    0.74    0.17    0.00    1000
count_distinct_group_on_key           20.00    0.30    0.07    0.00    1000
count_distinct_group_on_key_parts     35.00    0.73    0.21    0.00    1000
count_distinct_key_prefix             13.00    0.23    0.05    0.00    1000
count_group_on_key_parts              19.00    0.49    0.17    0.00    1000
count_on_key                         196.00    8.91    1.32    0.00   50100
create+drop                           22.00    1.58    0.21    0.00   10000
create_MANY_tables                    35.00    0.99    0.13    0.00   10000
create_index                           2.00    0.00    0.00    0.00       8
create_key+drop                       23.00    1.67    0.29    0.00   10000
create_table                           0.00    0.00    0.00    0.00      31
delete_all_many_keys                 417.00    0.02    0.01    0.00       1
delete_big                             0.00    0.00    0.00    0.00       1
delete_big_many_keys                 417.00    0.02    0.01    0.00     128
delete_key                             1.00    0.30    0.12    0.00   10000
delete_range                           5.00    0.00    0.00    0.00      12
drop_index                             1.00    0.00    0.00    0.00       8
drop_table                             0.00    0.00    0.00    0.00      28
drop_table_when_MANY_tables            2.00    0.26    0.16    0.00   10000
insert                                45.00    7.79    3.55    0.00  350768
insert_duplicates                     10.00    1.66    0.95    0.00  100000
insert_key                           820.00    7.91    1.77    0.00  100000
insert_many_fields                     4.00    0.24    0.05    0.00    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                                9.00    0.01    0.00    0.00      60
min_max_on_key                        76.00   11.63    2.12    0.00   85000
multiple_value_insert                  2.00    0.55    0.15    0.00  100000
order_by_big                          26.00    7.90    5.09    0.00      10
order_by_big_key                      59.00   11.16   19.37    0.00      10
order_by_big_key2                     54.00   11.04   19.84    0.00      10
order_by_big_key_desc                 58.00   11.21   19.77    0.00      10
order_by_big_key_diff                 52.00    9.91   15.41    0.00      10
order_by_big_key_prefix               54.00   10.81   19.24    0.00      10
order_by_key2_diff                     2.00    0.72    0.41    0.00     500
order_by_key_prefix                    2.00    0.48    0.19    0.00     500
order_by_range                         2.00    0.65    0.30    0.00     500
outer_join                            27.00    0.00    0.00    0.00      10
outer_join_found                      27.00    0.00    0.00    0.00      10
outer_join_not_found                  16.00    0.00    0.00    0.00     500
outer_join_on_key                     18.00    0.00    0.00    0.00      10
select_1_row                          12.00    2.77    2.07    0.00  100000
select_1_row_cache                     9.00    2.13    1.70    0.00  100000
select_2_rows                         12.00    3.10    2.33    0.00  100000
select_big                            35.00    9.13   12.31    0.00      80
select_big_str                        15.00    5.62    1.30    0.00   10000
select_cache                          37.00    2.61    0.27    0.00   10000
select_cache2                         37.00    2.60    0.28    0.00   10000
select_column+column                  11.00    2.42    1.89    0.00  100000
select_diff_key                       42.00    0.23    0.02    0.00     500
select_distinct                        5.00    0.73    0.30    0.00     800
select_group                          24.00    0.83    0.16    0.00    2911
select_group_when_MANY_tables          4.00    0.52    0.18    0.00   10000
select_join                            1.00    0.17    0.13    0.00     100
select_key                            79.00   35.78    7.15    0.00  200000
select_key2                           88.00   37.40    7.01    0.00  200000
select_key2_return_key                81.00   35.21    6.52    0.00  200000
select_key2_return_prim               71.00   34.80    5.63    0.00  200000
select_key_prefix                     72.00   35.85    6.09    0.00  200000
select_key_prefix_join                 5.00    1.42    1.00    0.00     100
select_key_return_key                 76.00   34.70    6.23    0.00  200000
select_many_fields                    11.00    4.24    3.58    0.00    2000
select_range                          50.00    3.41    1.74    0.00     410
select_range_key2                      9.00    3.25    0.53    0.00   25010
select_range_prefix                    9.00    3.49    0.64    0.00   25010
select_simple                         10.00    1.89    1.59    0.00  100000
select_simple_cache                    7.00    1.62    1.49    0.00  100000
select_simple_join                     1.00    0.24    0.12    0.00     500
update_big                            14.00    0.01    0.00    0.00      10
update_of_key                         13.00    1.82    0.58    0.00   50000
update_of_key_big                      9.00    0.03    0.00    0.00     501
update_of_primary_key_many_keys      249.00    0.02    0.00    0.00     256
update_with_key                       42.00    7.57    2.76    0.00  300000
update_with_key_prefix                18.00    4.95    2.14    0.00  100000
wisc_benchmark                         2.00    0.65    0.32    0.00     114
TOTALS                              3880.00  409.65  193.47    0.00 3225950



Regards

Rmkml at xxxxxxxxxx






More information about the Kernel mailing list