Re: I'm getting max connection errors for Apache::DBI

[Mark Galbreath]

That's alright...it's Friday and no one was sending any jokes, anyway.  And I was getting a chuckle out of your name.   mark >>> Boysenberry Payne <[EMAIL PROTECTED]> 10-Feb-06 13:30:46 PM >>> Sorry about the extra posts I was having email difficulties that day... Everything is working fine now though.  The AutoCommit = 0 fixed it all... Thanks again for all of the help, Boysenberry boysenberrys.com | habitatlife.com | selfgnosis.com On Feb 8, 2006, at 11:55 AM, Boysenberry Payne wrote: > I took out the flags and the disconnect.  I also set: > $Apache::DBI::DEBUG = 2; > to get debugging output. > > I'm not getting any connection errors. (going to set mysql's max > connections to 150 per server) > > What I'm seeing is 37 mysql threads being created for 7 apache > children.  It would seem as > though I would need to create a 5/1 ratio of mysql connections to > apache children.  Is that normal? > > Thanks, > Boysenberry > > boysenberrys.com | habitatlife.com | selfgnosis.com > > On Feb 8, 2006, at 9:59 AM, Perrin Harkins wrote: > >> Boysenberry Payne wrote: >>> What do I need to do to fix it? >> >> You probably just need to raise the maximum number of connections on >> your MySQL servers. >> >> If you use two different database servers then you should be seeing a >> total number of connections on each one that matches the number of >> child processes running on your mod_perl server. >> >>> $self->{flags} = { 'AutoCommit' => 1, 'RaiseError' => 1 } unless >>> $self->{flags}; >> >> Connecting with different options sometimes will lead to opening more >> connections rather than using an existing one.  You may want to >> always connect with the same flags and then change them on the >> returned connection instead.  You can use the Apache::DBI debugging >> switch to see if connections are being reused or not. >> >>> if( $self->{db} ) { >>>     my $h = $self->{db}->{dbh}; >>>     $h->disconnect if $h; >> >> That is pointless, since Apache::DBI doesn't allow disconnects. >> >> - Perrin >> >> > > >