Jon.G.Bartlett at gsk
Nov 26, 2009, 3:30 AM
Post #6 of 7
(693 views)
Permalink
|
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: mediawiki-l-bounces [at] lists [mailto:mediawiki-l-bounces [at] lists] On Behalf Of Sam.Sexton [at] thomsonreuters
Sent: 26 November 2009 11:02
To: mediawiki-l [at] lists
Subject: Re: [Mediawiki-l] Usage stats questions
Nevio,
Platonides suggested looking at your web server access log. The following works for me:
[2864](root [at] ncq-wiki0)/usr/local/apache2/logs/Nov: grep 'GET.*a_page_name' 20091126_access.log | wc -l
8
[2865](root [at] ncq-wiki0)/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: mediawiki-l-bounces [at] lists [mailto:mediawiki-l-bounces [at] lists] 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 <Platonides [at] gmail>
> 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
> MediaWiki-l [at] lists
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
--
{+}Nevinho
Venha para o Movimento Colaborativo http://sextapoetica.com.br !!
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
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
MediaWiki-l [at] lists
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
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
|
