In kshwiki, we seem to have an issue with the article count.
10635 non-redirect pages in the pages table
10596 pages according to query in the maintenance script [1]
9972 shown in Special:Statistics
Here are queries made on the toolserver data base, with results:
mysql> use kshwiki_p ;
mysql> SELECT count( page_id ) FROM page \
WHERE ( `page_namespace` ) = 0 \ AND ( `page_is_redirect` = 0 ) ;
+--------------------+
count( page_id ) |
+--------------------+
10635 | |
+--------------------+
1 row in set (10.90 sec)
mysql> SELECT COUNT(DISTINCT page_namespace, page_title) \
AS pagecount FROM `page` , `pagelinks` \ WHERE `pl_from` = `page_id` AND `page_namespace` = 0 \ AND `page_is_redirect` = 0 AND `page_len` > 0 ;
+-----------+
pagecount |
+-----------+
10596 | |
+-----------+
1 row in set (2.93 sec)
mysql> SELECT ss_good_articles FROM site_stats ;
+------------------+
ss_good_articles |
+------------------+
9972 | |
+------------------+
1 row in set (0.00 sec)
Imho, the difference is likely at least in part caused by a
software update. The old parser accepted a some comments inside
redirect pages, which the new parser does not. Thus, some
existing such pages were not included in the good pages count
with the old parser. Now, when we detect them, we correct them,
the new parser sees a non-redirect becoming a redirect, and it
decrements the count of good pages. This may well have happened
~620 times, at least it appers to be a very reasonable figure.
Another issue which I observed several months ago and failed
to report: in order to duplicate two pages, including their edit
history for a page split, either I exported and re-imported
them with new page titles, or I exported, renamed, and reimported them with the original page titles. This did not
increase the page count.
Version: 1.16.x
Severity: major
URL: http://ksh.wikipedia.org/wiki/Spezial:Statistik?uselang=en