[OpenSIPS-Users] mysql engine type for opensips tables
Dan Pascu
dan at ag-projects.com
Fri Sep 18 01:33:35 CEST 2009
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
More information about the Users
mailing list