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'. It would be possible to automate queries that run daily/hourly etc to look at these values, and then interrogate them over time. 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 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: 26 November 2009 11:02 To: [email protected] Subject: Re: [Mediawiki-l] Usage stats questions Nevio, Platonides suggested looking at your web server access log. The following works for me: [2864](r...@ncq-wiki01)/usr/local/apache2/logs/Nov: grep 'GET.*a_page_name' 20091126_access.log | wc -l 8 [2865](r...@ncq-wiki01)/usr/local/apache2/logs/Nov: You'd need to script that to generalise it and identify all the pages [you need] - eliminating *.css, *.js, all flavours of images etc. is a start. /Sam -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of nevio carlos de alarcão Sent: 26 November 2009 10:50 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Usage stats questions Hi Platonides, I am also very interested in counting the number a particular page has been viewed on the corporate wiki I am administering, even if it is only few times. which code lines should be add to localssetings? Is there? 2009/11/25 Platonides <[email protected]> > Jon Bartlett wrote: > > All, > > > > I'm trying to gauge the value of my internal company Wiki, and I > > want to > produce some usage statistics (primarily around pages being read, > rather than edited). Typically, things like number of pages read > today, or this week etc. > > Can anyone point me to where either the database structures are > described, so I can create some offline queries myself ? > > > > Also, anyone know if there is a way to get the Statistics page > (Special:Statistics) to Exclude hits from the various indexers/spiders > for my internal company Wiki - as currently I suspect the huge number > of daily page reads are due to search engines... > > I think I asked the latter Question before - but got no replies... > > > > Many thanks, > > Jon > > The wiki doesn't store the reads. It can have a per page read count, > but nothing more. What you can do is analyse your server access log to > get the data you want. > > > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > -- {+}Nevinho Venha para o Movimento Colaborativo http://sextapoetica.com.br !! _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l This email was sent to you by Thomson Reuters, the global news and information company. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Thomson Reuters. _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l ----------------------------------------------------------- This e-mail was sent by GlaxoSmithKline Services Unlimited (registered in England and Wales No. 1047315), which is a member of the GlaxoSmithKline group of companies. The registered address of GlaxoSmithKline Services Unlimited is 980 Great West Road, Brentford, Middlesex TW8 9GS. ----------------------------------------------------------- _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
