We have a table that contains 19 million records, 11 indexes + primary key, 16 columns
I’m trying to optimize it but I’m getting an error
OPTIMIZE NO_WRITE_TO_BINLOG TABLE mytable;
OPTIMIZE TABLE mytable;
it runs for 15-20 minutes then and I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
when I check the optimization result, I see nothing has changed
they way I check the optimization result is by checking the cardinality of all indexes before and after and I expect them to change after the optimization is done.
any ideas why I get that error? how can I optimize the table without getting that error msg?
any help would be appreciated