Re: [SR-Users] Location Table In db_mode 3

You could look at tweaking MySQL setting innodb_flush_log_at_trx_commit <http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit> and setting its value to *0*. 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. 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. *From:* sr-users [mailto:sr-users-bounces@lists.sip-router.org] *On Behalf Of *Gholamreza Sabery *Sent:* 24 September 2016 20:04 *To:* Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.sip-router.org&gt; *Subject:* Re: [SR-Users] Location Table In db_mode 3 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. On Sat, Sep 24, 2016 at 10:12 PM, Phil Lavin &lt;phil.lavin(a)cloudcall.com&gt; wrote: What rate of registrations do you have? *From:* sr-users [mailto:sr-users-bounces@lists.sip-router.org] *On Behalf Of *Gholamreza Sabery *Sent:* 24 September 2016 19:39 *To:* Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.sip-router.org&gt; *Subject:* [SR-Users] Location Table In db_mode 3 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? _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users