On Jul 9, 2007, at 9:12 AM, Anthony Gardner wrote:
http://perl.apache.org/docs/2.0/user/performance/
mpm.html#Work_with_DataBases_under_Threaded_MPM
I'm looking into a problem we're experiencing (lots of netword
connections) and I think the answer lies with Apache::DBI and the
version of mod_perl we're using.
A few questions, does anyone know of the state of DBI::Pool?
If anyone is using threaded MPM and Apache::DBI, how are they
dealing with sharing the the connection within the threads?
I'm looking at Thread::Sociable (preference) and threads::shared and
I'm looking for tips and/or defacto stds used at the time of writing.
Any tips would be great while I continue playing with threads and
searching for other info.
Some people here ( not including me though ) are using connect_cached
in DBI , and bypassing Apache::DBI altogether. you might want to try
that.
correct me if i'm wrong.. but i believe you want to not share dbi
connections between threads. wouldn't you need a factory class to
toss you a fresh connect ?
if you want to do true connection pooling, you'd be best off with
something like sqlrelay or pgpool. the apache::dbi/dbi cached don't
really pool; they just override connects for established connections
on their process and reuse them. things like sqlrelay/pgpool will
let you use 50 db connections for 150 server processes ( by blocking
a lot, yes )
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| CEO/Founder SyndiClick Networks
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| Founder/CTO/CVO
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -