Great.
Some notes about ar_page_id:
I am finishing up code that will stop article histories from being merged
(merges, if done at all, should be using the proper software mechanisms, not
hacks). Though I'll commit it with the other rev_deleted stuff (which
awaits log_id).
On my installation, one can no longer move [[Wikipedia]] over [[George
Bush]] (deleted to make way for move) then delete/restore the revisions,
which would mix 60,000+ interwove revisions (which is fun to fix...).
Also, such is needed for using a restore-point based undeletion method
(which works well with paging for special:undelete), since you can't check
all revs from one page and restore those only anymore. Paging has the
advantage of not having your browser crash over 35,000 revisions.
-Aaron Schulz
From: Brion Vibber <brion(a)wikimedia.org>
Reply-To: Wikimedia developers <wikitech-l(a)lists.wikimedia.org>
To: Wikimedia developers <wikitech-l(a)lists.wikimedia.org>
Subject: [Wikitech-l] Schema changes in progress
Date: Sat, 11 Aug 2007 14:49:30 -0400
Now that the earlier DB outage is taken care of, I'm running the DB
schema changelets which have held back main code updates on the live
site since the week before Wikimania.
Updates to image, oldimage, and archive tables are being applied on the
slave servers. The new additions will:
* Speed up user renames
* Allow cleaner lookups of uploaded files by name
* Store of file content hashes for various purposes
* Store page_id of deleted pages for later use in restore or other
sorting out of fun situations
There will be intermittent slave lag while these run.
Once all the slaves are done, we'll have to swap masters and run them on
the old masters before updating code.
-- brion vibber (brion @
wikimedia.org)
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/wikitech-l
_________________________________________________________________
Tease your brain--play Clink! Win cool prizes!
http://club.live.com/clink.aspx?icid=clink_hotmailtextlink2