On Tue, Mar 2, 2010 at 5:13 AM, Daniel Kinzler daniel@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.