Hello folks. How do I determine what is the safest value that I can set for max_connections in my.cnf? The default value of 100 is proving to be a shortfall during some cases of peak hour traffic. Could you point me to a resource available if any?
1. Our server is RHEL 3, 2*3.00 GHz, 4GB ram. This acts both as our web and db server. 2. The tables are of INNODB type. 3. mytop shows qps as 66; Hits/s as 12.3 Regards, Rithish.