[OpenSER-Users] MyISAM or InnoDB in MySQL tables?
Christian Schlatter
cs at unc.edu
Thu Nov 15 05:35:12 CET 2007
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
More information about the Users
mailing list