Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MariaDB max_user_connections

Discussion in 'Database Discussions' started by DennisMidjord, Aug 17, 2017.

Tags:
  1. DennisMidjord

    DennisMidjord Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    96
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Denmark
    cPanel Access Level:
    Root Administrator
    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.
     
    #1 DennisMidjord, Aug 17, 2017
    Last edited by a moderator: Aug 17, 2017
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,372
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  3. DennisMidjord

    DennisMidjord Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    96
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Denmark
    cPanel Access Level:
    Root Administrator
    There's not much in /etc/my.cnf. It's a pretty new server.
    There's no /usr/my.cnf file.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,372
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  5. DennisMidjord

    DennisMidjord Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    96
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Denmark
    cPanel Access Level:
    Root Administrator
    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 :)
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,372
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    I don't believe that will work if the existing value is already at 0. This is explained on the following URL:

    https://mariadb.atlassian.net/browse/MDEV-8236

    Thank you.
     
Loading...

Share This Page