<div dir="ltr"><div style>Hi Peter,</div><div style><br></div>I see that query_lock is supposed to lock the rows that it specifies.<div><br></div><div style>MySQL only supports locks on rows with the InnoDB engine. But as far as I know, when installing the mysql tables with kamdbctl, the tables are added with the MyISAM engine.</div>
<div style><br></div><div style>So, should I start modifying the install scripts so that we use InnoDB engine, or is a table-lock sufficient when myisam is used? Mysql will not give an error if the engine does not support locking on individual rows. So the experience will be transparent for the end user, except for the locking of the whole table.</div>
<div style><br></div><div style>Also, it is important that the columns that the query compares against, is indexes, or else the table will be locked even if the table engine is InnoDB. I'm not sure if presence only queries for indexed columns?</div>
<div style><br></div><div style>Regards,</div><div style>Håkon</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 2 April 2013 14:25, Peter Dunkley <span dir="ltr"><<a href="mailto:peter.dunkley@crocodile-rcs.com" target="_blank">peter.dunkley@crocodile-rcs.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Olle,<br>
<br>
The new dbb->query_lock function needs to be implemented too.<br>
<br>
Regards,<br>
<br>
Peter<div class="HOEnZb"><div class="h5"><br>
<br>
On 02/04/13 13:16, Olle E. Johansson wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi!<br>
<br>
db_mysql in devel now has transaction support, which should work with presence. It's contributed by Håkon Nassjöen that responded to my cry for help in the Google+ Kamailio group!<br>
<br>
Thanks, Håkon!<br>
<br>
/O<br>
______________________________<u></u>_________________<br>
sr-dev mailing list<br>
<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/<u></u>cgi-bin/mailman/listinfo/sr-<u></u>dev</a><br>
</blockquote>
<br>
<br>
______________________________<u></u>_________________<br>
sr-dev mailing list<br>
<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/<u></u>cgi-bin/mailman/listinfo/sr-<u></u>dev</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Håkon<br>
</div>