Too many connections

Discussion in 'Installation/Configuration' started by kmchen, Mar 21, 2019.

  1. kmchen

    kmchen Member

    On one website over debian/ispconfig 3.1 multi php-fpm configuration I get those logs:

    mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (08004/1040): Too many connections in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 82, referer: https://ks307144.kimsufi.com:8080/index.php​

    Any idea ?
     
    kmchen, Mar 21, 2019
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Raise max_connections and max_user_connections in mysql/mariadb config and restart the database server.
     
    till, Mar 21, 2019
    #2
  3. kmchen

    kmchen Member

    Thanks. Put max_connections to 1000 but did not find any max_user_connections in /etc/mysql
     
    kmchen, Mar 22, 2019
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    That's ok, just add it below the max_connections line in the config file if it's not there. E.g.

    max_user_connections = 1000
     
    till, Mar 22, 2019
    #4
    Trust35 likes this.
  5. Trust35

    Trust35 New Member

    I have the same problem.
     
    Trust35, Mar 26, 2019
    #5
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Does the same fix work?
     
    Taleman, Mar 26, 2019
    #6

Share This Page