You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Sarah Northway <sa...@threerings.net> on 2009/06/04 00:36:26 UTC
Too many MySQL connections
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
Re: Too many MySQL connections
Posted by Dave <sn...@gmail.com>.
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 <sa...@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
>
Re: Too many MySQL connections
Posted by Sarah Northway <sa...@threerings.net>.
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
Re: Too many MySQL connections
Posted by "Emmanouil Batsis (Manos)" <ma...@abiss.gr>.
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: +30 211-1027-900
Fax: +30 211-1027-999