Manual:site_stats table

From mediawiki.org

Translate this page

The site_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 the initSiteStats.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 been removed in MediaWiki 1.25 and made available again by the HitCounters extension.

Total number of edits performed.

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

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

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

Number of users, theoretically equal to SELECTCOUNT(*)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 to SELECTCOUNT(*)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 | | |
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Site_stats_table&oldid=7827121"

Category:

• MediaWiki database tables