Manual:hitcounter table

↑ Manual:Contents

MediaWiki database layout

hitcounter table

MediaWiki version:

≥ 1.3

The hitcounter table in MediaWiki is a temporary buffer for storage of page view information. If $wgHitcounterUpdateFreq is set to a value bigger than 1, this table stores the page_id value of every page that was visited. The value of $wgHitcounterUpdateFreq is then fed into a randomizer, which then updates the page_counter fields of the stored pages when the random number is equal to a particular value. This reduces database load; updating the page_counter field with every page hit is a main source for slow queries. After this batch update of the page_counter fields has been done, the hitcounter table is emptied.

This table was introduced in MediaWiki 1.3, and will always be empty if $wgDisableCounters is set to true. Additionally, if $wgHitcounterUpdateFreq is set to 1, the page table is directly updated, and this table is not used.

Fields

hc_id

Contains the page_id of each visited page in the buffer.

Schema summary

MediaWiki version:

≥ 1.3

DESCRIBE hitcounter gives the following:

+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| hc_id | int(10) unsigned | NO   |     | NULL    |       |
+-------+------------------+------+-----+---------+-------+

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist

Language:	English  • 日本語