Manual:Site stats table/ja

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.

ss_total_views
Total number of page views, if hit counters are enabled.

ss_total_edits
Total number of edits performed.

ss_good_articles
An approximate count of pages matching the following criteria: See Article::isCountable in includes/Article.php
 * in namespace 0
 * not a redirect
 * contains the text '[['

ss_total_pages
Total pages, theoretically equal to SELECT COUNT(*) FROM page; except faster

ss_users
Number of users, theoretically equal to SELECT COUNT(*) FROM user;

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 SELECT COUNT(*) FROM image

バージョン
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       |       |

describe site_stats; in version 1.14 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      |       |

describe site_stats; in version 1.9: 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       |       |

describe site_stats; in version 1.8: +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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       |       |

describe site_stats; in version 1.5: +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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      |       |

describe site_stats; in version 1.4: +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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       |       |