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