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