Re: MySQL Locking Question
| From: | Rasmus Lerdorf | Date: | Sat, 06 Oct 2001 01:24:52 +0000 |
| Subject: | Re: MySQL Locking Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70169@lists.php.net to get a copy of this message | ||
> OK that example is poor I admit...but do you see the reasoning behind
> locking? If a lock was in place Jill would't be able to edit her post
> because she would get a message stating that Admin Jack was allready editing
> it.
GET_LOCK has no way of conveying that information. You would need to use
a completely different mechanism to identify who is holding a lock.
How are you going to avoid deadlock?
-Rasmus