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?
Best Answer
Change specific timeouts value to 6000 it's available in all new versions of MySQL Workbench.
Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome.