On Tue, Mar 2, 2010 at 5:13 AM, Daniel Kinzler <[email protected]> wrote:
> 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.

Since it's InnoDB, it should still be readable even if an index is
being added; only changes to the table should be blocked, no?
Replication will stop, but reads should continue to work fine.

_______________________________________________
Toolserver-l mailing list ([email protected])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: 
https://wiki.toolserver.org/view/Mailing_list_etiquette

Reply via email to