pt-kill should support "CALL mysql.rds_kill"
When using pt-kill against an RDS database you cannot kill queries that do not belong to you as the master user.
While you can kill procs with the same user of the running query, to kill procs running as other users a stored procedure must be called.
AWS state:
To allow management of the DB instance, the standard kill and kill_query commands have been restricted.
The Amazon RDS commands rds_kill and rds_kill_query are provided to allow you to terminate user sessions or queries on DB instances.
eg: CALL mysql.rds_
I would like an --rds option to pt-kill which simply wraps the prepare statements with the stored procedure.
eg: 'CALL mysql.rds_kill(?)'
We monkey patch pt-kill to do this ourselves - so it does work - we would like it to be officially supported in a future release.
feel like this is a bug - but its not pt-kill's fault - so therefore it's a feature request ;-)
Blueprint information
- Status:
- Complete
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- elliot
- Direction:
- Approved
- Assignee:
- None
- Definition:
- Approved
- Series goal:
- Accepted for 2.2
- Implementation:
- Implemented
- Milestone target:
- None
- Started by
- Frank Cizmich
- Completed by
- Frank Cizmich
Related branches
Related bugs
Sprints
Whiteboard
implemented and merged on github using this external pull request: