Centos7 mariadb MySQL max_connections=214 Unable to modify the problem

Centos7 mariadb MySQL max_connections=214 Unable to modify the problem

/etc/my.cnf.d/mariadb-server.cnf

[Mysqld]

Max_connections = 10000

After restarting mariadb max_connections = 214. Here's how to solve the problem:

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

[Service]

limitnofile=65535

limitnproc=65535

Save, exit.

Systemctl Daemon-reload

Systemctl Restart Mariadb.service

Enter MARIADB Client

Show variables like '%max_connections% ';

return value 10000. Problem resolution.

Centos7 mariadb MySQL max_connections=214 Unable to modify the problem