[Mongrel] Recommendation: Install The Real MySQL Driver

Zed Shaw zedshaw at zedshaw.com
Tue Aug 22 20:09:52 EDT 2006


Hi Folks,

I've been receiving lots of reports of the following problems:

1) Huge pauses.
2) Slow response on heavy queries.
3) Lost MySQL connections.
4) General database failures.

What I've been able to confirm is that this is almost always caused by
people using the default mysql.rb that comes with rails in their
production setups.

******
Please, if you run your Rails application in production then install the
compiled mysql gem for your platform:

  gem install mysql

And make sure you always have the latest.

A lot of these problems turn out because of differences in the protocol
of more recent mysql and the mysql.rb implementation in Rails.  Mongrel
is just making them worse because it's able to stress the driver more
(at least I think so).

Thanks a bunch.  And please stop by the Lingr room if you have potential
bug reports (link in my signature).


-- 
Zed A. Shaw
http://www.zedshaw.com/
http://mongrel.rubyforge.org/
http://www.lingr.com/room/3yXhqKbfPy8 -- Come get help.



More information about the Mongrel-users mailing list