Brian> This is really directed at the MySQL testing team butI would be Brian> interested in anyone who cares to comment:

Brian> When you give performance statistics, is it fair or honest to compare an Brian> SQL database running on NT with one running on LINUX? Brian> (or indeed ANY UNIX)

Brian> I have been an SQL database dba and/or freelance contractor in the Brian> testing and trouble-shooting business for 10 years and in the same type Brian> of business full-time for eight years before that and have worked with Brian> ORACLE, SYBASE, INFORMIX and INGRES and in general they are all slower Brian> than MySQL - some considerably so. It depends on how much functionality Brian> is built in to the server, SYBASE the least therefore the fastest, Brian> ORACLE the most therefore the slowest.

Brian> However, I have SYBASE 11.0.3.3 running on identical x86 boxes, one Brian> under NT 4.00(SP3) and one under LINUX 5.02 and on average the LINUX Brian> version runs between 2-3 times faster. Whether a particular Brian> test/function runs 2 or 3 times faster depends on disk i/o, faster if Brian> there is more i/o.

Brian> Hands-on-heart, honest, comments anyone?

Brian> Regards, Brian Brian> EMail: bri...@btimmins.com Brian> URL: http://www.btimmins.com/

Hi!

Hope the following table helps: (All tests run on the same computer):

1 mysql-Linux_2.0.36_i586 : MySQL 3.22.19 AMD-K6 350 MHz, 256M RAM, key_buffer=16M 2 mysql-win98 : MySQL 3.22.19a "AMD-K6 350 MHz, 256M memory, key_buffer=16M" 3 mysql-NT_4.0 : MySQL 3.22.18 gamma "AMD-K6 350 MHz, 256M memory, key_buffer=16M"

====================================================== Operation | 1| 2| 3| |mysql-L|mysql-w|mysql-N|

------------------------------------------------------ Results per test in seconds: |

------------------------------------------------------ ATIS | 99| 242| 154| alter-table | 1006| 2161| 5748| big-tables | 75| 223| 180| connect | 260| 557| 472| create | 20| 136| 79| insert | 5919| +4950| 9228| select | +2139| +3027| +2059| wisconsin | 32| 88| 54|

------------------------------------------------------ The results per operation: |

------------------------------------------------------ alter_table_add (992) | 552| 1159| 3055| alter_table_drop (496) | 434| 956| 2572| connect (10000) | 53| 79| 81| connect+select (10000) | 59| 107| 97| count (100) | 130| 90| 98| count_on_key (50100) | +1281| +2078| +1230| create+drop (1000) | 3| 25| 17| create_index (8) | 10| 22| 60| create_key+drop (1000) | 4| 27| 25| create_table (1031) | 8| 49| 28| delete_big (15) | 1837| 207| 1229| delete_key (500) | 5| 1| 1| drop_index (8) | 9| 22| 60| drop_table (1028) | 1| 7| 2| insert (350768) | 239| 746| 535| insert_duplicates (300000) | 31| 150| 85| insert_key (100000) | 1404| 486| 4010| insert_many_fields (2000) | 23| 33| 54| min_max (60) | 67| 49| 51| min_max_on_key (73000) | 383| 464| 389| multiple_value_inser (100000)| 14| 58| 24| order_by (10) | 147| 388| 204| order_by_key (10) | 85| 274| 152| select (20000) | 11| 55| 25| select_big (10080) | 164| 471| 323| select_distinct (800) | 24| 50| 31| select_group (3811) | 188| 257| 171| select_join (200) | 41| 117| 61| select_key (200000) | 322| +846| 525| select_key_prefix (200000) | 343| +855| 532| select_many_fields (2000) | 52| 188| 119| select_range (25420) | 607| 636| 566| select_range_prefix (25010) | 51| 105| 71| select_simple (20000) | 60| 122| 99| select_simple_join (500) | 4| 11| 7| update_key (500) | 4| 1| 1| update_key_big (501) | 54| 56| 44| update_of_key (256) | 807| 108| 1313| wisc_benchmark (114) | 10| 22| 15|

------------------------------------------------------ TOTALS | +9521| +11377| +17962| ======================================================

Regards, Monty