13 Feb
2014
13 Feb
'14
6:57 p.m.
Hi,
Lately i am experiencing some issues with the sqlops module.
let's say, for example, that i use sqlops to query some information about
the subscriber when an INVITE arrives.
I use kamailio 3.3.2, MySQL 5.6 and the DB server is remote and not local.
Usually, the DB result is very fast and the call continues. But, when the
DB is unavailable, or slow, the result is delayed or lost.
In this case:
1. What is the query time out in kamailio?
2. If the database is available but slow, does it mean that no new INVITE
will be dealt by the current child process until the sqlops is gone?
3. does anyone has a good idea for managing sqlops in a call?
Thanks,
Uri
13 Feb
13 Feb
7:12 p.m.
New subject: understanding the sqlops module and kamailio children.
Hello Uri,
On 02/13/2014 11:57 AM, Uri Shacked wrote:
1. What is the query time out in kamailio?
2. If the database is available but slow, does it mean that no new
INVITE will be dealt by the current child process until the sqlops is gone?
3. does anyone has a good idea for managing sqlops in a call?
These parameters are managed by the underlying DB driver (e.g. db_mysql,
db_postgres), not sqlops. Sqlops just runs on top of those low-level
database interface modules. So, for MySQL, you'd set these here:
http://kamailio.org/docs/modules/4.1.x/modules/db_mysql.html#idp1968288
Unfortunately, the database modules are not consistent in the extent or
granularity of timeout, keepalive and automatic reconnect-related
options they offer. For example, db_mysql offers all of the options you
see in the link above, but db_postgres does not.
The answer to your second question is that yes, database operations
block the current SIP worker thread, just as almost all external
operations do. So, you definitely want your database queries to be fast
and to return quickly.
-- Alex
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
8:49 p.m.
New subject: understanding the sqlops module and kamailio children.
Alex - Thanks.
I was familiar with the parameters on db_mysql.
So, I understand there is no option for me to fine tune a query timeout etc...
I will have to find a better way to manage my DB related issues.
BR,
Uri
Hello Uri,
On 02/13/2014 11:57 AM, Uri Shacked wrote:
>* 1. What is the query time out in kamailio?
*>>>>* 2. If the
database is available but slow, does it mean that no new
*>>* INVITE will be dealt by the current child process until the sqlops is gone?
*>>>>* 3. does anyone has a good idea for managing sqlops in a call?
*>
These parameters are managed by the underlying DB
driver (e.g. db_mysql,
db_postgres), not sqlops. Sqlops just runs on top of those low-level
database interface modules. So, for MySQL, you'd set these here:
http://kamailio.org/docs/modules/4.1.x/modules/db_mysql.html#idp1968288
Unfortunately, the database modules are not consistent in the extent or
granularity of timeout, keepalive and automatic reconnect-related
options they offer. For example, db_mysql offers all of the options you
see in the link above, but db_postgres does not.
The answer to your second question is that yes, database operations
block the current SIP worker thread, just as almost all external
operations do. So, you definitely want your database queries to be fast
and to return quickly.
-- Alex
On Thu, Feb 13, 2014 at 6:57 PM, Uri Shacked <ushacked(a)gmail.com> wrote:
Hi,
Lately i am experiencing some issues with the sqlops module.
let's say, for example, that i use sqlops to query some information about
the subscriber when an INVITE arrives.
I use kamailio 3.3.2, MySQL 5.6 and the DB server is remote and not local.
Usually, the DB result is very fast and the call continues. But, when the
DB is unavailable, or slow, the result is delayed or lost.
In this case:
1. What is the query time out in kamailio?
2. If the database is available but slow, does it mean that no new INVITE
will be dealt by the current child process until the sqlops is gone?
3. does anyone has a good idea for managing sqlops in a call?
Thanks,
Uri
3935
days inactive
3935
days old
2 comments
2 participants
participants (2)
-
Alex Balashov -
Uri Shacked