What should be the max_connection for 48 core PROCESSORS and 256 gb RAM?
morde last edited by
What should be the max_connection for 48 core PROCESSORS and 256 gb RAM ?
max_connections = 2000. Keep an eye on the
Max_used_connectionsfor a week. If that approaches
max_connections, then raise the limit. If not, leave it at 2000 and move on to other concerns.
thread_cache_sizeto one-quarter of
Neither of these settings matters much. The main downside risk is getting denied a connection due to "too many connections".