I'm running a dedicated MySQL server on an m1.large EC2 instance, which has 7.5 GB of RAM.
What might be a good number to set my
max_connections value to?
The answer depends on the expected workload: the expected number of concurrent connections and the expected time of a connection. The default value is set to 100. For a good and dedicated machine, you can increase it to some value like:
Maximum (theoretically) possible memory usage = Total Server Buffer + (max_connections * Buffer per thread), which is:
What will be a good number depends on these components. How will you adjust these components depends on what your DB does.
You might set
So, everything depends on your DB, how much data will it process at time and how will you optimize your configuration for it.
You have to go over all parameters listed here to know what are optimal values for your DB. Maybe, your application and DB architecture is so bad, that you have too large joins and
Let your application run, collect stats and optimize DB accordingly, not vice-versa.