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.