On Tue, Mar 2, 2010 at 5:13 AM, Daniel Kinzler <daniel(a)brightbyte.de> 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.