Hi Dan,
On 9/17/09 7:33 PM, "Dan Pascu" <d...@ag-projects.com> wrote: > 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> Great suggestions! Especially the entities.xml file. A runtime option would be nice but not all that important if editing the file is a possibility before building. I'll give it a shot after the next update. Thanks, Jeff _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users