austenhead commented on issue #4666: Sessions still active on Datasource
URL: 
https://github.com/apache/incubator-superset/issues/4666#issuecomment-382974139
 
 
   The number of database connections to the metadata server is small and not 
an issue.
   The number of database connections to the database with company metrics (the 
data that gets shown in superset) got very big.
   
   I have 5 gunicorn processes running.
   
   From https://serverfault.com/a/862418 it looks like database on AWS's RDS by 
default can handle ~85 connections per 1GB of RAM. So you're right that 100 
connections shouldn't bother me as much as it is. If someone is running this 
against a small database, then it could be an issue.
   
   From looking at the flask-sqlalchemy I think you're right that that is the 
most likely culprit.
   
   Thanks for the quick response! I'll write back in the next couple of weeks 
if this did not resolve my issue (or if it ends up being tricky and someone 
else might benefit from notes on it).

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to