Hi Sebastian, On 22/10/14 08:36, Sebastian Damm wrote: > Hi Daniel, > > thanks for the explanation and blog post. However, this is a different > approach than the asynchronous sqlops function, right? In sqlops, the > request is sent to an asynchronous worker in Kamailio and does the SQL > operation when possible. In acc, only the request is a different one. > And if the MySQL server really has a problem, it can happen that it > doesn't return from the an INSERT DELAYED query immediately. If the > MySQL query is not detached from the SIP worker, the problem of a > blocking SIP proxy is still there. Is it possible to use the > asynchronous worker for the acc requests, too? the are two kind of operations that can be enabled for acc: insert delayed is done when db_insert_mode=1, async insert is done when db_insert_mode=2.
async insert is done via an asynchronous worker, same mechanism as for sql_query_async() -- in other words, the insert query to db is not executed by the sip worker. Cheers, Daniel > > Best Regards, > Sebastian > > On Tue, Oct 21, 2014 at 4:21 PM, Daniel-Constantin Mierla > <mico...@gmail.com <mailto:mico...@gmail.com>> wrote: > > Hello, > > it is possible, with same limitation that the database connector > module needs to support async operation -- see db_insert_mode > parameter for acc module. > > And because was asked, I added it to the blogs list as well: > - > http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-8-asynchronous.html > > Cheers, > Daniel > > > On 21/10/14 11:06, Sebastian Damm wrote: >> Hi, >> >> I read the article about asynchronous sqlops: >> >> http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-4-asynchronous-sql.html >> >> I was wondering whether there are any plans of bringing that >> feature to the acc module, too. We have seen it in the past that >> a blocking database server brought our proxy to a halt because >> the acc module was blocking, too. So this could help a lot if the >> acc entries were written asynchronously. >> >> Best Regards, >> Sebastian >> >> >> _______________________________________________ >> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list >> sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org> >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > -- > Daniel-Constantin Mierla > http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - > http://www.linkedin.com/in/miconda > > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing > list > sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org> > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > > > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > sr-users@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
