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