What should be the max_connection for 48 core PROCESSORS and 256 gb RAM?



  • What should be the max_connection for 48 core PROCESSORS and 256 gb RAM ?



  • Start with max_connections = 2000. Keep an eye on the STATUS Max_used_connections for a week. If that approaches max_connections, then raise the limit. If not, leave it at 2000 and move on to other concerns.

    Set thread_cache_size to one-quarter of max_connections.

    Neither of these settings matters much. The main downside risk is getting denied a connection due to "too many connections".


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2