<div dir="ltr">Thank you so much for your response. Well if putting the table into memory is not a good option what is the best way to handle this situation?<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Sep 24, 2016 at 10:50 PM, Phil Lavin <span dir="ltr"><<a href="mailto:phil.lavin@cloudcall.com" target="_blank">phil.lavin@cloudcall.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-GB">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">You could look at tweaking MySQL setting
<a href="http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit" target="_blank">
innodb_flush_log_at_trx_commit</a> and setting its value to <b>0</b>. It’ll make your database not ACID compliant, but I don’t see that as being a major issue for transient data such as that stored in the Kamailio DB.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">I’m not entirely convinced that changing it to a memory table will help as you are presumably doing MySQL replication between your two Kamailio nodes.
Memory tables don’t replicate well.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US"> sr-users [mailto:<a href="mailto:sr-users-bounces@lists.sip-router.org" target="_blank">sr-users-bounces@<wbr>lists.sip-router.org</a>]
<b>On Behalf Of </b>Gholamreza Sabery<br>
<b>Sent:</b> 24 September 2016 20:04<span class=""><br>
<b>To:</b> Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><wbr>><br>
</span><b>Subject:</b> Re: [SR-Users] Location Table In db_mode 3<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On average I have about 2000 registrations per second and this configuration does not work with this rate. Maximum number of registrations that we can handle with db_mode 3 is 1000 per second.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Sat, Sep 24, 2016 at 10:12 PM, Phil Lavin <<a href="mailto:phil.lavin@cloudcall.com" target="_blank">phil.lavin@cloudcall.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">What rate of registrations do you have?</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US"> sr-users
[mailto:</span><a href="mailto:sr-users-bounces@lists.sip-router.org" target="_blank"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">sr-users-bounces@<wbr>lists.sip-router.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">]
<b>On Behalf Of </b>Gholamreza Sabery<br>
<b>Sent:</b> 24 September 2016 19:39<br>
<b>To:</b> Kamailio (SER) - Users Mailing List <</span><a href="mailto:sr-users@lists.sip-router.org" target="_blank"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">sr-users@lists.sip-router.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US"><wbr>><br>
<b>Subject:</b> [SR-Users] Location Table In db_mode 3</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">I have multiple Kamailio servers in an Active/Active scenario (the database is a MySQL server) using db_mode 3. But when the number of clients goes up writes on the location table
become too much and it causes database problems. I even put my location table on a separate SSD disk on the server to separate it's IO but still at times I have problems. How can I move location table into memory? Is this a good solution? What other options
do I have?<u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
______________________________<wbr>_________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><br>
<br></blockquote></div><br></div>