# How to end a TOI action?

**URL:** <https://forums.percona.com/t/how-to-end-a-toi-action/20179>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 20, 2023, 7:36am UTC](https://forums.percona.com/t/how-to-end-a-toi-action/20179 "2023-02-20T07:36:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![azuryy](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@azuryy](https://forums.percona.com/u/azuryy)\
**Post date:** [February 20, 2023, 7:36am UTC](https://forums.percona.com/t/how-to-end-a-toi-action/20179/1 "2023-02-20T07:36:04Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [February 21, 2023, 3:10pm UTC](https://forums.percona.com/t/how-to-end-a-toi-action/20179/2 "2023-02-21T15:10:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![azuryy](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@azuryy](https://forums.percona.com/u/azuryy)\
**Post date:** [February 23, 2023, 12:52am UTC](https://forums.percona.com/t/how-to-end-a-toi-action/20179/3 "2023-02-23T00:52:48Z")

</div>

Gotta. Thanks Michael.

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [February 27, 2023, 3:17pm UTC](https://forums.percona.com/t/how-to-end-a-toi-action/20179/4 "2023-02-27T15:17:53Z")

</div>

Closed on February 27, 2023, 3:17pm UTC


