Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
no edit summary
|}
===GLOBALLOCKFAIRLOCK===
{| width='100%'
|-
| width='120' | '''Signature'''
|{{Code|GLOBALLOCK FAIRLOCK [boolean]}}
|-
| '''Default'''
|{{Code|falsetrue}}
|-
| '''Summary'''
|Controls if local Defines the locking strategy:* If enabled, read and write transactions will be treated equally (databasefirst in, first out) or global (process) locking . This is the default strategy, as it avoids starvation of update operations.* If disabled, read transactions will be used for managing read favored, and write transactions that access no databases can be evaluated, even if the limit of parallel transactions (specified via {{Option|PARALLEL}} has been reached. This prevents update operations. The article on [[Transaction Management]] provides more details on concurrency controlfrom blocking all other requests (for example, the DBA can further be used to see which jobs are running, even if the queue is full).
|}
;Version 8.6
* Added: {{Option|FAIRLOCK}}
* Removed: {{Code|GLOBALLOCK}} (always use database lock)
* Removed: {{Code|QUERYPATH}} (will now be internally assigned)
