In mariaDB, is it possible to do something like this?
- limit the number of connections (like in mysql, as explained in this SO answer )
- set up a queue for all the other connection attempts, and avoid triggering
User ** already has more than 'max_user_connections' active connections
If something like this is possible, is it even **advisable** to set things up in this way?
Real case scenario is that something is causing one of our servers to clog up, with mariaDB taking up as much as 80% of CPU and about the same percentage of RAM. SHOW FULL PROCESSLIST
returns a ridiculous amount of connections from one user (+50), while the other users have 3-5 simultaneous connections. If the offending user is temporarily blocked, everything returns to normal.
Asked by FiddlingAway
(125 rep)
Apr 28, 2022, 06:01 AM
Last activity: Apr 28, 2022, 03:29 PM
Last activity: Apr 28, 2022, 03:29 PM