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