This might help you
http://kjalleda.googlepages.com/maxconnbymysql
Kishore Jalleda
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
> web
> and db server.
> 2. The tables are of INNODB type.
> 3. mytop shows qps as 66; Hits/s as 12.3
>
> Regards,
> Rithish.
>
>
