Ending a session or query for RDS for MySQL (original) (raw)

You can end user sessions or queries on DB instances by using therds_kill and rds_kill_query commands. First connect to your MySQL DB instance, then issue the appropriate command as shown following. For more information, see Connecting to your MySQL DB instance.

CALL mysql.rds_kill(thread-ID)
CALL mysql.rds_kill_query(thread-ID) 

For example, to end the session that is running on thread 99, you would type the following:

CALL mysql.rds_kill(99); 

To end the query that is running on thread 99, you would type the following:

CALL mysql.rds_kill_query(99); 

Dynamic privileges

Skipping the current replication error

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.