Christian Schlatter schrieb: > Iñaki Baz Castillo wrote: >> El Miércoles, 14 de Noviembre de 2007, Henning Westerholt escribió: >> >>>> 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. >>> Hi Iñaki Baz, >>> >>> just a short note: >>> >>> This can be easily changed (for 1.3) in the db/schema/entities.xml file, >>> for 1.2 there should exists a parameter in the script. >> Thanks, it's nice to know that. >> Anyway what I'd like in fact is to hear any argument to use MyISAM or >> InnoDB, >> any technical reason. > > There is a good article about this topic on > http://dev.mysql.com/tech-resources/articles/storage-engine/part_1.html. > > The basic conclusion: NDB (mysql cluster) is the fastest engine because > it is a main-memory engine and has advanced locking like InnoDB.
So if the cluster fails, all the data is gone? regards klaus > > I'd guess that InnoDB might perform better than MyISAM for an openser > under high load because of its advanced locking and the fact that each > openser process uses its own mysql connection. > > /Christian > > _______________________________________________ > Users mailing list > [email protected] > http://lists.openser.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
