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.