Jon Bartlett wrote: > I can see in the Wiki db that there is a page_counter (in table 'page')- I > can only assume this is a count of number of page 'hits'. Right. Note however that it will be undercounted if you use a caching proxy, like squid.
> It would be possible to automate queries that run daily/hourly etc to look at > these values, and then interrogate them over time. Yes. You could. But looking at the server logs is probably easier. > However, I don't understand several of the fields in the MW database - what > for example is the 'Page_latest', 'page_touched' and 'Page_latest' fields ? > is there a db descriptions somewhere ? > > Jon id of the last revision, the timestamp of last time the page cache has been invalidated (copies previous to that timestamp are outdated). The schema is described at http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?view=markup There're also descriptions about it at www.mediawiki.org _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
