Manual:site_stats table
| ↑ Manual:Contents | MediaWiki database layout | site_stats table |
The site_stats table contains a single row with some aggregate info on the state of the site. If the information from this table is wrong, it can be updated with the initSiteStats.php maintenance script.
FieldsEdit
ss_row_idEdit
Primary key, should contain 1.
ss_total_viewsEdit
| MediaWiki version: | ≤ 1.25 |
Total number of page views, if hit counters were enabled.
ss_total_editsEdit
Total number of edits performed.
ss_good_articlesEdit
An approximate count of pages matching the following criteria:
- in namespace 0
- not a redirect
- contains the text "[["
See Content::isCountable() in includes/content/Content.php
ss_total_pagesEdit
Total pages, theoretically equal to SELECT COUNT(*) FROM page; except faster
ss_usersEdit
Number of users, theoretically equal to SELECT COUNT(*) FROM user;
ss_active_usersEdit
| MediaWiki version: | ≥ 1.14 |
Number of users that still edit
ss_adminsEdit
| MediaWiki version: | ≤ 1.20 |
Deprecated, no longer updated as of 1.5
ss_imagesEdit
Number of images, equivalent to SELECT COUNT(*) FROM image;
Schema summaryEdit
| MediaWiki version: | ≥ 1.31 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.21 – 1.30 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.14 – 1.20 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.10 – 1.13 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.6 – 1.9 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki version: | 1.5 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki version: | 1.4 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.1 – 1.3 |
DESCRIBE site_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 | | +------------------+---------------------+------+-----+---------+-------+