[OpenSER-Users] MyISAM or InnoDB in MySQL tables?

[Christian Schlatter]

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.

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