Podręcznik:Tabela site_stats
Outdated translations are marked like this.
| ↑ Podręcznik:Spis treści | Opis i struktura bazy danych MediaWiki | Tabela site_stats |
Tabela site_stats zawiera parę sumarycznych danych o stanie strony. 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.
Pola
ss_row_id
Primary key, should contain 1 before 1.39 or if $wgMultiShardSiteStats is disabled.
ss_total_views
| Wersja MediaWiki: | ≤ 1.25 |
Łączna liczba odsłon, jeżeli zostały włączone liczniki. See:
- Manual:hitcounter table
- The functionality has been removed in MediaWiki 1.25 and made available again by the HitCounters extension.
ss_total_edits
Całkowita liczba dokonanych edycji.
ss_good_articles
Przybliżona liczba stron spełniających następujące kryteria:
- w przestrzeni nazw 0
- nie będących przekierowaniami
- zawierającymi tekst '[['
Zobacz Content::isCountable() w includes/content/Content.php
ss_total_pages
Total pages, theoretically equal to SELECT COUNT(*) FROM page; except faster
ss_users
Liczba użytkowników, teoretycznie równa SELECT COUNT(*) FROM user;
ss_active_users
| Wersja MediaWiki: | ≥ 1.14 |
Liczba użytkowników, którzy nadal edytują
ss_admins
| Wersja MediaWiki: | ≤ 1.20 |
Deprecated, no longer updated as of 1.5
ss_images
Number of images, equivalent to SELECT COUNT(*) FROM image;
Schema summary
| Wersja 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 | | +------------------+---------------------+------+-----+---------+-------+
| Wersje 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 | | +------------------+---------------------+------+-----+---------+-------+
| Wersje 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 | | +------------------+---------------------+------+-----+---------+-------+
| Wersje 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 | | +------------------+---------------------+------+-----+---------+-------+
| Wersje 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 | | +------------------+---------------------+------+-----+---------+-------+
| Wersja 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 | | +------------------+---------------------+------+-----+---------+-------+
| Wersja 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 | | +------------------+---------------------+------+-----+---------+-------+
| Wersje 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
| Wersja 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 | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+