Manual:Site stats table/es

This page is a translated version of the page Manual:Site stats table and the translation is 62% complete.
Manual:Contenido MediaWiki database layout site_stats table

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

Versión de MediaWiki:
1.25

Número total de páginas vistas, si se habilita contadores de visitas. Véase:

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:
1.14

Número de usuarios que todavía editan

ss_admins

Versión de MediaWiki:
1.20

Deprecated, no longer updated as of 1.5

ss_images

Número de imágenes, equivalente a SELECT COUNT(*) FROM image;

Schema summary

Versión de 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    |       |
+------------------+---------------------+------+-----+---------+-------+
Versiones de 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       |       |
+------------------+---------------------+------+-----+---------+-------+
Versiones de 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       |       |
+------------------+---------------------+------+-----+---------+-------+
Versiones de 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       |       |
+------------------+---------------------+------+-----+---------+-------+
Versiones de 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       |       |
+------------------+---------------------+------+-----+---------+-------+
Versión de 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      |       |
+------------------+---------------------+------+-----+---------+-------+
Versión de 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      |       |
+------------------+---------------------+------+-----+---------+-------+
Versiones de 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

Versión de 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      |         |               |
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+