Hi,
As per a previous thread I have found that when you use lock Tables MySql will wait
indefinitely for the lock - No timeout or error message.
Therefore let me explain my question.
Scenario:
User 1 locks files for a long running job. (write lock that prevents any access to the
files)
User
I would investigate ways of writing that long running job so
that it does not require locking a table for long periods of time.
Use relative updates, break the procedure down into
smaller lockable steps with pauses for other programs etc.
Clyde wrote:
Hi,
As per a previous thread I have found