15 Nov
2007
15 Nov
'07
7:35 a.m.
Iñaki Baz Castillo wrote:
El Miércoles, 14 de Noviembre de 2007, Henning
Westerholt escribió:
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.
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
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.