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
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
