I am using tomcat jdbc for DB connection pooling. recently i have increased my maxActive property after frequent connection pool exhaust issue (when application under heavy load) so decided to increased the maxActive property by 50% after performing multiple load test to check the impact on CPU and memory.
but i observed that there is one maxIdle property also which i haven't modified so should i increase this one also and if yes then how to decide this number.any suggestion.