List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:April 12 1999 3:11pm
Subject:Above-board and beyond reproach?
View as plain text  
>>>>> "Brian" == Brian Timmins <brian.timmins@stripped>
> writes:

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:   brian@stripped
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
Thread
Above-board and beyond reproach?Brian Timmins12 Apr
  • Re: Above-board and beyond reproach?Fred Read12 Apr
    • Re: Above-board and beyond reproach?Vivek Khera12 Apr
  • Above-board and beyond reproach?Michael Widenius13 Apr
  • Re: Above-board and beyond reproach?Ed Carp13 Apr
Re: Above-board and beyond reproach?Fred Lindberg12 Apr
Re: Above-board and beyond reproach?luuk12 Apr
Re: Above-board and beyond reproach?Christopher R. Jones12 Apr