Eric Bergen said: > 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 Actually the connection is on per worker process. Tomcat response to apache's children's requests, so it would be, at worst, one connnection per tomcat worker, which should be a smaller number than apache children/threads. There are methods for tomcat workers to also share a connection pool, but I've never used them. For my needs dropping and creating connections has been better (shared servers).
I'd look at the tomcat connection pooling information on the apache site as a place to start rather than the web-sever. Hopefully you have configured tomcat to just handle the .jsp page not ALL PAGES. > On Mon, 7 Mar 2005 17:04:47 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > wrote: >> "Scott Purcell" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> > Sent: Monday, March 07, 2005 3:48 PM >> > To: Scott Purcell >> > Cc: mysql@lists.mysql.com >> > Subject: Re: database pooling problem >> >> > >> > >> > "Scott Purcell" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > http://www.ebergen.net > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
