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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:8.1.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: KILL QUERY, kill stuck queries

[21 Jul 2023 4:28] Naresh Bansal
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:
[21 Jul 2023 5:31] MySQL Verification Team
Hello Naresh Bansal,

Thank you for the feature request!