dépôts
/
lhc
/
web
/
wiklou.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
SECURITY: Add permission check for user is permitted to view the log type
[lhc/web/wiklou.git]
/
docs
/
database.txt
diff --git
a/docs/database.txt
b/docs/database.txt
index
735f26b
..
dbc9204
100644
(file)
--- 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
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
------------------------------------------------------------------------
------------------------------------------------------------------------
@@
-17,7
+17,7
@@
description of the tables and their contents, please see:
To make a read query, something like this usually suffices:
To make a read query, something like this usually suffices:
-$dbr = wfGetDB( DB_
SLAVE
);
+$dbr = wfGetDB( DB_
REPLICA
);
$res = $dbr->select( /* ...see docs... */ );
foreach ( $res as $row ) {
...
$res = $dbr->select( /* ...see docs... */ );
foreach ( $res as $row ) {
...
@@
-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.
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
Instead of locking reads, combine your existence checks into your write
queries, by using an appropriate condition in the WHERE clause of an