populate_db.rb

require 'rubygems'
require 'mysql'

db = Mysql.new("localhost", "root", "", "test")

words = %w{patrick johan peter niklas}

500_000.times do
  db.query("INSERT INTO innodb SET varcharen='#{words[rand(words.size)]}', inten=#{rand(words.size)}, enumen='#{words[rand(words.size)]}'")
  db.query("INSERT INTO innodb_index SET varcharen='#{words[rand(words.size)]}', inten=#{rand(words.size)}, enumen='#{words[rand(words.size)]}'")
  db.query("INSERT INTO myisam SET varcharen='#{words[rand(words.size)]}', inten=#{rand(words.size)}, enumen='#{words[rand(words.size)]}'")
  db.query("INSERT INTO myisam_index SET varcharen='#{words[rand(words.size)]}', inten=#{rand(words.size)}, enumen='#{words[rand(words.size)]}'")
end