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

Henning Westerholt henning.westerholt at 1und1.de
Wed Nov 14 09:31:51 CET 2007


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




More information about the Users mailing list