Skip to content

Instantly share code, notes, and snippets.

@psahni

psahni/mysql_connection_cleaner.rb

Forked from jagira/mysql_connection_cleaner.rb
Created June 15, 2011 13:02
Show Gist options
  • Save psahni/1027031 to your computer and use it in GitHub Desktop.
Save psahni/1027031 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Connection Cleaner
Raw
mysql_connection_cleaner.rb
require 'mysql2'
client = Mysql::Client.new(:host => "localhost", :username => "root")
# Fetch running threads
processes = client.query("SHOW FULL PROCESSLIST")
processes.each do |process|
# Kill thread
client.query("KILL #{process[0].to_i}")
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment