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

On Tuesday 13 November 2007, Iñaki Baz Castillo wrote:

Hi, MySQL tables of OpenSer created by the script are "MyISAM". Is there any reason for that instead of using InnoDB?

As I know:

MyISAM:

• Is faster reading and writting (except writting various entries to same

table since it blocks the entire table).

• No transactions or rollbacks.
• Small disc space requeriments.

InnoDB:

• Transactions, rollbacks, restrictions in foreing keys.
• Faster writting various entries in same table (entry lock instead of

table lock).

• More disc space and RAM requeriments.

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.

Cheers,

Henning