Manual:site_stats/es table
From Linux Web Expert
| ↑ Manual: Contenidos de | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>site_stats/es</tvar> table</translate> |
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
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.25</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.25
| Versión de MediaWiki: |
Número total de páginas vistas, si se habilita contadores de visitas. Véase:
- Manual:Tabla hitcounter
- The functionality has been removed in MediaWiki 1.25 and made available again by the HitCounters extension.
ss_total_edits
Número total de ediciones realizadas.
ss_good_articles
Una cuenta aproximada de las páginas que emparejan los siguientes criterios:
- en el espacio de nombres 0
- no es una redirección
- contiene el texto '[['
Véase Content::isCountable() en includes/content/Content.php
ss_total_pages
Páginas totales, teóricamente iguales a SELECT COUNT(*) FROM page; excepto más rápidas
ss_users
Número de usuarios, teóricamente iguales a SELECT COUNT(*) FROM user;
ss_active_users
| Versión de MediaWiki: | <translate> ≥</translate> 1.14 |
Número de usuarios que todavía editan
ss_admins
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.20</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.20
| Versión de MediaWiki: |
Deprecated, no longer updated as of 1.5
ss_images
Número de imágenes, equivalente a SELECT COUNT(*) FROM image;
Schema summary
<translate> ≥</translate> 1.31
| <translate> MediaWiki version:</translate> |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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 | | +------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.30</tvar> is unsupported version</translate>">
1.21 – 1.30
| <translate> MediaWiki versions:</translate> |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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 | | +------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.20</tvar> is unsupported version</translate>">
1.14 – 1.20
| <translate> MediaWiki versions:</translate> |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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 | | +------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.13</tvar> is unsupported version</translate>">
1.10 – 1.13
| <translate> MediaWiki versions:</translate> |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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 | | +------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.9</tvar> is unsupported version</translate>">
1.6 – 1.9
| <translate> MediaWiki versions:</translate> |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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 | | +------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.5</tvar> is unsupported version</translate>">
1.5
| Versión de MediaWiki: |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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 | | +------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.4</tvar> is unsupported version</translate>">
1.4
| Versión de MediaWiki: |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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 | | +------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.3</tvar> is unsupported version</translate>">
1.1 – 1.3
| <translate> MediaWiki versions:</translate> |
DESCRIBE site_stats/es;
+------------------+---------------------+------+-----+---------+-------+ | 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
<translate> ≥</translate> 1.30
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN site_stats/es;
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
