How to end a TOI action?

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

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?

1 Like
2

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.

3

Gotta. Thanks Michael.

1 Like
4