[HIVE-26794] Explore retiring TxnHandler#connPoolMutex idle connections

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-beta-1
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Zhihua Deng
• Reporter: Zhihua Deng
• Created: 30/Nov/22 12:52
• Updated: 15/Aug/23 06:33
• Resolved: 26/Jan/23 20:43

Description

Instead of creating a fixed size connection pool for TxnHandler#MutexAPI, the pool can be assigned to a more dynamic size pool due to: 

• TxnHandler#MutexAPI is primarily designed to provide coarse-grained mutex support to maintenance tasks running inside the Metastore, these tasks are not user faced;
• A fixed size connection pool as same as the pool used in ObjectStore is a waste for other non leaders in the warehouse; 

 

Issue Links

• links to: GitHub Pull Request #3817