MySQL Connection Cleaner

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