riginal Message-
From: sr-users [mailto:sr-users-boun...@lists.sip-router.org] On Behalf Of Juha
Heinanen
Sent: 25 September 2016 10:35
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Location Table In db_mode 3
Gholamreza Sabery writes:
> Thank you so much. I will try it;
Gholamreza Sabery writes:
> Thank you so much. I will try it; but it seems that this option affects the
> whole database.
I think it applies to the whole mysql server, i.e., to all of its databases.
-- Juha
___
SIP Express Router (SER) and Kamailio (O
ata to disk every second.
>
>
>
>
>
> *From:* sr-users [mailto:sr-users-boun...@lists.sip-router.org] *On
> Behalf Of *Gholamreza Sabery
> *Sent:* 25 September 2016 09:16
>
> *To:* Kamailio (SER) - Users Mailing List
> *Subject:* Re: [SR-Users] Location Table In db
un...@lists.sip-router.org>]
> On Behalf Of
> Gholamreza Sabery
Sent: 24 September 2016 20:25
> To: Kamailio (SER) - Users Mailing List
> mailto:sr-users@lists.sip-router.org>>
> Subject: Re: [SR-Users] Location Table In db_mode 3
>
> Thank you so much for your resp
> > Gholamreza Sabery
> Sent: 24 September 2016 20:25
> > To: Kamailio (SER) - Users Mailing List
> > Subject: Re: [SR-Users] Location Table In db_mode 3
> >
> > Thank you so much for your response. Well if putting the table into
> memory
> > is not a good
g] On Behalf Of
> Gholamreza Sabery
Sent: 24 September 2016 20:25
> To: Kamailio (SER) - Users Mailing List
> Subject: Re: [SR-Users] Location Table In db_mode 3
>
> Thank you so much for your response. Well if putting the table into memory
> is not a good option what is the best
om: sr-users [mailto:sr-users-boun...@lists.sip-router.org] On Behalf Of
Gholamreza Sabery
Sent: 24 September 2016 20:25
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Location Table In db_mode 3
Thank you so much for your response. Well if putting the table into memory is
not
gt; Behalf Of *Gholamreza Sabery
> *Sent:* 24 September 2016 20:04
> *To:* Kamailio (SER) - Users Mailing List
> *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 th
: [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,
ts.sip-router.org] On Behalf Of
Gholamreza Sabery
Sent: 24 September 2016 20:04
To: Kamailio (SER) - Users Mailing List
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 num
ave?
>
>
>
>
>
> *From:* sr-users [mailto:sr-users-boun...@lists.sip-router.org] *On
> Behalf Of *Gholamreza Sabery
> *Sent:* 24 September 2016 19:39
> *To:* Kamailio (SER) - Users Mailing List
> *Subject:* [SR-Users] Location Table In db_mode 3
>
>
>
> I have
What rate of registrations do you have?
From: sr-users [mailto:sr-users-boun...@lists.sip-router.org] On Behalf Of
Gholamreza Sabery
Sent: 24 September 2016 19:39
To: Kamailio (SER) - Users Mailing List
Subject: [SR-Users] Location Table In db_mode 3
I have multiple Kamailio servers in an
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 s
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 s
14 matches
Mail list logo
