Manual talk:Pagelinks table

From mediawiki.org
Latest comment: 2 years ago by Valerio Bozzolan in topic pl_from_namespace

Update info[edit]

  • Does anyone know how often this table is updated? In my wiki, it contains rows for links which no longer exist, and I don't know how to tell mediawiki to flush the table and re-calculate links. Wanderingstan 22:32, 14 April 2008 (UTC)Reply
    • You can rebuild this table using the script refreshLinks.php. So, if your MediaWiki installation is in /var/www/mw, then run /var/www/mw/maintenance/refreshLinks.php. Note that, for a large data set (such as the Wikipedia English dumps), this takes a ridiculously large amount of time. 24.246.22.40 00:17, 28 May 2011 (UTC)Reply

Rows count[edit]

Does anyone have a stat about how many rows are in the pagelinks table roughly? Thanks! -- Kcg2015 20:13, 15 October 2015‎

pl_from_namespace[edit]

AFAIK the namespace contained in pl_from_namespace is exactly the same namespace that can be found with this request:

SELECT page_namespace FROM page WHERE page_id = pl_from

Is it true? If yes. Is this column for de-normalization purposes? Valerio Bozzolan (talk) 15:25, 9 March 2022 (UTC)Reply