Statement and lock time-outs

A SELECT WITH LOCK statement waits for a predetermined time period (time out duration) if a resource is locked by another session. The time out duration is configurable. Note that statements that do not take locks, or statements that read through locks, can also time out. This condition is commonly referred to as a query timeout and is often attributable to poor database server response time or high network latency.

The lock wait period for SELECT FOR UPDATE, INSERT, DELETE and UPDATE statements can be specified using the MSQL_LOCK_TIMEOUT environment variable or the msql_lock_timeout resource variable. Note that care must be taken when experimenting with these options.