On 4/3/24 12:05, Marc wrote:
[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. -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com/