Issue
-
Why number of idle connections are increasing more than my connection pool size?
-
Does Liferay clears idle connections?
-
If not then how to clear these idle connections from Liferay? What is the recommendation from Liferay to clear these idle connections?
Environment
- Liferay DXP 7.4
Resolution
-
Why number of idle connections are increasing more than my connection pool size?
The Idle connections refer to connections established to the database server but are not currently being used to execute a query or transaction. These connections remain open and are considered "idle" until they are needed again. However, the reason they are crossing the connection pool size could be due to something causing extra connections to be created outside the control of your pool.
-
Does Liferay clears idle connections?
Liferay is not directly related to clearing the idle connections. It uses HikariCP for connection pooling and database connections for all data-related requests inside the portal.
-
If not then how to clear these idle connections from Liferay? what is the recommendation from Liferay to clear these idle connections.
Liferay does not directly clear idle connections and it relies on the underlying connection pool for that functionality.
Additional Information