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

...

...

[mysqld] max_user_connections = 250 max_connections = 5000

Yes I am putting it exactly there. If I change max_connections there, I see that change as expected. However if I put there max_user_connections=103, I see 10 in show statement, and 103 in the output of '/usr/sbin/mysqld --verbose --help | grep max| grep connect '

using v10.5.

with 10.5 you can use

SELECT VARIABLE_NAME , GLOBAL_VALUE , GLOBAL_VALUE_ORIGIN , GLOBAL_VALUE_PATH FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES WHERE VARIABLE_NAME LIKE 'max%connections';

to see what value is in effect, and from where (esp.: what .cnf file) it was fetched.

Thanks!