Rails - Feb 2010 - How to use connection pool in Rails2.3.5 with WEBrick and MySQL?

We use Rails 2.3.5, MySQL, and WEBrick.

ActiveRecord call ConnectionPool#checkout and create new connection to
MySQL when receive a first HTTP request.
At this time, register to connection pool its connection in
ConnectionPool#checkout_new_connection.
#
http://github.com/rails/rails/blob/v2.3.5/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb#L181
#
http://github.com/rails/rails/blob/v2.3.5/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb#L246

but, Rack::Handler::WEBrick#service call body.close in ensure section
when return the HTTP response.
It call another method. after some call, it call
ConnectionPool#clear_reloadable_connections and clear its connection
pool.
#
http://github.com/rails/rails/blob/v2.3.5/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb#L145

As a result, the connection was created by every request and spend
time for connection.

How to use connection pool?

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.