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

On 11/13/07 19:13, 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.

...well, when the mysql modules was initially written (2001-2002), myisam was the default db engine; innodb was not available, it was introduced later. so it keeps being the same, as there was no need to change.

Daniel

Regards.