I have a table of around 7mil records (data length: 1GB, Index Length 1GB, 12 Indexes, InnoDB). I am needing to add a mediumint and a tinyint to the end of the table. Up until now, adding a row has been no problem, but for some reason this is taken much longer than other times we have altered this table. It has taken up to 30min ‘copy to tmp table’ and we still killed it because it was causing some problems with access to the table.
I am looking for suggestions/help on how to improve the speed of adding these fields to this table. I am using a slightly modified version of mysql_huge conf that works well.