Manual:Site stats table/es

The site_stats table contains a single row with some aggregate info on the state of the site. ss_row_id is pointlessly indexed to assuage developer superstitions.

ss_row_id
The single row should contain 1 here. Este campo no tiene ninguna utilidad en absoluto.

ss_total_views
Número total de páginas vistas, si se habilita contadores de visitas. Eliminado en MW 1.26.

ss_total_edits
Número total de ediciones realizadas.

ss_good_articles
Una cuenta aproximada de las páginas que emparejan los siguientes criterios: Véase Content::isCountable en includes/content/Content.php
 * en el espacio de nombres 0
 * no es una redirección
 * contiene el texto '[['

ss_total_pages
Páginas totales, teóricamente iguales a  excepto más rápidas

ss_users
Número de usuarios, teóricamente iguales a

ss_active_users
Número de usuarios que todavía editan

ss_admins
Deprecated, no longer updated as of 1.5

ss_images
Número de imágenes, equivalente a

Versiones
mysql> describe site_stats; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+ 8 rows in set (0.00 sec)
 * 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_images       | int(11)             | YES  |     | 0       |       |

mysql> 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       |       |

mysql> describe mw_site_stats; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+ 9 rows in set (0.00 sec)
 * Field           | Type                | Null | Key | Default | Extra |
 * ss_row_id       | int(8) unsigned     | NO   | PRI |         |       |
 * 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       |       |
 * ss_active_users | bigint(20)          | YES  |     | -1      |       |

mysql> describe mw_site_stats; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+ 8 rows in set (0.01 sec)
 * 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       |       |

mysql> 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       |       |

mysql> describe site_stats; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field           | Type                | Null | Key | Default | Extra |
 * ss_row_id       | int(8) unsigned     | NO   | PRI |         |       |
 * 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      |       |

mysql> describe site_stats; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field           | Type                | Null | Key | Default | Extra |
 * ss_row_id       | int(8) unsigned     |      | PRI | 0       |       |
 * ss_total_views  | bigint(20) unsigned | YES  |     | 0       |       |
 * ss_total_edits  | bigint(20) unsigned | YES  |     | 0       |       |
 * ss_good_articles | bigint(20) unsigned | YES |     | 0       |       |