How to kill MySQL connections

by

No, there is no built-in MySQL command for that. There are various tools and scripts that support it, you can kill some connections manually or restart the server (but that will be slower).

Use SHOW PROCESSLIST to view all connections, and KILL the process ID’s you want to kill.

You could edit the timeout setting to have the MySQL daemon kill the inactive processes itself, or raise the connection count. You can even limit the amount of connections per username, so that if the process keeps misbehaving, the only affected process is the process itself and no other clients on your database get locked out.

If you can’t connect yourself anymore to the server, you should know that MySQL always reserves 1 extra connection for a user with the SUPER privilege. Unless your offending process is for some reason using a username with that privilege…

Then after you can access your database again, you should fix the process (website) that’s spawning that many connections.

More Related Contents:

  1. How to grant remote access permissions to mysql server for user?
  2. MySQL show status – active or total connections?
  3. mySQL Error 1040: Too Many Connection
  4. MySQL giving “read ECONNRESET” error after idle time on node.js server
  5. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  6. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  7. Count the occurrences of DISTINCT values
  8. Codeigniter – multiple database connections
  9. Column count doesn’t match value count at row 1
  10. How to add levenshtein function in mysql?
  11. How to search JSON data in MySQL?
  12. MySQL > Table doesn’t exist. But it does (or it should)
  13. How do I modify a MySQL column to allow NULL?
  14. Connect to mysql in a docker container from the host
  15. Is there ANY_VALUE capability for mysql 5.6?
  16. Set NOW() as Default Value for datetime datatype?
  17. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  18. SQL DELETE with JOIN another table for WHERE condition
  19. How to connect to a MySQL Data Source in Visual Studio
  20. DOs and DONTs for Indexes [closed]
  21. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  22. How can I implement single table inheritance using Laravel’s Eloquent?
  23. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  24. MySQL – ORDER BY values within IN()
  25. How can I set autoincrement format to 0001 in MySQL?
  26. Why MYSQL IN keyword not considering NULL values
  27. Returning records from the last 3 months only in MySQL
  28. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  29. delete rows from multiple tables
  30. MySQL Multiple Joins in one query?

Leave a Comment