[OpenSIPS-Users] mysql engine type for opensips tables

[Jeff Pyle]

Hi Dan,


On 9/17/09 7:33 PM, "Dan Pascu" <dan at 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