I'm trying to execute an
ALTER TABLE statement in MySQL 5.6. Every time I run the query, it's creating a file with a name like
#sql2-503-918bf.ibd taking full table size. I don't have enough disk space to run the query, because whenever I try to run it, another
#sql… file will be created.
ALTER TABLE kt_ticket_message ADD COLUMN from_email varchar(255) NOT NULL COMMENT 'From email';
ERROR 2013 (HY000): Lost connection to MySQL server during query
Table size is 5 GB, database size is 6 GB.
These are parameters in the config file:
wait_timeout=30 interactive_timeout=60 max_allowed_packet=1M
Can I increase the timeout parameters?