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

[Daniel-Constantin Mierla]

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.
>
>
>