Talk:Ruwiki pgcounter

From Meta, a Wikimedia project coordination wiki

I do not get it. It was disabled a long time ago because it was a strain on the servers. What makes you think this tool will not be a strain itself , Anthere

I've seriously analyzed built-in MediaWiki counter. Looks like it was disabled not for high system load (it should work fine with >= 20000 queries per second) but because of disk space required. It takes at least 4 bytes for each request, but with 2000 queries per second it could take 659 Mb. after only one day of work.
First of all, I've optimized this. Now statistics is not list of hits, but number of hits for each page (identified by unique page id). This database can't take more than 8 Mb. for million of pages. Looks like this problem is resolved.
Of course, modifying database is slower than inserting into it. So I've also added some CPU-time optimizations. With MySQL server, stored procedures and prepared statements are used (in documentation, parsing of request is about 50% of it's execution time - I've prepared it before actual work). Yesterday I also moved counter code from CGI to separate HTTP server listening on port 22901. It also uses permanent connection to MySQL and very aggressive page_name->page_id cache (hits to pages just created or renamed are lost for 3-24 hours, but it seriously improves perfomance).
I think that this scheme can handle not only ruwiki but even for enwiki. High load of this counter is not problem more.
(sorry for my English) Edward Chernenko 05:45, 23 May 2006 (UTC)[reply]

Is the counter still available?[edit]

I went to Russia's wikipedia list of special papges, and popular pages doesn't seem to be listed there. Andjam 17:11, 7 April 2007 (UTC)[reply]