max_user_connections my.cnf ignored?

katmai

• January 31, 2019 15:43

hey guys, so i have a weird issue, i am using mariadb10.2 i have set max_user_connections=200 in my.cnf but upon restarting the mysql server i get the default: | max_user_connections | 2147483647 | anyone experiencing anything similar how can i get the limits to work?

• 

  Jarvis421

  • February 01, 2019 00:33

  Hello, Are you using SHOW GLOBAL or SHOW to check the value? Try running : SHOW GLOBAL VARIABLES LIKE '%max_user_connections%';
  

  0
• 

  katmai

  • February 01, 2019 00:49

  huh you're correct however do the limits get applied? MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE '%max_user_connections%'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | max_user_connections | 200 | +----------------------+-------+ 1 row in set (0.00 sec) SHOW VARIABLES LIKE '%max_user_connections%'; +----------------------+------------+ | Variable_name | Value | +----------------------+------------+ | max_user_connections | 2147483647 | +----------------------+------------+

  0
• 

  katmai

  • February 01, 2019 06:44

  what i mean by the above reply is, are the user_connections limits enforced or not? shouldn't the session show the global if it's set?

  • With a GLOBAL modifier, the statement displays global system variable values. These are the values used to initialize the corresponding session variables for new connections to MySQL. If a variable has no global value, no value is displayed.
  • With a SESSION modifier, the statement displays the system variable values that are in effect for the current connection. If a variable has no session value, the global value is displayed. LOCAL is a synonym for SESSION.

  0
• 

  katmai

  • February 02, 2019 08:25

  nevermind, now i understand after some coffee. logged on on a random mysql user and did show variables (the session command) and sure enough the limit is 200, so it seems like only for root the max_user_connections is set to maximum.

  0
• 

  cPanelMichael

  • February 04, 2019 20:23

  nevermind, now i understand after some coffee. logged on on a random mysql user and did show variables (the session command) and sure enough the limit is 200, so it seems like only for root the max_user_connections is set to maximum.

  
  Hi @katmai, Thanks for sharing the outcome. I've marked this thread as solved.

  0

Please sign in to leave a comment.