[Mediawiki-l] Usage stats questions

[Jon Bartlett]

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.wikimedia.org [mailto:mediawiki-l-bounces at lists.wikimedia.org] On Behalf Of Sam.Sexton at thomsonreuters.com
Sent: 26 November 2009 11:02
To: mediawiki-l at lists.wikimedia.org
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-wiki01)/usr/local/apache2/logs/Nov: grep 'GET.*a_page_name' 20091126_access.log | wc -l
       8
[2865](root at 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: mediawiki-l-bounces at lists.wikimedia.org [mailto:mediawiki-l-bounces at lists.wikimedia.org] 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.com>

> 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.wikimedia.org
> 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.wikimedia.org
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.wikimedia.org
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.
-----------------------------------------------------------