How many concarent DB connections?

(Eric) #1

We have a 2 server setup web/db. How many concurrent connections will Matrix hold on the database?

(Avi Miller) #2

Matrix doesn't hold any connections open permanently. The number of concurrent connections would be the total number of simultaneous Apache processes that are started up. The Administration Interface tends to open 2 to 3 connections when writing data.

(Eric) #3

Thanks


We experienced our first website outage, our hosting company determined that max connections had been reached it seems some connection were not closed properly. There were 27 open connections to DB we only have 2 admin users.



I have asked them to monitor number of connections to a db.

(Avi Miller) #4

We have some sites that run hundreds of concurrent connections to the database. 27 actually seems pretty low, if you imagine that every Apache connection will use at least one. You may want to check that Keep-Alives have been disabled on Apache, as that could be holding connections open.
(Adendle) #5

Hi All,

We have an Oracle database setup with persistant listeners that are configured to handle 1,000 concurrent connections..........

-=A=-