| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MySQL vs. Oracle database
Thanks for clarification, all my knowledge about transactional tables are
from MySQL docs.
I'v used only "not transactional safe" tables for some web projects.
Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/
"Weaver, Walt"
<wweaver_at_rightnow To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
.com> cc:
Sent by: Subject: RE: MySQL vs. Oracle database
root_at_fatcity.com
2002.04.18 17:38
Please respond to
ORACLE-L
In our testing the Berkeley table types were hopelessly slow and bloated, taking up much more space than MyISAM or InnoDB table types.
We had more success with the InnoDB table type, and will be implementing them some time in the future. InnoDB supports referential integrity.
The table types aren't really a special component; they're implemented via an argument when the source is compiled.
--Walt Weaver
Bozeman, Montana
-----Original Message-----
Sent: Thursday, April 18, 2002 3:03 AM
To: Multiple recipients of list ORACLE-L
By default MySQL has no transactions
You have to add special component to access "transactional safe tables"
called Berkeley db tables. You can commit and rollback on only these
tables. For others every wrong (not syntactically, but for example
inserting characters into number column) insert and update will succeed. If
MySQL cannot insert provided values it uses default values.
One of the biggest pains is (maybe was, I don't know about MySQL 4.xxx) that it has no foreign keys :((((((((((((
I have created class diagramms for both Oracle and Mysql servers for my
studies in University. It cannot be treated as feature comparison but just
simple overview of these two images will show the situation i.e. compare
object count on these images :-)
And I have to say that Oracle diagramm isn't complete!
Oracle server class diagramm
http://www.itsystems.lv/gints/files/oracle/oracle_s.htm
Mysql server class diagramm
http://www.itsystems.lv/gints/files/mysql/mysql.htm
Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/
"Bunyamin K.
Karadeniz" To: Multiple
recipients
<bunyamink_at_havels cc:
an.com.tr> Subject: Re: MySQL vs.
Oracle database
Sent by:
root_at_fatcity.com
2002.04.18 10:43
Please respond to
ORACLE-L
I have not been so much with MySQL , But want to share my experience.
Firstly , it is very fast ...This makes me suspicious , I wonder if it is
trusted to be integral .
Seem like no control ..Does not contain rollbacks , may be this .. Then how
does it rollback ?
I have used a version where stored procs ,functions are unavailable .. Wonder if it has now..
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA.
>
>
> -- "Weaver, Walt" <wweaver_at_rightnow.com>
>
> > I don't think you're wrong. MySQL gets dissed frequently on this list,
but
> > it's really a nice little product. IMHO it's much closer to Oracle than
> > Access.
> >
> > It works well for us. Doesn't scale like Oracle, but works well.
>
> In some ways it scales better than Oracle. For load+query
> (a.k.a., "warehouse") operations it can be faster than
> Oracle because it doesn't get tangled up with rollbacks,
> etc. On systms with many "instances" it also can be much
> simpler to administer.
>
> --
> Steven Lembark 2930 W. Palmer
> Workhorse Computing Chicago, IL 60647
> +1 800 762 1582
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steven Lembark
> INET: lembark_at_wrkhors.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: Bunyamin K. Karadeniz INET: bunyamink_at_havelsan.com.tr 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: INET: G.Plivna_at_itsystems.lv 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: Weaver, Walt INET: wweaver_at_rightnow.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: INET: G.Plivna_at_itsystems.lv 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).Received on Thu Apr 18 2002 - 10:43:37 CDT
 |
 |