MariaDB max_user_connections

DennisMidjord

• August 17, 2017 03:21

Hi, We have a client that somehow managed to use all 750 allowed connections to our MariaDB server. Process list: pastebin.com/ARMTJvGk I tried setting max_user_connections to 100 but got this error: ERROR 1290 (HY000): The MariaDB server is running with the --max-user-connections=0 option so it cannot execute this statement Is there somehow we can fix this? It's happened three times during the past 24 hours.

• 

  cPanelMichael

  • August 17, 2017 15:31

  Hello, Can you verify the full contents of your /etc/my.cnf file file? Also, does a /usr/my.cnf file exist on this server? Thank you.

  0
• 

  DennisMidjord

  • August 17, 2017 16:16

  There's not much in /etc/my.cnf. It's a pretty new server. [mysqld] innodb_file_per_table=1 default-storage-engine=MyISAM performance-schema=0 max_allowed_packet=268435456 max_connections=750
  There's no /usr/my.cnf file.

  0
• 

  cPanelMichael

  • August 17, 2017 17:11

  I tried setting max_user_connections to 100 but got this error: ERROR 1290 (HY000): The MariaDB server is running with the --max-user-connections=0 option so it cannot execute this statement

  
  I'm not able to reproduce this issue when restarting MariaDB after adding the following value to the /etc/my.cnf file: max_user_connections=100 Can you verify where you receive that error message? Thank you.

  0
• 

  DennisMidjord

  • August 17, 2017 17:13

  Hi, I used the SET GLOBAL max_user_connections = 100; command. Can't it be changed on the fly? I'm not much for restarting the MySQL service as some of our clients aren't too happy about downtime, even if it's just for a few seconds :)

  0
• 

  cPanelMichael

  • August 17, 2017 17:27

  I used the SET GLOBAL max_user_connections = 100; command. Can't it be changed on the fly? I'm not much for restarting the MySQL service as some of our clients aren't too happy about downtime, even if it's just for a few seconds

  
  I don't believe that will work if the existing value is already at 0. This is explained on the following URL:

  0

Please sign in to leave a comment.