X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=docs%2Fdatabase.txt;h=44ec764d950d906a7ac8dd6b04b0ba4effdbb559;hb=b24bfae5fe864c6c5f485ee2f190409e7de4f33f;hp=735f26bff37735baea2c7d4ac90842b5181bf841;hpb=f0edb3e368a5fc69218d20f76f1538b68f37db42;p=lhc%2Fweb%2Fwiklou.git diff --git a/docs/database.txt b/docs/database.txt index 735f26bff3..44ec764d95 100644 --- a/docs/database.txt +++ b/docs/database.txt @@ -8,7 +8,7 @@ By Tim Starling, January 2006. For information about the MediaWiki database layout, such as a description of the tables and their contents, please see: https://www.mediawiki.org/wiki/Manual:Database_layout - https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/core.git;a=blob_plain;f=maintenance/tables.sql;hb=HEAD + https://phabricator.wikimedia.org/diffusion/MW/browse/master/maintenance/tables.sql ------------------------------------------------------------------------ @@ -159,10 +159,7 @@ $dbw->commit( __METHOD__ ); Use of locking reads (e.g. the FOR UPDATE clause) is not advised. They are poorly implemented in InnoDB and will cause regular deadlock errors. -It's also surprisingly easy to cripple the wiki with lock contention. If -you must use them, define a new flag for $wgAntiLockFlags which allows -them to be turned off, because we'll almost certainly need to do so on -the Wikimedia cluster. +It's also surprisingly easy to cripple the wiki with lock contention. Instead of locking reads, combine your existence checks into your write queries, by using an appropriate condition in the WHERE clause of an