max_user_connectiosn resets

Stephen Bignell

• May 17, 2020 19:48

Hi I have an issue where the max_user_connections for a user resets back to 30 and I can't see why. mysql Ver 15.1 Distrib 10.0.38-MariaDB, for Linux (x86_64) using readline 5.1 I update the variable with "UPDATE mysql.user SET max_user_connections = 80 WHERE user='xxxxx AND host='localhost';" and it is applied fine when I check it afterwards, but each day I get a message from him saying it's reset back to 30 again. I can't see what is making it reset back to 30. my.cnf file [mysqld] max_user_connections=300 max_allowed_packet=268435456 open_files_limit=23000

• 

  GOT

  • May 18, 2020 14:07

  The command you use to update it is temporary. You need to set it in /etc/my.cnf.

  0
• 

  cPanelLauren

  • May 18, 2020 21:12

  Yea, the next time MySQL restarts that will be wiped out as @GOT noted in order for it to be persistent it needs to be added in /etc/my.cnf
  

  0
• 

  Stephen Bignell

  • May 19, 2020 02:07

  But I have it set in /etc/my.cnf as displayed in the message. It's set to 300.

  0
• 

  cPanelLauren

  • May 19, 2020 21:04

  I see, what's in the mysql error log? You can find the log location in /etc/my.cnf
  

  0
• 

  Stephen Bignell

  • May 19, 2020 23:32

  Sorry, logging wasn't enabled. I've got it logging now so I can see what happens overnight and see if I can tell where it switches the user back to 30. Funny thing is, I can set the user to 80 max_user_connections and restart mysql and it stays at 80. Could the user themselves be setting it back to 30 in a script they use?

  0
• 

  cPanelLauren

  • May 20, 2020 14:27

  That's doubtful there's probably a configuration error with the number you're setting.

  0
• 

  Stephen Bignell

  • May 20, 2020 22:11

  Hi. There is nothing in the error log overnight. I'm at a loss. There must be something that happens overnight (I assume during maintenance) that resets the user back to 30. As I said, I can set it and restart mysqld and it stays at 80, but next morning it's back to 30. Should I up the level of connections in the my.cnf to 500?

  0
• 

  cPanelLauren

  • May 20, 2020 22:26

  Highly doubtful changing the connections to 500 would make my difference - what's in /etc/my.cnf
  is the limit only changing for one specific user or all users?

  0
• 

  Stephen Bignell

  • May 21, 2020 01:07

  Entire my.cnf is below [mysqld] # performance-schema=0 # default-storage-engine=MyISAM # innodb_file_per_table=1 # open_files_limit=50000 # max_sessions = 500 log_error=/var/log/mysqld.log max_user_connections=300 max_allowed_packet=268435456 open_files_limit=23000 We only have 2 users we have to set to a higher than standard connections as they are running 2 x CMS programs, but they are both on the same cpanel account. It happens to both of them.

  0
• 

  cPanelLauren

  • May 28, 2020 21:29

  Right so if they're on the same account that's 1 user. So is this ONLY happening to this user or is the limit modified globally. It sounds like that user may have a custom file setting this limit.

  0

Please sign in to leave a comment.