I hava an action: alter table …, which is too slow and I want to cancel it.
Found the Id from show processlist, but I cannot kill it:
The query is in TOI/NBO and cannot be killed.
so ,how to cancel it forcely?
I hava an action: alter table …, which is too slow and I want to cancel it.
Found the Id from show processlist, but I cannot kill it:
The query is in TOI/NBO and cannot be killed.
so ,how to cancel it forcely?
There is no safe way to kill a TOI DDL. You may be able to terminate the execution by shutting down the PXC instance, but that may lead to data inconsistencies across the cluster and then force SST to all nodes.
Gotta. Thanks Michael.
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.