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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 19 days, processed 679,216,889 queries (397/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
