Please let me know if you know of any schema changes that need to be run on Wikimedia wikis apart from the following:
http://wikitech.wikimedia.org/view/Schema_changes
This includes optional changes such as feature blockers and performance enhancements.
I'd like to run them in the next 24-48 hours. There should be no disruption to service.
-- Tim Starling
On 06/06/2009, at 5:31 PM, Tim Starling wrote:
Please let me know if you know of any schema changes that need to be run on Wikimedia wikis apart from the following:
http://wikitech.wikimedia.org/view/Schema_changes
This includes optional changes such as feature blockers and performance enhancements.
I'd like to run them in the next 24-48 hours. There should be no disruption to service.
There are some other AbuseFilter feature blockers that I'd like to run (related to hiding and patrolling log entries) although the features aren't yet written. I'll try to get them done in a few hours and tell you the patch file names when I'm done.
-- Andrew Garrett Contract Developer, Wikimedia Foundation agarrett@wikimedia.org http://werdn.us
On 06/06/2009, at 5:31 PM, Tim Starling wrote:
Please let me know if you know of any schema changes that need to be run on Wikimedia wikis apart from the following:
http://wikitech.wikimedia.org/view/Schema_changes
This includes optional changes such as feature blockers and performance enhancements.
I'd like to run them in the next 24-48 hours. There should be no disruption to service.
Rolled optional feature-blocking schema changes for AbuseFilter hiding and patrolling of log entries, to extensions/AbuseFilter/patch- hide_patrol.sql.
Assuming it looks okay to you, it makes sense to apply this patch too, and I will develop the accompanying functionality later.
-- Andrew Garrett Contract Developer, Wikimedia Foundation agarrett@wikimedia.org http://werdn.us
2009/6/6 Tim Starling tstarling@wikimedia.org:
Please let me know if you know of any schema changes that need to be run on Wikimedia wikis apart from the following:
http://wikitech.wikimedia.org/view/Schema_changes
This includes optional changes such as feature blockers and performance enhancements.
I'd like to run them in the next 24-48 hours. There should be no disruption to service.
* Please add the rc_user_text (rc_user_text, rc_timestamp) index to all database servers (blocking deployment of bug 14200 fix), as well as cl_sortkey (cl_to,cl_sortkey,cl_from) (see bug 17558 and the live hack in ApiQueryCategoryMembers.php) * Please add the rd_interwiki and rd_fragment fields to the redirect table (bug 14418; will commit DB patches within 24 hrs, actual implementation still has a few issues) * I've also got a patch for rev_bot and rev_patrolled fields lying around at bug 17237, but it's old, missing the actual DB patch and I'm not sure you guys (meaning the senior devs) agree with adding these fields, so we might wanna hold off on this one for now
Roan Kattouw (Catrope)
Roan Kattouw wrote:
- Please add the rc_user_text (rc_user_text, rc_timestamp) index to
all database servers (blocking deployment of bug 14200 fix),
That was already on the list.
as well as cl_sortkey (cl_to,cl_sortkey,cl_from) (see bug 17558 and the live hack in ApiQueryCategoryMembers.php)
Added.
- Please add the rd_interwiki and rd_fragment fields to the redirect
table (bug 14418; will commit DB patches within 24 hrs, actual implementation still has a few issues)
I waited 24 hours, didn't see any commit. Schema updates are now in progress without it.
- I've also got a patch for rev_bot and rev_patrolled fields lying
around at bug 17237, but it's old, missing the actual DB patch and I'm not sure you guys (meaning the senior devs) agree with adding these fields, so we might wanna hold off on this one for now
Maybe next time.
-- Tim Starling
2009/6/8 Tim Starling tstarling@wikimedia.org:
Roan Kattouw wrote:
- Please add the rc_user_text (rc_user_text, rc_timestamp) index to
all database servers (blocking deployment of bug 14200 fix),
That was already on the list.
as well as cl_sortkey (cl_to,cl_sortkey,cl_from) (see bug 17558 and the live hack in ApiQueryCategoryMembers.php)
Added.
- Please add the rd_interwiki and rd_fragment fields to the redirect
table (bug 14418; will commit DB patches within 24 hrs, actual implementation still has a few issues)
I waited 24 hours, didn't see any commit. Schema updates are now in progress without it.
Commit was slightly overdue; I committed while you were typing your post :(
Roan Kattouw (Catrope)
Tim Starling wrote:
Please let me know if you know of any schema changes that need to be run on Wikimedia wikis apart from the following:
http://wikitech.wikimedia.org/view/Schema_changes
This includes optional changes such as feature blockers and performance enhancements.
I'd like to run them in the next 24-48 hours. There should be no disruption to service.
Are these all done? The page doesn't currently list whether the listed scripts have been run or are pending.
-- brion
wikitech-l@lists.wikimedia.org