On Fri, Jan 03, 2003 at 11:10:38AM -0600, Dana Diederich wrote:
> Yup, MySQL works quite well as a lock server; we've been using it as such
> for years.
Yeah, do we.
> I would suggest looking at the get_lock() function specifically. It's
> designed to do exactly what you're looking for, and it won't require
> knowledge of any tables or rows.
I thought so initially too, but locks from get_lock()/release_lock()
vanish when the connection vanishes. We didn't want that. It added
way to much complexity to our code, so we created a lock table and
went from there...
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 3.23.51: up 19 days, processed 679,216,889 queries (397/sec. avg)
