<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
<div class="moz-cite-prefix">On 5/28/13 3:53 PM, Lefteris Zafiris
wrote:<br>
</div>
<blockquote
cite="mid:CANw1Ex8Xv-jhEb5jKB7Bsr_5LwVKuXb32o2C809LMGdR3tddPg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Hi everybody,<br>
<br>
I noticed (after checking the files in utils/kamctl/mysql)
that kamailio uses the MyISAM storage engine for its
database tables in mysql, is there some particular reason
for this? Isn't the read/write concurency that InnoDB
provides desirable?<br>
</div>
</div>
</div>
</div>
</blockquote>
you can change that if you prefer innodb, nothing has to be changed
in kamailio. Probably the MyISAM is still the safest for old
installations. The best would be to make it configurable, but now is
generated from the xml file specifying table structures.<br>
<br>
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. <br>
<blockquote
cite="mid:CANw1Ex8Xv-jhEb5jKB7Bsr_5LwVKuXb32o2C809LMGdR3tddPg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>
</div>
<br>
And on a side note, enabling 'low_priority_updates' (<a
moz-do-not-send="true"
href="http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_low-priority-updates">http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_low-priority-updates</a>)
that prioritizes reads over writes in my mysql config can
lead to any potential issues with kamailio? Anybody tested
this before?<br>
</div>
</div>
</div>
</blockquote>
I haven't played with this myself, but it should not really affect
kamailio, each own process uses its connection and does serial
queries.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote
cite="mid:CANw1Ex8Xv-jhEb5jKB7Bsr_5LwVKuXb32o2C809LMGdR3tddPg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<br>
</div>
Regards,<br>
<br>
</div>
Lefteris Zafiris<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, San Francisco, USA - June 24-27, 2013
* <a class="moz-txt-link-freetext" href="http://asipto.com/u/katu">http://asipto.com/u/katu</a> *</pre>
</body>
</html>