blocking_others_timeout option

Specifies the amount of time that another connection can block on the current connection's row and table locks before the current connection is rolled back. This option can be used to prevent a low priority task from blocking other connections for longer than the specified time.

 Allowed values
 Default
 Scope
 Remarks
 See also