All Apps and Add-ons

DB Connection Limit

Sammich
New Member

Does anyone know if there is a maximum number of db connections that the Java Bridge Server can support? I know in the java.conf file you can set the pool.maxActive to specify the maximum number of active database connections, but is there a limit to this?

Tags (1)
0 Karma
1 Solution

ziegfried
Influencer

The limit highly depends on the environment. Both the type operating system and especially the limit on max. open file descriptors and hardware such as available memory will be a limiting factor. The database server might limit the number of connections per host or user as well.

In general pool.maxActive count being higher than the number of available threads will not have any effect since DB Connect will only use/open 1 connection per thread. There are 2 thread-pools for DB Connect:

  • bridge: 10 threads for commands (ie. dbquery, dbinfo, dboutput)
  • dbmon: 5 threads for database inputs

These thread-pool sizes can be configured in java.conf. For example:

[bridge]
threads = 20

[dbmon]
threads = 50

[dbx]
pool.maxActive = 70

This would give a total of 70 available threads, so setting the max. size of the connection pool to 70 is a reasonable choice.

View solution in original post

ziegfried
Influencer

The limit highly depends on the environment. Both the type operating system and especially the limit on max. open file descriptors and hardware such as available memory will be a limiting factor. The database server might limit the number of connections per host or user as well.

In general pool.maxActive count being higher than the number of available threads will not have any effect since DB Connect will only use/open 1 connection per thread. There are 2 thread-pools for DB Connect:

  • bridge: 10 threads for commands (ie. dbquery, dbinfo, dboutput)
  • dbmon: 5 threads for database inputs

These thread-pool sizes can be configured in java.conf. For example:

[bridge]
threads = 20

[dbmon]
threads = 50

[dbx]
pool.maxActive = 70

This would give a total of 70 available threads, so setting the max. size of the connection pool to 70 is a reasonable choice.

Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...