Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Killing OPTIMIZE TABLE operation on MyISAM without corrupting data???

vpestovnikovvpestovnikov ContributorInactive User Role Beginner
Hi all,
Is there any chance to stop OPTIMIZE TABLE operation without data corrupting?

I found this situation if I kill thread ID of an optimizing operation from the processlist, the data became a corrupted.

And the documentation says the same:

Killing a REPAIR TABLE or OPTIMIZE TABLE operation on a MyISAM table results in a table that is corrupted and unusable. Any reads or writes to such a table fail until you optimize or repair it again (without interruption)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.