Manual:Site stats table/en

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 maintenance script.

Before 1.39, this table contains only one row. Since 1.39, the table may contain multiple rows (currently 10) if is enabled and all rows should be summed up to get the statistics.

ss_row_id
Primary key, should contain 1 before 1.39 or if is disabled.

ss_total_views
Total number of page views, if hit counters were enabled. See:
 * The functionality has been removed in MediaWiki 1.25 and made available again by the extension.
 * The functionality has been removed in MediaWiki 1.25 and made available again by the extension.

ss_total_edits
Total number of edits performed.

ss_good_articles
An approximate count of pages matching the following criteria:


 * in namespace 0
 * not a redirect
 * contains the text " [[ "

See Content::isCountable in includes/content/Content.php

ss_total_pages
Total pages, theoretically equal to  except faster

ss_users
Number of users, theoretically equal to

ss_active_users
Number of users that still edit

ss_admins
Deprecated, no longer updated as of 1.5

ss_images
Number of images, equivalent to

Schema summary
+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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    |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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       |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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       |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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       |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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       |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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      |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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      |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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
 +++--+--+-+---+-+--++--++-+---+ +++--+--+-+---+-+--++--++-+---+ +++--+--+-+---+-+--++--++-+---+
 * 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      |         |               |