[MariaDB discuss] Re: is blocked because of many connection

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?