M
M
Mark2020-03-19 19:57:01
MySQL
Mark, 2020-03-19 19:57:01

How to change the max_connections setting when its setting in my.cnf is ignored?

I enter my own value for the max_connections parameter in my.cnf, but after the service is restarted, the "default" value is set - ~ 200.
OS: CentOS 7.
my.cnf is in: /etc/my.cnf VestaCP is installed

on the server, even changing it through its editor - the data is ignored.

MariaDB settings editor in Vesta
kiss_5kb.1584636692.png

If you change it via an SQL command, everything works, but this only has an effect until the server is rebooted:
set global max_connections = 550;

I assume that there may be a local settings file for the database that overrides the global one, but searching through locate did not give any results.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Mark, 2020-03-19
@MarkLb

I defined the setting in the file: /etc/my.cnf.d/server.cnf, rebooted the database server and it worked.

V
Vitaly Karasik, 2020-03-19
@vitaly_il1

do you have ssh access?
then you can look at
ps -ef|grep mysql
for more options
web.archive.org/web/20161017030124/https://www.psc...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question