Hi, On 2024/04/02 23:48, Marc wrote:
MariaDB> show variables like '%max%connections%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | extra_max_connections | 1 | | max_connections | 5000 | | max_user_connections | 250 | +-----------------------+-------+ 3 rows in set (0.001 sec)
So set max_connections high, and limit the per-user scope using max_user_connections. works well for us.
/usr/sbin/mysqld --verbose --help shows me the value I have configured in server.cnf at [mysqld]. However the show variables like '%max%connections%' shows me a different value. I should be able to put this in server.cnf not?
Did you restart mariadb after modifying the configuration? And yes, you should be able, specifically we have our "standard" configuration in /etc/mysql/mariadb.d/90uls.cnf, and our distro by default sets my.cnf up such that this folder is included using !includedir /etc/mysql/mariadb.d/ (and the references to /etc/mysql was done to maintain as far as possible compatibility for what it's worth nowadays, to make it easier to swap between mysql and mariadb). In 99custom.cnf we would then put something like this: [mysqld] max_user_connections = 250 max_connections = 5000 Along with some other settings that's server specific and deviates from the default standards (like setting innodb_buffer_pool_size based on the available RAM on the specific server). Kind regards, Jaco