Re: LOCKS???

On Sun, Nov 27, 2016 at 6:37 PM, Tedd Sperling <tedd.sperling@gmail.com> 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? > > Thanks, > > tedd > _______________ > tedd sperling > tedd.sperling@gmail.com > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > 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