Web lists-archives.com

Re: [PHP] LOCKS???




> On Nov 28, 2016, at 10:44 AM, Joshua Kehn <josh@xxxxxxx> wrote:
> 
> Are you using a transaction on “Computer One?” 
> 
> If a session begins a transaction (for example, with START TRANSACTION), an implicit UNLOCK TABLES is performed, which causes existing locks to be released. (For additional information about the interaction between table locking and transactions, see Section 14.3.5.1, “Interaction of Table Locking and Transactions”.)
> 
> It could also be a question of whether the connection is being recreated between when you issue the LOCK and when you do whatever work.
> 
> If the connection for a client session terminates, whether normally or abnormally, the server implicitly releases all table locks held by the session (transactional and nontransactional). 
> 
> Both the above are from: http://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
> 
> I'd encourage you to test the functionality you're expecting from a MySQL prompt instead of another language to confirm if you're operating with the correct queries or if the problem lays in the interface layer. 
> 
> —jk 

Joshua:

Much of what you say, I have already read and know. However, I can’t confirm because I can’t get LOCKs to work.

For example, when I am using two different scripts to edit the exact same table, I see no changes in their respective session IDs when a LOCK is implemented. But then again my LOCKs don’t work.

Additionally, Transactions may provide a implicit LOCK, but the BEGIN without a COMMIT/ROLLBACK does not LOCK the table. But then again my LOCKs don’t work.

Do you see what I mean?

It would be nice if someone could show me a “simple” example of LOCKs working that I could review (i.e., copy).

You further state:

> I'd encourage you to test the functionality you're expecting from a MySQL prompt instead of another language to confirm if you're operating with the correct queries or if the problem lays in the interface layer. 


While I understand what you are advising, my problem is having PHP do this. I really don’t care if it can be done via a MYSQL prompt because that is not my medium. The only thing that a MYSQL prompt could do, is show me it can’t be done in PHP. Either PHP can connect to a database and send queries or it can not. I believe the former.

Cheers,

tedd

_______________
tedd sperling
tedd.sperling@xxxxxxxxx






--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php