A question about locking
I have a server with several threads, each with a separate (MYSQL*) connection to the database.
The threads frequently query and alter several tables. It is guaranteed that the queried and affected rows are distinct (i.e., each thread has its own set of keys to access the table rows, and those sets do not intersect).
The question is: what locks, if any, should be done by the threads.
Subject
Written By
Posted
A question about locking
October 31, 2004 09:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.