MySQL Forums
Forum List  »  PHP

Too Many Connections - MySQL - 2GB RAM
Posted by: Gulfam Khan
Date: July 17, 2014 05:17AM

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?

Options: ReplyQuote


Subject
Written By
Posted
Too Many Connections - MySQL - 2GB RAM
July 17, 2014 05:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.