Unable to generate usage data with SQL exception
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
If there is no configuration for mysql user, default value will come into effect, which is 1024. With 1024 open file limit mysql can manage upto 214 connections. Even if the max_connections is configured 2100 (my.cnf), it will be ignored.
To address this issue we need to adjust max_connections and open files accordingly.
Please update the file /etc/security/limits.conf in MySQL server with configuration below:
mysql hard nofile 8192
mysql soft nofile 8192
Please update the file my.cnf in MySQL server with configuration below:
open_files_limit = 8192
max_connections = 1500