[OpenSIPS-Users] mysql engine type for opensips tables

[Dan Pascu]

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