Don't do this: the optimization process temporarily needs the same amount of space or even more than the whole table already sizes, and with bad luck the table gets locked forever. Basically people have no idea about the risk: https://dev.mysql.com/doc/refman/8.0/en ... html#c9940
Thank you for the link, an interesting read and something new learned.AmigoJack wrote: ↑Wed Jun 20, 2018 7:20 am Don't do this: the optimization process temporarily needs the same amount of space or even more than the whole table already sizes, and with bad luck the table gets locked forever. Basically people have no idea about the risk: https://dev.mysql.com/doc/refman/8.0/en ... html#c9940
Yes, thanks for that. I better inform my host. When I report I've no room and can't get into my software because of it he optimises my tables.AmigoJack wrote: ↑Wed Jun 20, 2018 7:20 amDon't do this: the optimization process temporarily needs the same amount of space or even more than the whole table already sizes, and with bad luck the table gets locked forever. Basically people have no idea about the risk: https://dev.mysql.com/doc/refman/8.0/en ... html#c9940