On 11/13/07 19:13, Iñaki Baz Castillo 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. > ...well, when the mysql modules was initially written (2001-2002), myisam was the default db engine; innodb was not available, it was introduced later. so it keeps being the same, as there was no need to change.
Daniel > Regards. > > > _______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
