roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave <snoopd...@gmail.com>
Subject Re: Too many MySQL connections
Date Thu, 04 Jun 2009 21:53:04 GMT
You can set database connection pool parameters via your app-server.
Check the install guide:

    9.3 Using Server-provided database and mail resources

There's a Tomcat example in 9.3; If you are not running on Tomcat
you'll have to consult your app server docs.

- Dave


On Thu, Jun 4, 2009 at 1:35 PM, Sarah Northway <sarah@threerings.net> wrote:
> 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
>

Mime
View raw message