[arch-dev-public] FluxBB update round two

Jan de Groot jan at jgc.homeip.net
Tue Aug 10 02:37:26 EDT 2010

On Tue, 2010-08-10 at 00:05 -0500, Dan McGee wrote:
> >  alter table posts change message message mediumtext
> ALTER TABLE posts MODIFY message mediumtext;
> will probably work without needing to "rename" the column.
> > This takes about 10 minutes here and it seems the DB is not locked
> > during that time. (So, is it correct that we can keep the forums
> online
> > then?) If nobody objects I'll do the update tonight. (about now +
> 13h) 

I think both queries do the same. I don't know how big tables are, but
you could be facing a complete table rebuild when running such a query.
During this rebuild the complete table is locked for writing, as with
any alter table query.

More information about the arch-dev-public mailing list