acherla commented on issue #13692:
URL: https://github.com/apache/druid/issues/13692#issuecomment-1899818196
> @abhishekagarwal87 Hi I'm a bit late for this thread, but can you please
give a reference how to increase number of db connections for metadata storage?
(mysql in my case)
Missed this but here is an example:
```
#druid.metadata.storage.connector.dbcp.initialSize=2
#druid.metadata.storage.connector.dbcp.maxTotal=20
#druid.metadata.storage.connector.dbcp.maxIdle=20
#druid.metadata.storage.connector.dbcp.minIdle=2
#druid.metadata.storage.connector.dbcp.url={{druid_metadata_storage_connector_connectURI}}
#druid.metadata.storage.connector.dbcp.username={{druid_metadata_storage_connector_user}}
#druid.metadata.storage.connector.dbcp.password={{druid_metadata_storage_connector_password}}
#druid.metadata.storage.connector.dbcp.driverClassName=com.mysql.jdbc.Driver
```
Handoff times are still pretty long in druid even in 27.0.0 based on our
internal tests and its not due to the DB performance. Longest queries we have
are against the druid_segments table from the coordinator taking 3-5 minutes,
but thats largely because we have 4Mil+ segments in our cluster (its massive).
--
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]
