I have a huge table (2.8 GB) and I need to add a column. After I run this query I experience a lost connection error (Error code: 2013. Lost connection to MySQL server during query):
ALTER TABLE `huge_one` ADD COLUMN `extra_column` INT(10) UNSIGNED NOT NULL AFTER `existing_column`;
It seems the problem is related to memory shortage though I have these settings in the config file:
Is that problem really related to innodb_log_file_size setting and is it possible to handle it without increasing innodb_log_file_size?