gabrielheck commented on issue #31868:
URL: https://github.com/apache/superset/issues/31868#issuecomment-2631383236
Hi, I’m also experiencing this issue, but I’m using MySQL as a metadata
store. Even after changing the SQLALCHEMY_ENGINE_OPTIONS, they were ignored,
and the idle connections remained open despite the configured settings. I tried
inspecting the source code to understand better how Apache Superset manages the
connections, but I didn’t find any apparent errors. I’m using Apache Superset
4.1.1 and MySQL 8.2.
Is there any change I need to apply besides the SQLALCHEMY_ENGINE_OPTIONS to
fine-tune the connection settings for my metadata store?
My settings:
```
SQLALCHEMY_ENGINE_OPTIONS = {
"pool_size": 50,
"max_overflow": 10,
"pool_timeout": 1,
"pool_recycle": 300,
"pool_pre_ping": True,
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
