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

[Alex Balashov]

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/