Re: [PHP] LOCKS???
- Date: Tue, 29 Nov 2016 14:42:24 -0500
- From: Adam Jon Richardson <adamjonr@xxxxxxxxx>
- Subject: Re: [PHP] LOCKS???
On Tue, Nov 29, 2016 at 2:09 PM, Stuart Dallas <stuart@xxxxxxxx> wrote:
> On 29 November 2016 at 16:51:24, Tedd Sperling (tedd.sperling@xxxxxxxxx)
> Ok, I’ve read lot, but I still cannot get a single example of LOCK to work.
> As mentioned I’m pretty sure this is because you’re attempting to lock in
> one request and expect the lock to still be there in subsequent requests.
> This is fundamentally not how MySQL table locks work so you’ll need to
> implement your own mechanism.
I agree with Stuart's analysis of failure causes and potential remedies. To
test the hypothesis that the share-nothing architecture of PHP is causing
the trouble, try adding a sleep() call to the first script and then within
the interval, call the second script. The tables should be locked.
Also, in terms of reads, I would suggest you could also provide a system
status update if a user is on a screen that is displaying data and the data
has changed, as you could prompt the user to refresh the page.