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" <[email protected]> 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 >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
