number of pgsql childrens on persistant DBI connection
Hi all, on my DB server I have 245 "idle" postmasters process for 130 httpd persistant DB connections alive. can anyone give me a clue how to manage this number of unused/idleschildren and how to have them quickerly deallocated ? this way, I jumptoo quick on 'too much connection'... Emmanuel -- EDENJOB / APR-Job Email: [EMAIL PROTECTED]Home:www.apr-job.com Phone: +33 1 47 81 02 41 Tatoo: +33 6 57 60 42 17 Fax: +33 1 41 92 91 54 eFAX: +44 0870-122-6748 ** This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither EDENJOB/APR-JOB or affiliates shall be liable for the message if altered, changed or falsified. **
Re: number of pgsql childrens on persistant DBI connection
On Tue, 20 Feb 2001, Emmanuel Pierre wrote: Hi all, on my DB server I have 245 "idle" postmasters process for 130 httpd persistant DB connections alive. can anyone give me a clue how to manage this number of unused/idleschildren and how to have them quickerly deallocated ? this way, I jumptoo quick on 'too much connection'... Any chance that you misuse Apache::DBI? http://perl.apache.org/guide/databases.html#When_should_this_module_be_used_ Emmanuel -- EDENJOB / APR-Job Email: [EMAIL PROTECTED]Home:www.apr-job.com Phone: +33 1 47 81 02 41 Tatoo: +33 6 57 60 42 17 Fax: +33 1 41 92 91 54 eFAX: +44 0870-122-6748 ** This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither EDENJOB/APR-JOB or affiliates shall be liable for the message if altered, changed or falsified. ** _ Stas Bekman JAm_pH -- Just Another mod_perl Hacker http://stason.org/ mod_perl Guide http://perl.apache.org/guide mailto:[EMAIL PROTECTED] http://apachetoday.com http://logilune.com/ http://singlesheaven.com http://perl.apache.org http://perlmonth.com/
Re: number of pgsql childrens on persistant DBI connection
Wow! Are you sure no one else is going against your database using persistent connections? How many database handles are you using in your mod_perl apps? Each Apache child process will require one persistent connection to your database for each different database handle. If you have a database server that contains multiple databases, and you're accessing 2 different databases on the same server with your mod_perl/DBI/Apache-DBI apps, you're going to have double the number of persistent connections to your databases then you're going to have child processes. Additionally, if you use one database handle for normal interaction, and another database handle for transactions [to prevent committing a transaction across tables until all have been updated] you're going to end up with 1 persistent connection to your postgresql database for each DBI database handle, even though they are accessing the same database. I think... :) Emmanuel Pierre wrote: Hi all, on my DB server I have 245 "idle" postmasters process for 130 httpd persistant DB connections alive. can anyone give me a clue how to manage this number of unused/idleschildren and how to have them quickerly deallocated ? this way, I jumptoo quick on 'too much connection'... Emmanuel -- EDENJOB / APR-Job Email: [EMAIL PROTECTED]Home:www.apr-job.com Phone: +33 1 47 81 02 41 Tatoo: +33 6 57 60 42 17 Fax: +33 1 41 92 91 54 eFAX: +44 0870-122-6748 ** This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither EDENJOB/APR-JOB or affiliates shall be liable for the message if altered, changed or falsified. ** -- ***NOTE*** This entire message is confidential, and protected by copyright. If you are not the intended recipient, you are hereby notified that any review, dissemination or archiving of this message is strictly prohibited. ** www.RentZone.org
Re: number of pgsql childrens on persistant DBI connection
Emmanuel Pierre wrote: Hi all, on my DB server I have 245 "idle" postmasters process for 130 httpd persistant DB connections alive. make sure you use the same connect attributes each time you invokes DBI-connect(). eg, a connect() with {RaiseError=1} and another connect with {RaiseError=1,Taint=1} gives two different persistent $dbh. To make this simpler, you'd better create a global $dbh by connect_on_init(),and use it anytime you need a $dbh. rgds, Edwin. can anyone give me a clue how to manage this number of unused/idleschildren and how to have them quickerly deallocated ? this way, I jumptoo quick on 'too much connection'... Emmanuel -- EDENJOB / APR-Job Email: [EMAIL PROTECTED]Home:www.apr-job.com Phone: +33 1 47 81 02 41 Tatoo: +33 6 57 60 42 17 Fax: +33 1 41 92 91 54 eFAX: +44 0870-122-6748 ** This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither EDENJOB/APR-JOB or affiliates shall be liable for the message if altered, changed or falsified. **