My server having 2GB of RAM and max_connections variable is set to 100. The website is an active website and having plenty of traffic, and I expect more than 100 users simultaneously using the website and all of these simultaneous users will must communicate with Database.
Since some days I/Users have started getting the error "Too many connections", many people suggest to increase the max_connections value to something higher. I just want to confirm from some expert that keeping in view the RAM (2GB) and the simultaneous users, is this wise to increase value of max_connections to 200 or 300 or any larger number? Should I increase the RAM if I increase the value or 2GB RAM can handle larger value?
Edit - - Flow of my web pages
//Start
$mysql_conn = mysql_connect("localhost","USER_NAME","PASSWORD") or die( mysql_error()." cannot connect...");
mysql_select_db("DATABASE",$mysql_conn);
//[ALL THE LOGIC OF PAGE]
@mysql_close($mysql_conn);
//End
Regards,
It was an hard disk issue i.e. Hard disk was full.