10 Aug
2010
10 Aug
'10
6:37 a.m.
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.