[SR-Users] MySQL storage engine

[Daniel-Constantin Mierla]

On 5/28/13 4:43 PM, Lefteris Zafiris wrote:
> On Tue, 28 May 2013 16:30:42 +0200
> Daniel-Constantin Mierla <miconda at gmail.com> wrote:
>
>> Is there an option to set default storage engine per database (or mysql
>> server)? Maybe we should skip it in table definition and let it be the
>> default one in the database server.
> Since Mysql 5.5 InnoDB is the default engine. It can also be configured by the
> default-storage-engine setting in my.cfg
OK. Perhaps worth opening an issue on our tracker not to forget this one.

I think Henning did most of xml-to-sql tools work in the past, if he 
cannot jump on it, someone else will do it.

>
>
>> I haven't played with this myself, but it should not really affect
>> kamailio, each own process uses its connection and does serial queries.
> It only affects MyISAM tables. It makes things a bit faster because actually runs the
> read operations before some write locks the table. If its safe to use InnoDB it's not
> worth bothering with this specific option.
OK.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, San Francisco, USA - June 24-27, 2013
   * http://asipto.com/u/katu *