Sample Header Ad - 728x90

Limiting and queueing the database connections

0 votes
2 answers
851 views
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