List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:March 7 2005 11:14pm
Subject:Re: database pooling problem
View as plain text  
Apache 1.3 with php (not sure about tomcat) is a pre forked daemon.
Any connection pooling numbers will be per child. Try setting your
connection numbers per child (for most php apps this is 1) and let us
know what happens. I'm guessing it will create as many connections as
there are apache children. For more info see the fork() man page.

-Eric

On Mon, 7 Mar 2005 17:04:47 -0500, SGreen@stripped <SGreen@stripped> wrote:
> "Scott Purcell" <spurcell@stripped> wrote on 03/07/2005 04:59:27 PM:
> 
> > Thanks Sean,
> >
> > I am using standalone Apache/Tomcat 4.1.31
> >
> > mysql> \s
> > --------------
> > mysql  Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32)
> >
> > Connection id:          184
> > SSL:                    Not in use
> > Server version:         4.0.15-max-debug
> > Protocol version:       10
> > Connection:             localhost via TCP/IP
> > Client characterset:    latin1
> > Server characterset:    latin1
> > TCP port:               3306
> > --------------
> >
> > mysql>
> >
> > I am using Java to code with and I am using a driver called:
> > org.gjt.mm.mysql.Driver
> >
> >
> > My connection class is too large to submit to the list, or I would
> submit it.
> >
> > I guess what I would like to be able to do is create some type of
> > object that I could use to do pooling that is maybe inside the
> container?
> >
> > I hope this helps,
> > Scott
> 
> It would be happy to try to help if I worked in or on either of those
> platforms (Apache + Java).  I am Win32(IIS), ASP (VBScript/JavaScript)
> using MyODBC as my connection library. Sorry but I can't help in any way
> shape or form. I have CC-ed the description of your operating and
> development environments to the list to see if anyone offers to help.
> 
> Maybe next time!
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
> >
> >
> > -----Original Message-----
> > From: SGreen@stripped [mailto:SGreen@stripped]
> > Sent: Monday, March 07, 2005 3:48 PM
> > To: Scott Purcell
> > Cc: mysql@stripped
> > Subject: Re: database pooling problem
> 
> >
> >
> > "Scott Purcell" <spurcell@stripped> wrote on 03/07/2005 04:29:18
> PM:
> >
> > > Hello,
> > >
> > > I am working with a traditional database pooling class basically
> > > putting connection objects into a Vector.  When I run the code from
> > > a main, it appears solid. I have run 10s of thousands of back to
> > > back queries and all is good.
> > >
> > > Problem is when I connect it to a web-app, and reboot the webserver
> > > a couple of times, I get a message from the driver stating "Too many
> > > connection" and I am done.
> > >
> > > Upon thinking about this, I figured my traditional Vector of
> > > connections, is getting created over and over, each time someone
> > > "bumps" the web server with a new class, etc. So I start out with 10
> > > connections, then another 10 and another 10 and eventually I guess
> > > the driver has no more connections to give?
> > >
> > > Anyway, this list is possibly the wrong, list, but I would hope
> > > there are some developers here that may lend a hand or link. So I am
> > > not happy with what I have created nor the way it works on the web
> server.
> > >
> > > Does anyone have any ideas how I should handle this? in a web-based
> > > environment.
> > >
> > > Thanks,
> > > Scott
> > >
> > >
> >
> > No matter which list you submit to, you need to provide more
> > details. Technically what you are asking is a little off-topic (more
> > about making a pool work with a web server than just making the
> > connection, right?) But if you bring the question to the list,
> > someone _may_ be able to pitch in and help.
> >
> > Now exactly WHO can help (and to what degree they can help)
> > completely depends on WHICH web server you use (there are dozens,
> > you know...), HOW you initialize your pool (again many methods
> > available), HOW you take and return connections from your pool
> > (ditto), and which languages are in use in this entire process
> > (again dozens of options). Just telling us that you use a web-server
> > did not provide nearly enough information as there are literally
> > thousands of combinations of ways to do what you described.
> >
> > Please tell whichever list you submit to:
> >         What OS you are using
> >         Which web server you are using
> >         What languages you are using
> >
> > And you will need to supply some code examples, too. The list
> > members will need to be able to see your code so that they can see
> > what is "wrong" with it.
> >
> > Best of luck,
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
Thread
database pooling problemScott Purcell7 Mar
  • Re: database pooling problemSGreen7 Mar
RE: database pooling problemSGreen7 Mar
  • Re: database pooling problemEric Bergen8 Mar
    • Re: database pooling problemWilliam R. Mussatto8 Mar
  • IIS, ASP, MySQL (was: database pooling problem)Robert Citek6 Apr
    • Re: IIS, ASP, MySQL (was: database pooling problem)SGreen6 Apr
    • Re: IIS, ASP, MySQL (was: database pooling problem)Florin Andrei6 Apr