Thesite_stats table contains some aggregate info on the state of the site.If the information from this table is wrong, it can be updated with theinitSiteStats.php maintenance script.

Before 1.39, this table contains only one row.Since 1.39, the table may contain multiple rows (currently 10) if$wgMultiShardSiteStats is enabled and all rows should be summed up to get the statistics.

Primary key, should contain 1 before 1.39 or if$wgMultiShardSiteStats is disabled.

Total number of page views, if hit counters were enabled.See:

• Manual:Hitcounter table
• The functionality has beenremoved in MediaWiki 1.25 and made available again by theHitCounters extension.

Total number of edits performed.

An approximate count of pages matching the criteria explained inManual:Article count.

See also Content::isCountable() in includes/content/Content.php

Total pages, theoretically equal toSELECTCOUNT(*)FROMpage; except faster

Number of users, theoretically equal toSELECTCOUNT(*)FROMuser;

Number of users who have edited in the last$wgActiveUserDays days (see also$wgActiveUserEditCount)

Deprecated, no longer updated as of 1.5

Number of images, equivalent toSELECTCOUNT(*)FROMimage;

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(10) unsigned    | NO   | PRI | NULL    |       || ss_total_edits   | bigint(20) unsigned | YES  |     | NULL    |       || ss_good_articles | bigint(20) unsigned | YES  |     | NULL    |       || ss_total_pages   | bigint(20) unsigned | YES  |     | NULL    |       || ss_users         | bigint(20) unsigned | YES  |     | NULL    |       || ss_active_users  | bigint(20) unsigned | YES  |     | NULL    |       || ss_images        | bigint(20) unsigned | YES  |     | NULL    |       |+------------------+---------------------+------+-----+---------+-------+

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(10) unsigned    | NO   | PRI | NULL    |       || ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       || ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       || ss_total_pages   | bigint(20)          | YES  |     | -1      |       || ss_users         | bigint(20)          | YES  |     | -1      |       || ss_active_users  | bigint(20)          | YES  |     | -1      |       || ss_images        | int(11)             | YES  |     | 0       |       |+------------------+---------------------+------+-----+---------+-------+

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(10) unsigned    | NO   | PRI | NULL    |       || ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       || ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       || ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       || ss_total_pages   | bigint(20)          | YES  |     | -1      |       || ss_users         | bigint(20)          | YES  |     | -1      |       || ss_active_users  | bigint(20)          | YES  |     | -1      |       || ss_admins        | int(11)             | YES  |     | -1      |       || ss_images        | int(11)             | YES  |     | 0       |       |+------------------+---------------------+------+-----+---------+-------+

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(10) unsigned    | NO   | PRI | NULL    |       || ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       || ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       || ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       || ss_total_pages   | bigint(20)          | YES  |     | -1      |       || ss_users         | bigint(20)          | YES  |     | -1      |       || ss_admins        | int(11)             | YES  |     | -1      |       || ss_images        | int(11)             | YES  |     | 0       |       |+------------------+---------------------+------+-----+---------+-------+

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(8) unsigned     | NO   | PRI | NULL    |       || ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       || ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       || ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       || ss_total_pages   | bigint(20)          | YES  |     | -1      |       || ss_users         | bigint(20)          | YES  |     | -1      |       || ss_admins        | int(10)             | YES  |     | -1      |       || ss_images        | int(10)             | YES  |     | 0       |       |+------------------+---------------------+------+-----+---------+-------+

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(8) unsigned     | NO   | PRI | NULL    |       || ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       || ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       || ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       || ss_total_pages   | bigint(20)          | YES  |     | -1      |       || ss_users         | bigint(20)          | YES  |     | -1      |       || ss_admins        | int(10)             | YES  |     | -1      |       |+------------------+---------------------+------+-----+---------+-------+

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(8) unsigned     | NO   | PRI | 1       |       || ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       || ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       || ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       || ss_total_pages   | bigint(20)          | YES  |     | -1      |       || ss_users         | bigint(20)          | YES  |     | -1      |       || ss_admins        | int(10)             | YES  |     | -1      |       |+------------------+---------------------+------+-----+---------+-------+

DESCRIBEsite_stats;

+------------------+---------------------+------+-----+---------+-------+| Field            | Type                | Null | Key | Default | Extra |+------------------+---------------------+------+-----+---------+-------+| ss_row_id        | int(8) unsigned     | NO   | PRI | NULL    |       || ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       || ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       || ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       |+------------------+---------------------+------+-----+---------+-------+

SHOWINDEXINsite_stats;

+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| Table      | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| site_stats |          0 | PRIMARY  |            1 | ss_row_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables