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.
Query:
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?
ALGORITHM=INSTANT
if your table do not matches any limitation of Online DDL Operations.ERROR 2013 (HY000): Lost connection to MySQL server during query
isn't usually an indication of a timeout. It's usually an indication of something more serious, like a crash, which forcibly closes client connections without a response. Review the MySQL Server's error log.show full processlist