Manual:Site stats table/en

The site_stats table contains a single row with 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.

ss_row_id
Primary key, should contain 1.

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