Ruby optimize all tables in all DB's in mysql

optimize_schema.rb

require 'mysql'

con = Mysql.new('localhost','root', '')
rs = con.query('show databases')
databases = []
rs.each_hash do |h| 
  databases << h['Database']
end

databases.each do |db|
  unless db == 'mysql' or db == 'performance_schema' or db == 'information_schema'
    puts "on database: " + db.to_s
    con = Mysql.new('localhost','root', '', db)
    rs = con.query('show tables')
    rs.each_hash do |t|
      puts "on table: " + t['Tables_in_' + db.to_s]
      rs = con.query('optimize table ' + t['Tables_in_' + db.to_s].to_s)
    end
    con.close
  end
end