Ævar Arnfjörð Bjarmason | 1 Jan 2006 11:50
Picon
Gravatar

MediaWiki CVS statistics

As my first toolserver project I've made some statistics of the
activity in our CVS repository. I made aggregated statistics of the
whole repository[1] as well as statistics for individual modules[2].
You'll see per commiter statistics there, LOC statistics, file &
directory statistics and changelogs. Addidionally I've put the raw CVS
changelogs up there too[4], and finally the whole thing can be
downloaded[3] for local viewing & hacking, just make sure you're
*ahem* adhering to the license[5].

1. http://tools.wikimedia.de/~avar/cvs/html/all/
2. http://tools.wikimedia.de/~avar/cvs/html/
3. http://tools.wikimedia.de/~avar/cvs/cvs.tar.gz
4. http://tools.wikimedia.de/~avar/cvs/log/
5. http://tools.wikimedia.de/~avar/cvs/COPYING
Jakob Voss | 1 Jan 2006 13:54
Picon
Gravatar

Re: MediaWiki CVS statistics

Hi,

Ævar Arnfjörð Bjarmason wrote:

 > As my first toolserver project I've made some statistics of the
 > activity in our CVS repository. I made aggregated statistics of the
 > whole repository[1] as well as statistics for individual modules[2].
 > You'll see per commiter statistics there, LOC statistics, file &
 > directory statistics and changelogs. Addidionally I've put the raw CVS
 > changelogs up there too[4], and finally the whole thing can be
 > downloaded[3] for local viewing & hacking, just make sure you're
 > *ahem* adhering to the license[5].
 >
 > 1. http://tools.wikimedia.de/~avar/cvs/html/all/
 > 2. http://tools.wikimedia.de/~avar/cvs/html/
 > 3. http://tools.wikimedia.de/~avar/cvs/cvs.tar.gz
 > 4. http://tools.wikimedia.de/~avar/cvs/log/
 > 5. http://tools.wikimedia.de/~avar/cvs/COPYING

Thanks for this cvs analysis. The distribution of activity per author
is typical as well as other distributions. If you look around for 
general tools and projects in quantitative measurement of open source 
software you'll stumble upon the Libresoft group at the Universidad Rey 
Juan Carlos, Madrid:

http://libresoft.urjc.es/

For instance have a look at:

http://libresoft.dat.escet.urjc.es/cvsanal/kde3-cvs/index.php?menu=Statistics
(Continue reading)

kate | 2 Jan 2006 13:10
Picon
Favicon

database names are changing

hi,

i was looking at memory usage on zedler recently, and discovered that grant 
tables are using a significant amount of memory.  i have implemented a 
better solution, but as a side-effect, names of databases are changing.  
from now on, each database X should be accessed as X_p (e.g.: "enwiki_p").  
the old names will stop working shortly (sooner rather than later, since i 
would like to reclaim the wasted memory).

also, the "rc_filtered" and "ar_filtered" tables will be known as 
"recentchanges" and "archive" instead.

this will free about 2GB of RAM to be used by InnoDB, which should improve 
performance.

k.
kate | 2 Jan 2006 13:26
Picon
Favicon

Re: lynx

Tony Sidaway:
TS> I like to have lynx around

okay, installed.

k.
Daniel Kinzler | 2 Jan 2006 13:45
Picon
Favicon
Gravatar

Re: database names are changing

> from now on, each database X should be accessed as X_p (e.g.: "enwiki_p").  
> the old names will stop working shortly (sooner rather than later, since i 
> would like to reclaim the wasted memory).

please update the toolserver.wiki table accordingly.

Thanks,
Daniel

--

-- 
Homepage: http://brightbyte.de

kate | 2 Jan 2006 13:49
Picon
Favicon

Re: database names are changing

Daniel Kinzler:
DK> please update the toolserver.wiki table accordingly.

okay, done.

k.
TDS | 3 Jan 2006 00:39

Legality of a Deleted Edits Lister

Hey there,

I was helping a user yesterday restore some images that shouldn't  
have been deleted, and in the course of helping them I have crafted a  
deleted edit lister, similar to kate's. I was wondering about the  
legality of a deleted edits lister sans comments, and with an opt-out  
feature for specific revisions, and specific users.

TDS
tds <at> cloudstormtech.com

Phroziac | 3 Jan 2006 01:02
Picon

Re: Legality of a Deleted Edits Lister


TDS wrote:
> Hey there,
> 
> I was helping a user yesterday restore some images that shouldn't  have
> been deleted, and in the course of helping them I have crafted a 
> deleted edit lister, similar to kate's. I was wondering about the 
> legality of a deleted edits lister sans comments, and with an opt-out 
> feature for specific revisions, and specific users.
> 
> TDS
> tds <at> cloudstormtech.com
Kate told me I could just steal hers and use it, as long as i didn't
give the public access to it.

You can't do any sort of password authentication though, so it'll
basically be for you and a few admin friends.

I never got around to doing that.

--
Stephanie Amanda S.
Encrypted Email Preferred
OpenPGP key ID: C9774A04
  http://tinyurl.com/8wxzb
Daniel Kinzler | 3 Jan 2006 01:53
Picon
Favicon
Gravatar

templatelinks

Hi

MW now has a templatelinks table for tracking template inclusions, but i 
don't see those on the toolserver.

It would be very helpful to me to have those

-- Daniel

--

-- 
Homepage: http://brightbyte.de

TDS | 3 Jan 2006 08:06

Proposal: SQL Query Scheduling

I've only been here for a few days, and I have already noticed a  
large issue with users running queries that may take several hours,  
without any notification to other users of the tools server, often  
resulting in replication lag. While notifying the users of the tools  
server will not exactly be a big help, a query that is intended to  
take up a large chunk of time could be shown to users of the tool  
server for help with any possible optimizations that may result in  
speed increases with your query. As well, a query can be  
strategically placed to run at times when the tool server is at low  
activity (possibly during the night.)

Just a thought.

TDS
tds <at> cloudstormtech.com


Gmane