Too many MySQL connections

[Sarah Northway]

Hello,

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?

We are using Roller 4.0, MySQL 14.12, Java 1.6.  Roller config is fairly
standard except for using LDAP authentication and some custom modules
that don't involve the db.

- Sarah

[Emmanouil Batsis (Manos)]

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 ;-)


--
Manos Batsis, Chief Technologist
          __    _
   ____ _/ /_  (_)_________ ____ ______
  / __ `/ __ \/ / ___/ ___// __ `/ ___/
/ /_/ / /_/ / (__  |__  )/ /_/ / /
\__,_/_.___/_/____/____(_)__, /_/
                         /____/
http://www.Abiss.gr
19, Andrea Kalvou Street,
14231, Nea Ionia,
Athens, Greece

Tel: [phone]
Fax: [phone]

[Sarah Northway]

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

[Dave-401]

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@...> 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
>