[SR-Users] understanding the sqlops module and kamailio children.

[Uri Shacked]

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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140213/1ce0e8c6/attachment.html>