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

[Klaus Darilion]

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