I'm trying to use a multi-threaded script/runner, which dies with too many (mysql) database connections. I reading up, and it appears that this is because each thread uses a new database connection. Moreover, the thread doesn't close out the connection when it's done. It appears that patch #2162, which would enable connection pooling, was stalled. Is this planned for 1.1? Is there another way around the issue? -- Kyle Maxwell Chief Technologist E Factor Media // FN Interactive kyle@efactormedia.com 1-866-263-3261 _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
Your guess is as good as mine. Tom Ward did some work based on my original patch to implement a pooled adaptor which I thought was on track to be integrated into the core, but i still don''t see it in subversion. We would like to be able to use Rails with webrick in multithreaded mode for small admin apps and the like. Can anyone comment on the status of integration the connection pooling patch? Greg On Jan 31, 2006, at 6:53 PM, Kyle Maxwell wrote:> I''m trying to use a multi-threaded script/runner, which dies with too > many (mysql) database connections. I reading up, and it appears that > this is because each thread uses a new database connection. Moreover, > the thread doesn''t close out the connection when it''s done. It > appears that patch #2162, which would enable connection pooling, was > stalled. Is this planned for 1.1? Is there another way around the > issue? > > -- > Kyle Maxwell > Chief Technologist > E Factor Media // FN Interactive > kyle@efactormedia.com > 1-866-263-3261 > _______________________________________________ > Rails-core mailing list > Rails-core@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails-core
I've been using the pooled adapter on some installations without any obvious problems, but not running against rails 1.0. I know that some changes were made in #428 that may affect the pool. I'll take a look at the code I wrote over the weekend, and see how it looks against 1.0 and trunk. I'll comment against #2162 with anything I find. Tom On 2/9/06, Greg Lappen <greg@lapcominc.com> wrote:> Your guess is as good as mine. Tom Ward did some work based on my > original patch to implement a pooled adaptor which I thought was on > track to be integrated into the core, but i still don't see it in > subversion. We would like to be able to use Rails with webrick in > multithreaded mode for small admin apps and the like. > > Can anyone comment on the status of integration the connection > pooling patch? > > Greg > > On Jan 31, 2006, at 6:53 PM, Kyle Maxwell wrote: > > > I'm trying to use a multi-threaded script/runner, which dies with too > > many (mysql) database connections. I reading up, and it appears that > > this is because each thread uses a new database connection. Moreover, > > the thread doesn't close out the connection when it's done. It > > appears that patch #2162, which would enable connection pooling, was > > stalled. Is this planned for 1.1? Is there another way around the > > issue? > > > > -- > > Kyle Maxwell > > Chief Technologist > > E Factor Media // FN Interactive > > kyle@efactormedia.com > > 1-866-263-3261 > > _______________________________________________ > > Rails-core mailing list > > Rails-core@lists.rubyonrails.org > > http://lists.rubyonrails.org/mailman/listinfo/rails-core > > _______________________________________________ > Rails-core mailing list > Rails-core@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails-core >_______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
Hi Tom, Thanks for the update. Have you heard anything about getting this code committed into subversion? On Feb 10, 2006, at 5:24 AM, Tom Ward wrote:> I''ve been using the pooled adapter on some installations without any > obvious problems, but not running against rails 1.0. I know that some > changes were made in #428 that may affect the pool. > > I''ll take a look at the code I wrote over the weekend, and see how it > looks against 1.0 and trunk. I''ll comment against #2162 with anything > I find. > > Tom > > On 2/9/06, Greg Lappen <greg@lapcominc.com> wrote: >> Your guess is as good as mine. Tom Ward did some work based on my >> original patch to implement a pooled adaptor which I thought was on >> track to be integrated into the core, but i still don''t see it in >> subversion. We would like to be able to use Rails with webrick in >> multithreaded mode for small admin apps and the like. >> >> Can anyone comment on the status of integration the connection >> pooling patch? >> >> Greg >> >> On Jan 31, 2006, at 6:53 PM, Kyle Maxwell wrote: >> >>> I''m trying to use a multi-threaded script/runner, which dies with >>> too >>> many (mysql) database connections. I reading up, and it appears >>> that >>> this is because each thread uses a new database connection. >>> Moreover, >>> the thread doesn''t close out the connection when it''s done. It >>> appears that patch #2162, which would enable connection pooling, was >>> stalled. Is this planned for 1.1? Is there another way around the >>> issue? >>> >>> -- >>> Kyle Maxwell >>> Chief Technologist >>> E Factor Media // FN Interactive >>> kyle@efactormedia.com >>> 1-866-263-3261 >>> _______________________________________________ >>> Rails-core mailing list >>> Rails-core@lists.rubyonrails.org >>> http://lists.rubyonrails.org/mailman/listinfo/rails-core >> >> _______________________________________________ >> Rails-core mailing list >> Rails-core@lists.rubyonrails.org >> http://lists.rubyonrails.org/mailman/listinfo/rails-core >> > _______________________________________________ > Rails-core mailing list > Rails-core@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails-core