List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:July 30 2007 11:26am
Subject:Re: Migration from Oracle to MySQL
View as plain text  
> > Storage engines are unique to MySQL? yes.  Is that good?  YMMV.  Most
> > of the purported benefits can be achieved with Oracle's features
> > without the compromises of balkanised storage engines.  You're right,
> > they're not offered by Oracle, or anyone else ... there's a reason no
> > other database bothers with storage engines - they got storage right
> > the first time :-) (ooh ... the flames I'll get for that :-) ).  Sure,
> > non-volatile data in a MyISAM table can be read at the speed of light,
> > and handle the odd insert.  Funnily enough, a text file has the same
> > properties.  They both suck for non-trivial concurrent transactions.
> > I'd suggest taking a look at parallel DML, nologging, MVs,
> > partitioning, direct-path insert, appended insert, RAC, ASM, ASSM,
> > etc. etc. etc. in Oracle for more perspective
> >
>
> Grant,
>
> LOL - an entertaining read!

Entertaining? I feel to see the humor in his post.

> One advantage of multiple storage engines that comes to mind is that you
> can streamline your setup for different workloads:
>
> - Innodb/Falcon for non-trivial concurrency workloads
> - Myisam for fairly static or bulk-loaded (mainly) read workloads.

MyISAM never really got "finished" as a data storage engine
and neither did InnoDB.

MyISAM doesn't support referential constraints, so for any serious
data storage, it's a no-go area for me.

InnoDB, on the other hand, doesn't support Full Text Indices (Search),
that's where MyISAM comes into play.

That's the problem with the currently available non-alpha storage engines
in MySQL: they just don't cut it.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
Error compiling on Solaris 6Giulio Troccoli26 Jul
  • Re: Error compiling on Solaris 6mysql26 Jul
    • RE: Error compiling on Solaris 6Giulio Troccoli26 Jul
      • Migration from Oracle to MySQLSrikalyan Tangirala26 Jul
        • Re: Migration from Oracle to MySQLGrant Allen27 Jul
          • Re: Migration from Oracle to MySQLMark Kirkwood30 Jul
    • Re: Migration from Oracle to MySQLMartijn Tonies26 Jul
    • Re: Migration from Oracle to MySQLMartijn Tonies30 Jul
      • Re: Migration from Oracle to MySQLMark Kirkwood31 Jul
    • Re: Migration from Oracle to MySQLMartijn Tonies31 Jul
RE: Migration from Oracle to MySQLRajesh Mehrotra26 Jul
  • RE: Migration from Oracle to MySQLSrikalyan Tangirala26 Jul
  • RE: Migration from Oracle to MySQLsliebman26 Jul
  • Re: Migration from Oracle to MySQLLuca Ferrari27 Jul