List:General Discussion« Previous MessageNext Message »
From:Kishore Jalleda Date:August 4 2006 6:50pm
Subject:Re: determine safest value for max_connections
View as plain text  
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.
>
>

Thread
determine safest value for max_connectionsRithish Saralaya2 Aug
  • Re: determine safest value for max_connectionsKishore Jalleda4 Aug
    • RE: determine safest value for max_connectionsRithish Saralaya7 Aug