Details
-
Feature Request
-
Resolution: Can't Do
-
Major
-
None
-
2.11.3 GA
-
False
-
None
-
False
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
0
-
0%
Description
A customer is concerned about the number of sidekiq connection cron jobs make to Oracle. They wish reduce the number.
Both the main application (system-app) and sidekiq (background job processing) use a connection pool for connecting to the database.
It is defined in https://github.com/3scale/porta/blob/3scale-2.12.0-GA/openshift/system/config/database.yml in the following way:
pool: <%= ENV.fetch('RAILS_MAX_THREADS', 5) %>
But Sidekiq RAILS_MAX_THREADS is set to 25 explicitly in the operator: https://github.com/3scale/3scale-operator/blob/15c08acf4183f8453c087bf5d4155357559aad5d/pkg/3scale/amp/component/system.go#L836
And is not configurable.
I have a few questions -
Why was 25 chosen? Will Sidekiq run with less connections (ie 5) and if not why not. Ie. will it be possible to reduce the number of connections.