Database connections management

Moderator: crythias

Locked
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

Database connections management

Post by dcorbera »

At 0 hours we have 15 database connections, but we don't have any user or agent connected. We are working with postgre. We don't see any configuration parameter. How can we manage it?
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Database connections management

Post by jojo »

shutdown apache and OTRS cronjobs
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

Re: Database connections management

Post by dcorbera »

Really the question is how many connections needs OTRS to work on postgre. We need it to dimensioning our database.
thanks
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Database connections management

Post by jojo »

every running apache child will need a connection. all jobs running by cron need also a connection
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
dcorbera
Znuny expert
Posts: 164
Joined: 15 Mar 2013, 17:09
Znuny Version: OTRS 3.2

Re: Database connections management

Post by dcorbera »

And what about customers? If we have 5 different customers connectes, we need 5 connections?
Thanks.
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Database connections management

Post by jojo »

all users (agents and customers) will need an apache child if they are concurrent
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked