Locking MySQL Table |
Virtual Machine |
 |
Locking MySQL Table
Table locking with MySQL is controlled by the LOCKED_ROWS_RETURNED variable which you can set in the 'Environment' section of the PROIV configuration file.
If the variable LOCKED_ROWS_RETURNED is set to Y in the 'Environment' section of the PROIV configuration file, then PROIV wait for one second for the lock attempt to succeed. If the row is already locked and the lock is not released within one second timeout, PROIV will return a record locked error to the application.
If LOCKED_ROWS_RETURNED is not set or set to any value other than 'y' or 'Y', then PROIV will wait for an effectively indefinite period for a lock attempt to succeed on a row.
Topic ID: 560017