List:General Discussion« Previous MessageNext Message »
From:Steve Orr Date:August 16 2002 6:49pm
Subject:RE: MySQL vs. Oracle (not speed)
View as plain text  
Regarding your testing... did you test many concurrent processes or
concurrent multi-user access? If you need concurrent multi-user access for
an OLTP app then you should test it.

To this end I developed a Perl routine which launched concurrent sessions in
the background. I could adjust the number of concurrent sessions via
arguments passed to the program. Each session performed a series of SQL
statements involving a real world mix of selects, inserts, updates and
deletes with pseudo random values provided for key column ranges. As soon as
I cranked up the volume to around 20 concurrent sessions MySQL barfed but
Oracle scaled much higher without a hitch. MySQL is great for raw speed with
individual queries or batch inserts but it doesn't seem to scale as well
with OLTP apps having many concurrent sessions. I'm hoping this will change
with InnoDB and future enhancements as MySQLAB strives for ANSI
compatibility like the other guys (PostgreSQL and Interbase).


-----Original Message-----
From: Kenneth Hylton [mailto:Kenneth.Hylton@stripped]
Sent: Friday, August 16, 2002 10:47 AM
To: mysql@stripped
Subject: RE: MySQL vs. Oracle (not speed)


Our experience has been totally the opposite.  

We recently ported a Delphi application from MS-SQL to MySQL.

The MySQL server was a less powerful box than MS-SQL was running on.

I will not go into great detail because some of the software is proprietary
and we make $$$ providing the service.

But here are out times:

Process #1 (heavy inserts, few updates) MS-SQL 9 hours MySQL 90 minutes
Process #2 (heavy updates, few inserts) MS-SQL 17 hours MySQL 2.5 hours

The databases were tuned to get maximum performance from MS-SQL (you can see
why) and NO changes were made to optimize
for MySQL, as we didn't need to.

Ken Hylton
Programmer Analyst IV
LEC Systems & Programming

Billing Concepts, Inc.
7411 John Smith Drive
San Antonio, Texas 78229-4898
(210) 949-7261



-----Original Message-----
From: Mary Stickney [mailto:mary.stickney@stripped]
Sent: Friday, August 16, 2002 8:53 AM
To: Francisco; Elizabeth Bogner; mysql@stripped
Subject: RE: MySQL vs. Oracle (not speed)



I have been doing speed tests....  the same query ran on MYSQL took 45
minutes
on MS-SQL  it took 11 minutes......

yes you do get what you pay for....

-----Original Message-----
From: Francisco [mailto:frsgti@stripped]
Sent: Friday, August 16, 2002 8:47 AM
To: Mary Stickney; Elizabeth Bogner; mysql@stripped
Subject: RE: MySQL vs. Oracle (not speed)


Hi,

I am beging using MySQL for quite a while and it is a
very good choice if you don't really need stored
procedures. MySQL provides a pretty good
implementation of a subset of MySQL-92, performance is
great, it is cross-platform, provides transactions,
and its price... well is free.

Hope it helps.
--- Mary Stickney <mary.stickney@stripped> wrote:
>
> It doesn't suport alot of differnt things....
> it dosent have store procedures , dosent have a
> complete SQL command set...
>
> I am using it becasue I am being forced to...
>
>
>
> -----Original Message-----
> From: Elizabeth Bogner
> [mailto:elizabeth.bogner@stripped]
> Sent: Thursday, August 15, 2002 9:25 PM
> To: mysql@stripped
> Subject: MySQL vs. Oracle (not speed)
>
>
>
> A company I work with is in the process of upgrading
> its databases from
> some
> motheaten system to something current. My impression
> is that they
> want to go with Oracle, and I'm not sure if this is
> based on anything
> other than being impressed with the size and
> presumed quality support
> of Oracle. I'd like to encourage them to at least
> seriously consider
> using
> MySQL instead.
>
> I don't think that speed is a huge factor here; we
> do a lot of XML
> publishing
> and content management, but at most we'd have
> several gigabytes of
> data and several dozen simultaneous users, so well
> within the
> capabilities
> of MySQL. I've looked at various things I could
> find, like the benchmarks
> pages (probably not relevant) and the MySQL myths
> page, which was
> somewhat helpful, but I couldn't find anything more
> along the lines of
> "How to Convince my Management to go with MySQL." I
> don't even know
> what to expect from them, but I'm imagining they'll
> say, "But MySQL
> doesn't support sub-selects," to which I can reply,
> "But you can write
> most of those as joins anyway, so it won't matter
> because the software
> will all be written from scratch." Etc.
>
> Are there pointers anyone can give me?
>
> E. Bognewitz
>
>
>
---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list
> archive)
>
> To request this thread, e-mail
> <mysql-thread117260@stripped>
> To unsubscribe, e-mail
>
<mysql-unsubscribe-mary.stickney=tagtmi.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list
> archive)
>
> To request this thread, e-mail
> <mysql-thread117305@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-frsgti=yahoo.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>


__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread117315@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-Kenneth.Hylton=billingconcepts.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread117370@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-sorr=rightnow.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
MySQL vs. Oracle (not speed)Elizabeth Bogner16 Aug
  • Re: MySQL vs. Oracle (not speed)Matthew Walker16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
    • RE: MySQL vs. Oracle (not speed)Kent Vilhelmsen16 Aug
    • RE: MySQL vs. Oracle (not speed)Francisco16 Aug
      • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
              • Re: MySQL vs. Oracle (not speed)Serge Paquin16 Aug
                • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                  • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
                • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                  • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                    • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                      • Re: MySQL vs. Oracle (not speed)Van16 Aug
                        • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • Re: MySQL vs. Oracle (not speed)Dan Nelson16 Aug
                        • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
        • RE: MySQL vs. Oracle (not speed)Francisco16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                    • Re: improving slow query (was: MySQL vs. Oracle (not speed))Benjamin Pflugmann16 Aug
                • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
            • RE: MySQL vs. Oracle (not speed) - not part of the rant, but real informationAdam Nelson16 Aug
              • Re: MySQL vs. Oracle (not speed) - not part of the rant, but real informationDavid Lloyd17 Aug
        • Re: MySQL vs. Oracle (not speed)Tom Gao16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
    • Re: MySQL vs. Oracle (not speed)Gelu Gogancea16 Aug
      • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • Re: MySQL vs. Oracle (not speed)Gelu Gogancea16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
  • Re: MySQL vs. Oracle (not speed)Anderson Pereira Ataides16 Aug
RE: MySQL vs. Oracle (not speed)Art Fore16 Aug
RE: MySQL vs. Oracle (not speed)John Griffin16 Aug
  • Re: MySQL vs. Oracle (not speed)Elizabeth Bogner17 Aug
Re: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug
RE: MySQL vs. Oracle (not speed)Alec.Cawley16 Aug
RE: MySQL vs. Oracle (not speed)John Griffin16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
Re: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug
RE: MySQL vs. Oracle (not speed)Kenneth Hylton16 Aug
Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney17 Aug
RE: MySQL vs. Oracle (not speed)Steve Orr16 Aug
RE: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug