logo
Apache Lounge
Webmasters

 

About Forum Index Downloads Search Register Log in  RSS Apache Lounge  


Keep Server Online

If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.

or

Bitcoin

A donation makes a contribution towards the costs, the time and effort that's going in this site and building.

Thank You! Steffen

Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.



Post new topic   Forum Index -> Apache View previous topic :: View next topic
Reply to topic   Topic: Apache 2.4.5/prefork mod_dbd -> to many db connections
Author
marlan



Joined: 24 May 2020
Posts: 1

PostPosted: Sun 24 May '20 10:33    Post subject: Apache 2.4.5/prefork mod_dbd -> to many db connections Reply with quote

Hi,
I have a problem with mod_dbd.
For a rewritemap I have configured a database connection:
Code:

DBDriver  pgsql
DBDParams "hostaddr=127.0.0.1 port=5432 dbname=dbname user=dbuser password=dbpassword"
DBDMin      1
DBDKeep     2
DBDMax     10
DBDExptime 60
#https://httpd.apache.org/docs/2.4/mod/mod_dbd.html


If I understand the dbd documentation correctly, with the mpm prefork module, the apache is not threaded and mod_db is using a single persistent connection per process (and not a database pool and the param like DBDMin etc. have no effect). If I activate the configuration, the server quickly reached the limit of db connections. In the pgadmin dashboard I can see at least 100 apache-postgres Connections in the state idle. Can someone tell me how i can calculate the maximal connections the apache will open? What does per process mean? Is that the MaxClients value?
Thanks mark
Back to top


Reply to topic   Topic: Apache 2.4.5/prefork mod_dbd -> to many db connections View previous topic :: View next topic
Post new topic   Forum Index -> Apache