When using Apache::DBI you must remember that it caches the connections by using the connection string it you have two types of connection say one with autocommit on and the other with it off this is cached as two connections.
If you do not have a standard method/module for making your database connections then you have a chance that the two strings don't match. This is also true if you use two schemas these will appear as two cached connections. Without more information about your system it is hard to advise further. However I do note that you are using MaxClients 32 which would results in a max or 32 child processes (each with at least one Apache::DBI connection) per server which would max out at 192 processes if the system is under significant load. Also it is worth looking at whether you are using dedicated listener processes on using a dispatcher but your DBA should be able to tell you more about that. Some time ago I did do a patch that limited the number of connections a single instance of Apache::DBI could make but I am not sure this will help you here. Hope it helps Paddy On Mon, May 17, 2004 at 03:16:45PM -0400, [EMAIL PROTECTED] wrote: > > We are having a problem with the oracle sessions running wild. We > have five web servers that run 6 servers. once we restart all the web > servers, I check and see that we have 30 sessions. > > With the Apache::DBI::ping, we should stay steady at 30 sessions (At > least that is how I understand it), but after a couple of hours, the > processes start to grow exponetially, finally pushing some 400 > sessions, we restart. We have done nothing new in our setup for the > last year, and we can't seem to find a cause for this sudden explosion > of sessions. Of course the DBA is blaming Apache::DBI, but I can't > find any reason? > > These are our settings for the server. > > Timeout 300 > KeepAlive Off > MaxKeepAliveRequests 0 > KeepAliveTimeout 15 > MinSpareServers 4 > MaxSpareServers 8 > StartServers 6 > MaxClients 32 > MaxRequestsPerChild 65 > Listen 10.0.5.7:80 > > > -- > C Wayne Huling <[EMAIL PROTECTED]> > > -- > Report problems: http://perl.apache.org/bugs/ > Mail list info: http://perl.apache.org/maillist/modperl.html > List etiquette: http://perl.apache.org/maillist/email-etiquette.html > -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html
