Last week, our MySQL database got overwhelmed with a lot of connections doing
I have talked to the developers who say it will take weeks to fix this issue.
In the mean time, I would love to have a way to limit the amount of live connections to the MySQL database if I see it getting out of control.
There is the option
max-connections but I am not sure if I can throttle this so that if I the database is getting swamped, I would just
set global max-connection = 100, and it would stop accepting new connections.
Is this a viable solution? What have you done before when your database gets overwhelmed?