jagira · June 15, 2011 08:03
diff --git a/mysql_connection_cleaner.rb b/mysql_connection_cleaner.rb
 require 'mysql2'

 # Change the host and password
 client = Mysql::Client.new(:host => "localhost", :username => "root")

 # Fetch running processes
 processes = client.query("SHOW FULL PROCESSLIST")

 processes.each do |process|
  
  # Kill process
  client.query("KILL #{process[0].to_i}")

 end
	require 'mysql2'

	# Change the host and password
	client = Mysql::Client.new(:host => "localhost", :username => "root")

	# Fetch running processes
	processes = client.query("SHOW FULL PROCESSLIST")

	processes.each do \|process\|

	# Kill process
	client.query("KILL #{process[0].to_i}")

	end