Schema changes pending - Wikitech-l - lists.wikimedia.org

List overview All Threads
Download

Schema changes pending

New WP search backend - how to use...

Testing of the LocalisationUpdate...

Tim Starling

6 Jun 2009 6 Jun '09

4:31 p.m.

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

Reply

Show replies by date

Andrew Garrett

6 Jun 6 Jun

5:57 p.m.

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(a)wikimedia.org http://werdn.us

Reply

Andrew Garrett

10:39 p.m.

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(a)wikimedia.org http://werdn.us

Reply

Roan Kattouw

11:12 p.m.

2009/6/6 Tim Starling <tstarling(a)wikimedia.org>rg>:

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)

Reply

Tim Starling

8 Jun 8 Jun

7:13 a.m.

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

Reply

Roan Kattouw

8:14 a.m.

2009/6/8 Tim Starling <tstarling(a)wikimedia.org>rg>:

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)

Reply

Brion Vibber

22 Jun 22 Jun

7:05 p.m.

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

Reply

5456

days inactive

5472

days old

wikitech-l@lists.wikimedia.org

Manage subscription

6 comments

4 participants

tags (0)

participants (4)

Andrew Garrett
Brion Vibber
Roan Kattouw
Tim Starling