Manual:Site stats table/pt
| ↑ Manual:Conteúdos | Disposição da base de dados do MediaWiki | Tabela das site_stats |
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.
Campos
ss_row_id
Primary key, should contain 1 before 1.39 or if $wgMultiShardSiteStats is disabled.
ss_total_views
| Versão MediaWiki: | ≤ 1.25 |
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.
ss_total_edits
Total number of edits performed.
ss_good_articles
An approximate count of pages matching the following criteria:
- no espaço de nomes 0
- não é uma redirección
- contém o texto '[['
See Content::isCountable() in includes/content/Content.php
ss_total_pages
Total pages, theoretically equal to SELECT COUNT(*) FROM page; except faster
ss_users
Number of users, theoretically equal to SELECT COUNT(*) FROM user;
ss_active_users
| Versão MediaWiki: | ≥ 1.14 |
Number of users that still edit
ss_admins
| Versão MediaWiki: | ≤ 1.20 |
Deprecated, no longer updated as of 1.5
ss_images
Number of images, equivalent to SELECT COUNT(*) FROM image;
Schema summary
| Versão MediaWiki: | ≥ 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 | | +------------------+---------------------+------+-----+---------+-------+
| Versões do MediaWiki: | 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 | | +------------------+---------------------+------+-----+---------+-------+
| Versões do MediaWiki: | 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 | | +------------------+---------------------+------+-----+---------+-------+
| Versões do MediaWiki: | 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 | | +------------------+---------------------+------+-----+---------+-------+
| Versões do MediaWiki: | 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 | | +------------------+---------------------+------+-----+---------+-------+
| Versão MediaWiki: | 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 | | +------------------+---------------------+------+-----+---------+-------+
| Versão MediaWiki: | 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 | | +------------------+---------------------+------+-----+---------+-------+
| Versões do MediaWiki: | 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 | | +------------------+---------------------+------+-----+---------+-------+
Indexes
| Versão MediaWiki: | ≥ 1.30 |
SHOW INDEX IN site_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 | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+