Re: [I] Druid Version 0.22.1 - Long Coordinator handoff times (druid)

["acherla (via GitHub)" <gi...@apache.org>]

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: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org