On 17 Sep 2009, at 20:14, Jeff Pyle wrote: > 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.
I disagree. Stripping it would make all the tables the same type. I currently make all my tables InnoDB, except the sip_trace table which I keep MyISAM. With your suggestion, this would not be possible anymore. I would recommend you to change the type in db/schema/entities.xml to whatever you need before you build opensips. Maybe this can be made configurable at runtime, so that no recompiling is necessary. Also if you need a different type only for some specific tables you can add an entry in their xml schema like: <type db="mysql">MyISAM</ type> -- Dan _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
