On Nov 13, 2007 12:13 PM, Iñaki Baz Castillo <[EMAIL PROTECTED]> wrote:
> Hi, MySQL tables of OpenSer created by the script are "MyISAM". Is there > any > reason for that instead of using InnoDB? > > As I know: > > MyISAM: > - Is faster reading and writting (except writting various entries to same > table since it blocks the entire table). > - No transactions or rollbacks. > - Small disc space requeriments. > > InnoDB: > - Transactions, rollbacks, restrictions in foreing keys. > - Faster writting various entries in same table (entry lock instead of > table > lock). > - More disc space and RAM requeriments. > > > Yes, it can be obvious that for OpenSer the engine MyISAM can be a good > choice > but I would like to know if there is more data for this choice. > > Regards. > > > -- > Iñaki Baz Castillo > [EMAIL PROTECTED] > > _______________________________________________ > Users mailing list > [email protected] > http://lists.openser.org/cgi-bin/mailman/listinfo/users > Depending on how much data you have, you should also look at mysql Cluster. Since it is an in memory database, it will be super fast. I have used SER with Mysql Cluster and it works well. Joe
_______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
