require 'rubygems'
require 'mysql'
require 'thread'
require 'benchmark'

DB_CONFIG = {
  :username => 'root',
  :password => '',
  :host => '127.0.0.1',
  :db => 'SOME_DB_NAME'
}

ITERATIONS=6
SQL_STMT = "select sleep(1) from dual;"

def execute_query
  conn = Mysql.new(DB_CONFIG[:host], DB_CONFIG[:username], DB_CONFIG[:password], DB_CONFIG[:db], 3306, nil, nil)
  res = conn.query(SQL_STMT)
  res.free
  conn.close
end

puts "Iterations:#{ITERATIONS}  SQL: #{SQL_STMT}"
puts "Serial: " + Benchmark.measure {  ITERATIONS.times {execute_query}}.real.to_s
threads = []
ITERATIONS.times { threads << Thread.new { execute_query} }
puts "Multi-threaded: " + Benchmark.measure { threads.collect{|t| t.join}}.real.to_s

# Output
# ---------------------
# Iterations:6  SQL: select sleep(1) from dual;
# Serial: 6.01356410980225
# Multi-threaded: 0.000133991241455078