[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.
character encoding for that 103? because 10 looks suspiciously like a prefix of 103 and given the default is 0 (unlimited) I can only think that you've got a space or some other invisible character between the 10 and the 3 that causes the parse to treat the string as 10 and not 103.
I have been testing with different numbers just to see if and how it would change, or if there was a relationship (maybe total amount of connections devided by something as a max for users). I think I also tested with 200. Maybe some update script did not execute fully/correctly. No idea where this 10 is coming from. I am going to check logs a bit and just wait for the next blocking ;)