[OpenSER-Users] MyISAM or InnoDB in MySQL tables?
    Iñaki Baz Castillo 
    ibc at in.ilimit.es
       
    Tue Nov 13 18:13:11 CET 2007
    
    
  
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.
Regards.
-- 
Iñaki Baz Castillo
ibc at in.ilimit.es
    
    
More information about the Users
mailing list