On Fri, May 31, 2002 at 08:40:51AM -0800, Gogala, Mladen wrote: > I read few articles in Linux magazine and had it installed on > my box for a while and here are my impressions: > > a) It's blindingly fast as a single user database, faster then oracle. > b) It uses more or less standard SQL minus all the unnecessary functions > like substr, decode, nvl and alike which nobody ever uses anyway (evil grin).
It has all those (some under different names) and more. > c) It's small. You can have both software and a small database within 150M > d) I didn't learn how to do recovery. It doesn't have hot backups. You have to > shut it down to make a sensible backup. There's a mysqlhotcopy script (I wrote myself) and there's now a BACKUP command in SQL. > e) It's easy to configure and doesn't have too many things to set up. > > Allegedly, the present version (I did my dirty work back in August 2001) can > use Perl as a scripting language, I don't know whether DBI/DBD is needed for > that and it can cope with committs and rollbacks. There is a Perl DBI driver for MySQL and yes, it supports transactions (MySQL supports multiple table types, some of which support transactions). MySQL is a fast moving target. August 2001 is a long time ago in it's history. For example, the InnoDB table type now supports foreign keys. Tim. > > > -----Original Message----- > > From: Joe Testa [mailto:[EMAIL PROTECTED]] > > Sent: Friday, May 31, 2002 10:39 AM > > To: Multiple recipients of list ORACLE-L > > Subject: MySQL versus Oracle > > > > > > Anyone on the list done a comparison(or worked with both) MySQL and > > Oracle and can give me the good/bad points of My SQL? > > > > Doing interviewer thing and someone has My SQL who would like to move > > into the oracle world and i know nothing about mySQL and am > > wondering if > > the transition from one to the other is easily done. > > > > thanks, joe > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Joe Testa > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: Gogala, Mladen > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Tim Bunce INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
