Maybe some file-transfering magic can be done to add the index in the other dbs by copying it from rosemary?
Daniel Kinzler schrieb:
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