[Toolserver-l] commonswiki updates

[Daniel Kinzler]

Hi all

I have started adding the index on sql-s1-fast (rosemary) to see how long it
takes. I will probably do the other db servers tomorrow and/or on Wednesday.

-- daniel

Daniel Kinzler schrieb:
> Hi all
> 
> In the next few days, I will be adding a new index to the globalimagelinks table
> in the commonswiki database. creating this index will take a couple of hours,
> and the table will be locked during that time. This also means that replication
> of the commonswiki database will stop for the time it takes to create the index,
> and may take some time to catch up again after is is finished.
> 
> This task will be repeated for each database server, since commons is replicated
> to each. I will try to avoid doing it at peak times, but since I don't know yet
> how long it takes, and I should be around to watch it, I can't promise if it
> will work out that way.
> 
> -- daniel
> 
> _______________________________________________
> Toolserver-l mailing list (Toolserver-l at lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/toolserver-l
> Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette