MariaDB "Too many connections"

Support
Log in to reply
  • M

    Hello!
    I have an install of Theopenem at a school system with five com servers in a cluster and 4178 endpoints. Every morning from around 7:45-9, it becomes unusably slow, with weird errors and access denied pages. After this period every morning it's fine, with everything checking in and responding normally. Digging into the logs, MariaDB is having a fit, giving this "too many connections" error up to around a dozen times per second. Is there anything I can do to lighten the load on the database? What causes this?

    ce8265fb-1ba7-4639-941a-426457ac0b05-image.png
    2f696491-d060-4325-b838-25bc93dd407e-image.png
    a7058854-b41a-4e98-b8d4-68b43406c85a-image.png

    0
  • T

    I would start by increasing the memory available to Mariadb. You want it to be about 80% of your available memory to get as much of the working set into memory as possible.

    In c:\program files\mariadb\data\my.ini
    Change or add this line.
    innodb_buffer_pool_size=12GB

    make sure it's under the [mysqld] section and not the [client] section.

    Then restart mariadb service.

    0