I've got a dump of simple loaded.
When revision.rev_delete = 1, is there a way to tell both when the rev was created and when the rev was deleted?
Thanks!
Jeremy Dunck wrote:
I've got a dump of simple loaded.
When revision.rev_delete = 1, is there a way to tell both when the rev was created and when the rev was deleted?
rev_deleted is not yet used, so the only time this will come up is if you manually set the field to 1. :)
Deleted revisions are removed from the revision table and copied to the archive table. The only record of deletion time is in the logging table, and that won't tell you which revision was deleted when.
-- brion vibber (brion @ pobox.com)
On 10/15/05, Brion Vibber brion@pobox.com wrote:
Deleted revisions are removed from the revision table and copied to the archive table. The only record of deletion time is in the logging table, and that won't tell you which revision was deleted when.
So, deleted revs aren't included in dumps at all?
Deletes are relatively rare (sysop) occurrences, right?
Also, I see through testing that when a revert is done, a new text record is created (as opposed to ref'ing the same text record as the revision being reverted to). Will this be changing?
Jeremy Dunck wrote:
On 10/15/05, Brion Vibber brion@pobox.com wrote:
Deleted revisions are removed from the revision table and copied to the archive table. The only record of deletion time is in the logging table, and that won't tell you which revision was deleted when.
So, deleted revs aren't included in dumps at all?
Right.
Deletes are relatively rare (sysop) occurrences, right?
Relatively.
Also, I see through testing that when a revert is done, a new text record is created (as opposed to ref'ing the same text record as the revision being reverted to). Will this be changing?
Using the rollback button or manual reverts? I thought I'd already done this for rollback, but I could be wrong. Manual reverts would require some checking but is doable.
Note that if you're looking at a database imported from an XML dump, that's a totally different matter; at the moment the dump importers aren't smart enough to merge common text entries. (The XML dumps include plain text in order to isolate the public-consumable data from our ever-shifting implementation details.)
-- brion vibber (brion @ pobox.com)
On 10/15/05, Brion Vibber brion@pobox.com wrote:
Using the rollback button or manual reverts? I thought I'd already done this for rollback, but I could be wrong. Manual reverts would require some checking but is doable.
Manual. But your point is good; it's so easy to edit on a manual revert that the overlap of identical text might not be that large.
Note that if you're looking at a database imported from an XML dump, that's a totally different matter; at the moment the dump importers aren't smart enough to merge common text entries. (The XML dumps include plain text in order to isolate the public-consumable data from our ever-shifting implementation details.)
Right, I'm going off of a loaded XML dump, but was doing my own local manual reverts here to see how the DB behaved.
And isolation from impl details are appreciated. ;-)
Jeremy Dunck wrote:
On 10/15/05, Brion Vibber brion-e+AXbWqSrlAAvxtiuMwx3w@public.gmane.org wrote:
Deleted revisions are removed from the revision table and copied to the archive table. The only record of deletion time is in the logging table, and that won't tell you which revision was deleted when.
So, deleted revs aren't included in dumps at all?
Deletes are relatively rare (sysop) occurrences, right?
Some numbers of the German Wikipedia during two weeks measured with Special:log and Special:Newpages:
delete: 7.561 newpages: 7.438 newusers: 5.460 upload: 3.6302 move: 2.049 revert: ~1.500[1] block: 721 protect: 365 rights: 6 recentchanges: > 150.000[2]
[1] estimate by number of edits containing "revert" in it's comment. [2] estimate based on the last WikiStat numbers
You may wonder why there are more deletes but new pages but the "newpages" log only contains pages that have not been deleted. In my private opinion English Wikipedia does not delete enough non-encyclopaedic articles (like the "List of films ordered by uses of the word fuck" that is TOP 23[3] of the most viewed articles by the way) but the number of deltes should be somewhat higher than in the German Wikipedia. So I guess that there are almost 1.000 deletes a day because so many people confound Wikipedia with a place where they can put any nonsense. Have a look at http://en.wikipedia.org/w/index.php?title=Special%3ALog&type=delete to get to know what I mean.
Greetings, Jakob
[3] http://www2.knams.wikimedia.org/logwood/logwood.php?site=en.wikipedia.org at August, 11th 2005
Hi!
Just a small question from somebody not that familiar with the server structure. How many requests per second do we currently and by average have?
http://wikimedia.org/stats/live/ looks like around 1.300 total requests per second but
http://noc.wikimedia.org/reqstats/reqstats-weekly.png looks more like around 3.000 requests by seconds.
What's the real number? (ignoring local caching by ISPs that we cannot detect)
Thanks and greetings, Jakob
Jakob Voss wrote:
Just a small question from somebody not that familiar with the server structure. How many requests per second do we currently and by average have?
http://wikimedia.org/stats/live/ looks like around 1.300 total requests per second but
This page is obsolete; it doesn't get data from all the systems.
http://noc.wikimedia.org/reqstats/reqstats-weekly.png looks more like around 3.000 requests by seconds.
What's the real number? (ignoring local caching by ISPs that we cannot detect)
That'll be the real number, as far as we know. :) Note that this figure will include style sheets, images, etc as well as page views.
-- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org