hello everyone..
i have a mysql table that unfortunately, has been used by my company to store like a zillion blobs (roughly 154,000). In total its around 53GB. I need to alter the table to add an extra field (to eventually migrate the blobs to a better storage solution). i know 'alter table' works by copying to a temporary table, then deleting the original, but i'm not quite sure if the machine this thing is on could handle the opertion. the table is InnoDB. Naturally i will back up my datadir, but does anyone know if im about to waste my time, will this take days, weeks?
