I’m trying to add a column to a fairly large innodb table (14.6m rows) and the ALTER TABLE query has been running for almost 24 hours. This is under MySQL 5.0.22
Is there a better/faster way to add the column that would only take an hour or two? It’s been running for so long I’m wary of trying a new method unless I know it will finish relatively quickly.
Along these lines, is there a way to measure the progress of the ALTER TABLE? I’ve been monitoring the size of the ibdata1 file, but that’s not a very good indicator, as other things are happening the database while the alter is running.