Web lists-archives.com

Re: [PHP] LOCKS???




On Sun, Nov 27, 2016 at 11:33 PM, Paul M Foster <paulf@xxxxxxxxxxxxxxxxx>
wrote:

> On Sun, Nov 27, 2016 at 07:59:58PM -0500, Aziz Saleh wrote:
>
> > On Sun, Nov 27, 2016 at 6:37 PM, Tedd Sperling <tedd.sperling@xxxxxxxxx>
> > wrote:
> >
> > > Hi gang:
> > >
> > > I’ve read a bunch about MYSQL LOCKs, but I can seem to get them to
> work.
> > >
> > > For example, I have two computers accessing the same host (i.e., thus
> each
> > > with different SIDs) and accessing two different scripts. One script
> > > performs a "LOCK TABLES t WRITE" and the second script tries to read
> TABLE
> > > t. While the LOCK is in place, the second script has no problem
> reading and
> > > writing to TABLE t.
> > >
> > > I don’t understand what's wrong — any ideas?
>
> [snip]
>
> > You are running a LOCK on writes, not reads, so the second script is
> > performing fine.
> >
> > Also you don't need multiple sessions to test LOCK mechanism, should be
> > able to test it with just 1 session.
> >
> > http://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
>
> Read what Tedd wrote again. The second script is reading and WRITING to
> the tables.
>
> Paul
>
> --
> Paul M. Foster
> http://noferblatz.com
> http://quillandmouse.com
>

Thanks Paul, I see it now. My mistake for skimming.