This might help you
On 8/2/06, Rithish Saralaya <rithish.saralaya@stripped> wrote:
> 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
> and db server.
> 2. The tables are of INNODB type.
> 3. mytop shows qps as 66; Hits/s as 12.3