Bug #111834 Feature request: kill all queries for user using "kill user" command

• Submitted: 21 Jul 2023 4:28
• Modified: 21 Jul 2023 5:31
• Reporter: Naresh Bansal
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S4 (Feature request)
• Version: 8.1.0
• OS: Any
• CPU Architecture: Any
• Tags: KILL QUERY, kill stuck queries

[21 Jul 2023 4:28] Naresh Bansal

Description:
It would be really great to kill all queries for a perticular user, most of the time slow queries got stuck and freezes the whole server.

Increasing the resources is not always a good practice but fixing the slow query takes some time and until then the stuck queries needed to be killed using either external bash script or php script.

There should be an easy enough command to kill all qeuries for the user just like linux (killall -u $user) or mariadb (kill user USERNAME)

How to repeat:
NA

[21 Jul 2023 5:31] MySQL Verification Team

Hello Naresh Bansal,

Thank you for the feature request!

regards,
Umesh