[OpenSIPS-Users] Mysql stored proc

Bogdan-Andrei Iancu bogdan at voice-system.ro
Sun Jun 14 20:06:39 CEST 2009


hard to say - to be honest I never used "temporary" tables - I just 
commented from the opensips point of view, on how the mysql connections 
are managed.

Regards,
Bogdan

Brett Nemeroff wrote:
> Ok, so basically I build a temp table called "routes" from a stored 
> proc. Can I not rely on this being a unique table per transaction if 
> the session is held alive? Of course I could name the table something 
> like routes_<timestamp>_<$ru> and trash it at the end of the stored 
> proc. I just don't want to end up with a race condition.
>
>
> On Thu, Jun 11, 2009 at 3:28 AM, Bogdan-Andrei Iancu 
> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>
>     Saúl Ibarra wrote:
>     >> Each OpenSIPS process opens at startup a mysql connection and
>     it keeps it
>     >> open till the shutdown - so the connection is persistent at
>     runtime. Of
>     >> course, a conection can be re-established at runtime if some
>     connection lost
>     >> event happens (timesout etc).
>     >>
>     >>
>     >
>     > That's good to know :) But don't you think it's a bit risky to
>     rely on
>     > temporary tables in this case? If by any chance the connection
>     is lost
>     > strange things ca start to happen :-O ? I'd go for memcache ;)
>     >
>     well, opensips takes care of its internal DB stuff (like re-init the
>     prepared statements after a reconnect), but for other things you do by
>     yourself from script, you need to take care by yourself :)
>
>     But yes, the memcache is a good option :). especially that we are
>     working on interfacing the memcache interface with the memcached
>     daemon ;)
>
>     Regards,
>     Bogdan
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>




More information about the Users mailing list