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 Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users