07-24-2023, 02:21 PM
I'm trying to set the ideal performance setup for MySQL and resources needed on a shared hosting.
My question is, what does `max_connections` really mean?
Is it the number of unique concurrent requests made to the server?
So if there are two users, 1 with 1 tab open and the other with 4 tabs open... and both press all their tabs to reload at the same time, will there be 5 connections made to the MySQL DB? Consequently, if we bump this scenario to: 10 people with 2 tabs and 31 people with one tab all pressing refresh at the same time... with our `max_connections` at 50, will everyone get locked out?
The reason I ask is because I want to shoot for low `max_connections` to be conservative with memory resources since I consistently see the site going into cpu throttling mode
Thank you for your help
My question is, what does `max_connections` really mean?
Is it the number of unique concurrent requests made to the server?
So if there are two users, 1 with 1 tab open and the other with 4 tabs open... and both press all their tabs to reload at the same time, will there be 5 connections made to the MySQL DB? Consequently, if we bump this scenario to: 10 people with 2 tabs and 31 people with one tab all pressing refresh at the same time... with our `max_connections` at 50, will everyone get locked out?
The reason I ask is because I want to shoot for low `max_connections` to be conservative with memory resources since I consistently see the site going into cpu throttling mode
Thank you for your help