A maxIdleTime of 30 seconds is a good start. However, you have to make sure the total count of pooled connections is not larger than the default MySQL max_connections setting which is 151 by default.
A maxIdleTime of 30 seconds is a good start. However, you have to make sure the total count of pooled connections is not larger than the default MySQL max_connections setting which is 151 by default.