mysql gem warning on ubuntu

i just deployed my app on ubuntu with passenger.
i installed the mysql gem as follows:

$ sudo gem install mysql
Select which gem to install for your platform (i486-linux)
1. mysql 2.7.3 (mswin32)
2. mysql 2.7.1 (mswin32)
3. mysql 2.7 (ruby)
4. mysql 2.6 (ruby)
5. Skip this gem
6. Cancel installation

3

Building native extensions. This could take a while...
Successfully installed mysql-2.7

ok. restarted my app and in my log file was

"WARNING: You're using the Ruby-based MySQL library that
ships with Rails. This library is not suited for production.
Please install the C-based MySQL library instead (gem install mysql)."

i tried installation switchers like "-with-mysql-config" and
"-with-mysql-dir" but none solved the problem. i checked for missing
packages (rub1.8-dev, build-essential, libmysqlclient15-dev, etc) and
they are there.
any ideas? thanks.

my database.yml configuration:

production:
  adapter: mysql
  encoding: utf8
  database: myapp_production
  username: root
  password:
  host: localhost
  socket: /var/run/mysqld/mysqld.sock

Did you try follow the instructions it gave you? Try to do gem install
mysql.

hello Ryan, thanks for your reply. as i stated
above:

"i installed the mysql gem as follows:

$ sudo gem install mysql"

i got the warning after the installation.

Ryan Bigg wrote:

dont worry about that. Try to copy and paste libmySQL.dll from your
mysql/bin to your ruby/bin. Sorry, if my solution will not answer your
problem.

Reinhart
http://teapoci.blogspot.com

what happens if you open an irb prompt and type
require 'rubygems'
require 'mysql'

Fred

Rails Terrorist, i'm on ubuntu. are you sure?

Fred, i followed your advice, and the result was:

$ irb
irb(main):001:0> require "rubygems"
=> true
irb(main):001:0> require "mysql"
LoadError: no such file to load -- mysql
  from (irb):1:in `require'
  from (irb):1
irb(main):002:0>

i did some research on this error message and
found a tip about a package called libdbd-mysql-ruby.
i installed it using

sudo apt-get install libdbd-mysql-ruby

and:

irb(main):001:0> require "mysql"
=> true

the warning message vanished too, so i'd say mission
accomplished on this one. many thanks for your help.