MARIADB Too Many connections

MARIADB Too Many connections

Https://www.cnblogs.com/kevingrace/p/6226324.html

There are many articles on the internet to solve this problem, some of the changes are still problematic, I this is the latest version. The test was successful.

Version:

Server VERSION:5.5.56-MARIADB MariaDB Server

CentOS Linux release 7.4.1708 (Core)

A passage in this document explains the problem:

/usr/lib/systemd/system/mariadb.service

# For example, if you want to increase mariadb ' s open-files-limit to 10000,

# need to increase Systemd ' s limitnofile setting, so create a file named
# "/etc/systemd/system/mariadb.service.d/limits.conf" containing:
# [Service]
# limitnofile=10000

To create a new folder.

/etc/systemd/system/mariadb.service.d/limits.conf

Write the configuration to the limitnofile parameter to modify the number of open files

Perform

Systemctl--system Daemon-reload

Then configure the MY.CNF in the

max_connections=1000

Systemctl Restart MARIADB

The test was successful.

MARIADB Too Many connections