[OpenSIPS-Users] mysql engine type for opensips tables
Jeff Pyle
jpyle at fidelityvoice.com
Thu Sep 17 19:14:30 CEST 2009
Hello,
I noticed in the .sql files used to create the tables in MySQL for Opensips
it forces the table type to MyISAM. I would suggest to remove the ENGINE
declaration altogether allowing the tables to be created in the default
engine for the database server. In most cases for most folks this will
result in MyISAM tables anyway.
I write this after having stripped the engine manually in each .sql file
after each update of Opensips since in my case they're created by default
with ENGINE=ndb. Others may wish to use a type such as InnoDB for the acc
table while MyISAM for the rest.
Just a thought.
- Jeff
More information about the Users
mailing list