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@wikimedia.org Reply-To: Wikimedia developers wikitech-l@lists.wikimedia.org To: Wikimedia developers wikitech-l@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@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