RE: Oracle vs. MySQL

Certain things don't need transactions.

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863  

-----Original Message-----
Sent: Wednesday, August 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L

AFAIK on big thing 'missing' in mySQL is that it has no journalling (transaction logging) capabilities.

So there's no transaction mgt.. rollbacks...etc.. if things bozo in the middle of a process.. you're dead. Restore from last backup and hope for the best.

So you wouldn't want to use it for storing data that's really 'important'.

Lots of web sites use it to manage connection states etc.. where if it crashes.. well. they just restart.

I don't know if it handles replication.. or how well it would digest 10 GB of data !

I think the open source 'postgres' [sic ?] database is supposed to be more robust... It's now being supported and packaged by the Red Hat Linux people.

In the long run, you get what you pay for !

-----Original Message-----
Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L

The comparisons look good for MySQL...
not bad for others, but better for
mySQL than some comments by some
folks on the list would have led me
to believe.

Anyone here have major gripes about
mySQL that oracle solved?

-----Original Message-----
Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L

Interesting site...

Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old.

> -----Original Message-----
> From: Dwayne Cox [mailto:dwaynec_at_infotechfl.com]
> Sent: Wednesday, August 01, 2001 9:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: off topic--oracle Vs ms sql
>
>
> Try this site...
>
> http://www.mysql.com/information/crash-me.php
>
> On Mon, 30 Jul 2001 13:29:28 -0800
> "Ravindra Basavaraja" <ravindra_at_sentica.com> wrote:
>
> > Does anyone have any doc or links that compares oracle and ms sql.
> >
> > Also what are the equivalent data types in ms sql for oracle's lobs.
> >
> > Thanks
> > Ravindra
>
>
> __________________________________________________________________
> Dwayne Cox
> DBA, Development Dept.
> Info Tech, Inc.
> dwaynec_at_infotechfl.com
> http://www.infotechfl.com
> ___________________________________________________________________
> The opinions expressed are the author's own unless otherwise stated
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dwayne Cox
> INET: dwaynec_at_infotechfl.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  INET: Bruce.Page_at_BellSouth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).