[OpenSIPS-Users] db_mysql timeout

[Jeff Pyle]

Hi Bogdan,

Ok, that works.  Should there be any time penalty as these connections are
re-established?  Previously I had done some subjective measurements and it
seemed it could add a second or so to the call processing time.  Is that
normal?


- Jeff



On 12/2/09 10:22 AM, "Bogdan-Andrei Iancu" <bogdan at voice-system.ro> wrote:

> Hi Jeff,
> 
> This is normal - mysql server is hanging up the TCP connections if there
> is no traffic. In such a case opensips will restart the connections.
> 
> The ping_interval is not used at all - it is simply leftover from the
> previous version (without statements).
> 
> Regards,
> Bogdan
> 
> Jeff Pyle wrote:
>> Hello,
>> 
>> Each morning I face each Opensips child re_initing all its prepared
>> statements as an INVITE hits it for the first time in a while.  I see logs
>> like this:
>> 
>>  INFO:db_mysql:db_mysql_submit_query: disconect event for 0x823fb54
>>  INFO:db_mysql:reset_all_statements: reseting all statements on connection:
>> (0x823fa90) 0x823fb54
>>  INFO:db_mysql:db_mysql_submit_query: re-connected successful for 0x823fb54
>> 
>> There are some for sip_trace and other DB operations as well.
>> 
>> My only paramater for the db_mysql module is as follows:
>>  modparam("db_mysql", "ping_interval", 180)
>> 
>> It doesn't help.  Any thoughts?
>> 
>> 
>> 
>> Thanks,
>> Jeff
>> 
>> 
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> 
>>   
>