Help:Database layout: Difference between revisions
Content deleted Content added
mNo edit summary Tag: Manual revert |
|||
(43 intermediate revisions by 25 users not shown) | |||
Line 1: | Line 1: | ||
⚫ | |||
{{H:h|hacker toc}} |
|||
⚫ | |||
Moved with full histories. -- Rob Church, 04:00, 28 December 2006 (UTC) |
|||
<small>Other languages: [[Help:データベースレイアウト|日本語 (ja)]] ...[[Meta:Interlanguage links|''Translate this page!'']]</small> |
|||
<- [[MediaWiki architecture]] |
|||
Most data for the wiki is stored in a database. See [[MySQL config]] for setup info. |
|||
(Some data lives only in the [[MediaWiki file usage|filesystem]], other data is just cached there. Data may also be cached in [[memcached]], but lives permanently in the database.) |
|||
'''NB: the current schema for any version - with copious comments - can be found in the <tt>maintenance/tables.sql</tt> file. The latest version can be obtained [http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/wikipedia/phase3/maintenance/tables.sql from CVS].''' |
|||
Version 1.4 uses the following tables: |
|||
*[[archive table]] - "deleted" pages |
|||
*[[blobs table]] |
|||
*[[brokenlinks table]] - links in internal link style to non-existing pages in the same project (see below) |
|||
*[[categorylinks table]] |
|||
*[[cur table]] - current pages |
|||
*[[hitcounter table]] |
|||
*[[image table]] |
|||
*[[imagelinks table]] tracks usage of images in wikipages (see below) |
|||
*[[interwiki table]] |
|||
*[[ipblocks table]] |
|||
*[[links table]] - links in internal link style to existing pages in the same project (see below) |
|||
*[[linkscc table]] - (see below) |
|||
*[[math table]] |
|||
*[[objectcache table]] |
|||
*[[old table]] - old versions of pages |
|||
*[[oldimage table]] |
|||
*[[querycache table]] |
|||
*[[recentchanges table]] |
|||
*[[searchindex table]] |
|||
*[[site_stats table]] |
|||
*[[testac table]] |
|||
*[[user table]] |
|||
*[[user_newtalk table]] |
|||
*[[watchlist table]] |
|||
==Explanation of the link tables== |
|||
There are presently three link tables: ''links'', ''brokenlinks'' and ''imagelinks''. There are a couple of uses for these tables: |
|||
* enables "What links here" and "Related changes" to work, looking at incoming or outgoing links |
|||
* provides the list of pages that use an image shown on an image's description page |
|||
* allows making reports of pages that aren't linked (Orphans, Unused images) or are linked to but don't exist (Most wanted pages) |
|||
* slightly speed up page rendering by avoiding individual checks for the existence of each linked page to determine how to render its link |
|||
The latest software also adds a 'linkscc' table which caches data from the other three tables. This is used only for speeding rendering. |
|||
=== Maintenance of link tables === |
|||
If you import data to the cur table and don't [[rebuild link tables|rebuild the links]], you |
|||
won't be able to use "[[What links here]]", "[[Related changes]]", "[[Orphans]]", |
|||
etc. If you don't want to, well I suppose that's okay... (Brion Vibber) |
|||
== ERD Diagram == |
|||
This is the diagram from the mediawiki database 1.4.X version. |
|||
<center> |
|||
[[Image:DER Mediawiki.PNG]] |
|||
</center> |
|||
It shows the main tables and relations from the database. |
|||
==See also== |
|||
*[[Experimental new database schema]] ''22:55, 24 Jul 2003'' |
|||
*[[Proposed Database Schema Changes]] ''18:19, 23 Dec 2003'' |
|||
*[[en:Wikipedia:Database queries]] |
|||
*[[nl:Wikipedia:SQL opdrachten]] |
|||
*[[Documentation: Developer's Guide]] |
|||
Next page: [[MediaWiki User's Guide: Installation| Installation]] > |
|||
[[Category:MediaWiki User's Guide]] |
|||
[[Category:MediaWiki Development]] |
Latest revision as of 17:24, 8 February 2021
This page has been moved to Manual:Database layout on mediawiki.org.
Any modifications or additions to this page should be made on mediawiki.org instead. |
Moved with full histories. -- Rob Church, 04:00, 28 December 2006 (UTC)