Bug #106755 add feature:kill thread all

• Submitted: 17 Mar 2022 7:35
• Modified: 17 Mar 2022 8:26
• Reporter: alex xing (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: 8.0.19
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[17 Mar 2022 7:35] alex xing

Description:
add feature: KILL SAFE/(THREADS ALL) support

1. KILL THREAD SAFE:
When a thread to kill is executing a query or in transaction,
KILL SAFE does not kill it and reports an error.

2. KILL THREADS ALL (FORCE):
User with SUPER privilege can kill all threads except itself and daemons.
When a thread to kill is executing a query or in transaction, it will kill itself
once it finishes its job.
When FORCE is specified, threads get killed with no condition.

How to repeat:
just read the patch

Suggested fix:
a patch based on 8.0.19 to describe the  feature

[17 Mar 2022 7:36] alex xing

a simple patch based on  8.0.19.  The same may be true for the latest version of the code.

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: kill_thread_all.patch (text/plain), 19.10 KiB.

[17 Mar 2022 8:26] MySQL Verification Team

Hello Alex Xing,

Thank you for the feature request and contribution.

regards,
Umesh