Hi;
Comparing the benchmark results I have got from a P450/Linux 2.2.5 box vs
the one supplied by Monty, I find that the insert test is much slower.
All other tests compare well.
I've tried both my compiled version (using the Pentium optimized settings)
and also the binary RPM from the distribution.
I'm not sure if the slowness can be attributed to 1 less CPU and the
lesser amount of RAM. The machine I used had a SCSI disk.
In both cases, logging was turned off and debug was *not* compiled in.
key_buffer was set to 16m in both tests.
Thanks for any pointers.
Suresh
------------------------------------------------------------
The result logs which where found and the options:
1 mysql-Linux-2.2.5_450Mhz, : MySQL3.22.21
PIII 450 1 CPU 128M key_buffer=16m static compiled, egcs 1.1.2, SCSI
2 mysql-Linux-2.2.5_450Mhz_binary_RPM : MySQL 3.22.21
PIII 450 1 CPU 128M key_buffer=16m binary RPM, SCSI
3 mysql-Linux_2.2.1_i686 : MySQL 3.22.18
pentiumpro 400mz x2, 256M, SCSI, gcc 2.9 compiled, key_buffer=16M
======================================================
Operation | 1| 2| 3|
|mysql-L|mysql-L|mysql-L|
------------------------------------------------------
Results per test in seconds: |
------------------------------------------------------
ATIS | 56| 58| 66|
alter-table | 568| 567| 812|
big-tables | 43| 41| 49|
connect | 97| 97| 151|
create | 9| 9| 9|
insert | 5069| 4452| 1558|
select | 1046| 1037| +1164|
wisconsin | 18| 18| 20|
------------------------------------------------------
The results per operation: |
------------------------------------------------------
alter_table_add (992) | 314| 314| 453|
alter_table_drop (496) | 243| 242| 343|
connect (10000) | 13| 13| 31|
connect+select (10000) | 16| 17| 35|
count (100) | 64| 58| 62|
count_on_key (50100) | 625| 638| +719|
create+drop (1000) | 1| 1| 1|
create_index (8) | 6| 6| 9|
create_key+drop (1000) | 2| 2| 3|
create_table (1031) | 4| 4| 4|
delete_big (15) | 1545| 1514| 156|
delete_key (500) | 4| 37| 26|
drop_index (8) | 5| 5| 6|
drop_table (1028) | 1| 1| 1|
insert (350768) | 127| 125| 147|
insert_duplicates (300000) | 18| 18| 26|
insert_key (100000) | 1948| 1317| 156|
insert_many_fields (2000) | 12| 11| 13|
min_max (60) | 39| 35| 38|
min_max_on_key (73000) | 188| 183| 198|
multiple_value_inser (100000)| 10| 8| 9|
order_by (10) | 74| 80| 72|
order_by_key (10) | 53| 52| 47|
select (20000) | 6| 6| 7|
select_big (10080) | 100| 97| 91|
select_distinct (800) | 14| 14| 17|
select_group (3811) | 96| 96| 105|
select_join (200) | 22| 24| 26|
select_key (200000) | 182| 188| 212|
select_key_prefix (200000) | 198| 200| 243|
select_many_fields (2000) | 31| 30| 35|
select_range (25420) | 310| 289| 331|
select_range_prefix (25010) | 33| 32| 37|
select_simple (20000) | 17| 16| 36|
select_simple_join (500) | 2| 3| 3|
update_key (500) | 0| 2| 3|
update_key_big (501) | 53| 30| 37|
update_of_key (256) | 523| 558| 79|
wisc_benchmark (114) | 6| 6| 7|
------------------------------------------------------
TOTALS | 6905| 6272| +3824|
======================================================
