# MySQL gem vs RoR default library

**URL:** <https://www.ruby-forum.com/t/mysql-gem-vs-ror-default-library/142041>\
**Category:** Rails\
**Created:** [July 2, 2008, 9:05pm UTC](https://www.ruby-forum.com/t/mysql-gem-vs-ror-default-library/142041 "2008-07-02T21:05:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gsb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/cc9497/32.png) [@gsb](https://www.ruby-forum.com/u/gsb)\
**Post date:** [July 2, 2008, 9:05pm UTC](https://www.ruby-forum.com/t/mysql-gem-vs-ror-default-library/142041/1 "2008-07-02T21:05:09Z")

</div>

I have Rails v 2.0.2  
Ruby v 1.8.6  
MySQL db v 5.x

I am confused as to whether we should use the MySQL gem or the RoR  
default MySQL support library.  
The consultants that had worked on the initial phase of the project  
had me remove the gem saying that  
it is better to use the RoR library, that the gem was necessary in  
earlier version of Rails.  
BUT, I get the WARNING below which says the opposite.

Can somebody assert that given the versions of Rails and Ruby I should  
be using the MySQL gem or NOT?

* * *

## 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). SQL (0.003382)

Thanks,

gsb

---

<div class="post-metadata">

**Author:** ![gsb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/cc9497/32.png) [@gsb](https://www.ruby-forum.com/u/gsb)\
**Post date:** [July 2, 2008, 9:06pm UTC](https://www.ruby-forum.com/t/mysql-gem-vs-ror-default-library/142041/2 "2008-07-02T21:06:19Z")

</div>

> BUT, I get the WARNING below which says the opposite.
> 
> Can somebody assert that given the versions of Rails and Ruby I should  
> be using the MySQL gem or NOT?
> 
> * * *
> 
> ## 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). SQL (0.003382)

In my experience the gem is quite a bit faster…

-philip
