Emmanouil Batsis (Manos) wrote:
Sarah Northway wrote:
We use Roller for a dozen small blogs, and are having an issue with it
opening up nearly 500 MySQL connections and choking up our database
server. Is this expected behavior?
Is there a standard way to configure Roller to limit its db sessions
to a more reasonable number?
From what I remember you should be able to easily configure the max
connections etc. in roller-custom.properties. Check the installation
manual ;-)
If it's in the installation guide I haven't been able to find it, which
is why I'm asking here. :)
You may be thinking of the "MaxActive" attribute which can appear in
context.xml when connecting to a database through Tomcat, but we aren't
doing that. The section on db configuration in roller.properties
doesn't mention connections (we are using jdbc):
#---------------------------------
# Database configuration settings
# Specify database configuration type of 'jndi' or 'jdbc'
database.configurationType=jndi
# For database configuration type 'jndi',this will be used
database.jndi.name=jdbc/rollerdb
# For database configuration type of 'jdbc', you MUST override these
database.jdbc.driverClass=
database.jdbc.connectionURL=
database.jdbc.username=
database.jdbc.password=
Can anyone point me at the configuration property I'm looking for?
- Sarah
