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.

