To restrict the connection to database?
Hello friends.
Question : how to limit number of connections to the database
(please don't kick me)
Have VPS
-центос7 control panel Vesta-Apache-nginx-MariaDB
In control panel there is a fad SERVER configuration MARIARI
but here is empty, and setting and maintaining the fields are empty
here is the screenshots
what do I need?, to create the config file DB?,
or these limitations is possible with NGINX to register , if you can then how?
I WAS NOT UNDERSTANDING....HELP.
For me a difficult question.
========
excuse me but
to be honest I was hoping for a solution
you need to go to console root access, command
[such and such]# > name_file
in file so-and-so to change something that
Question : how to limit number of connections to the database
(please don't kick me)
Have VPS
-центос7 control panel Vesta-Apache-nginx-MariaDB
In control panel there is a fad SERVER configuration MARIARI
but here is empty, and setting and maintaining the fields are empty
here is the screenshots
what do I need?, to create the config file DB?,
or these limitations is possible with NGINX to register , if you can then how?
I WAS NOT UNDERSTANDING....HELP.
For me a difficult question.
========
excuse me but
to be honest I was hoping for a solution
you need to go to console root access, command
[such and such]# > name_file
in file so-and-so to change something that
asked April 19th 20 at 12:26
3 answers
answered on April 19th 20 at 12:28
muskol is irrelevant to a web server and has its own config.
in the presence of the panel, edit the configs knobs - so-so idea.
I would kick the slide Vesta (if any) and/or smoked forum(s) on it.
in the presence of the panel, edit the configs knobs - so-so idea.
I would kick the slide Vesta (if any) and/or smoked forum(s) on it.
answered on April 19th 20 at 12:30
The fact that they are not shown in the panel, does not mean that it is not applied to the Database.
Try to set some parameter (for example: max_connections) after you set (this is important) connect to the database and execute the following query:
Whether utanovleny value ? If Yes, then the parameter is applied and it works.
Try to set some parameter (for example: max_connections) after you set (this is important) connect to the database and execute the following query:
show variables like 'max_connections';Whether utanovleny value ? If Yes, then the parameter is applied and it works.
to be honest I was hoping for a solution
you need to go to console root access, command
[such and such]# > name_file
file takoto to change something for something
commented on April 19th 20 at 12:33
you need to go to console root access, command
[such and such]# > name_file
file takoto to change something for something
commented on April 19th 20 at 12:33
Did SO , went http://мойсервер/phpmyadmin/
under one of the created sites(or both ?)
vypolnil request and saw that the value is applied
what to do next? commented on April 19th 20 at 12:36
under one of the created sites(or both ?)
vypolnil request and saw that the value is applied
what to do next? commented on April 19th 20 at 12:36
commented on April 19th 20 at 12:39what does that mean, one cant connect or unlimited ??
commented on April 19th 20 at 12:42
commented on April 19th 20 at 12:42If 0 is not limited. Write in the caliper. On the hosting rights is rather limited, I'm not sure you can change the value. As an option: I can try (preferably from the user root):
if not Ruth, I'm not sure that enough rights commented on April 19th 20 at 12:45
set global max_connections = 100;if not Ruth, I'm not sure that enough rights commented on April 19th 20 at 12:45
@jules_Stanton, from what I've got prawa Ruth, ie give a command
sudo set global max_connections = 100;
so ? commented on April 19th 20 at 12:48
sudo set global max_connections = 100;
so ? commented on April 19th 20 at 12:48
@Nya.Considi, you need to execute it in MySQL console. Here's how you sang "show variables like 'max_connections';" similarly, to execute for the above query commented on April 19th 20 at 12:51
answered on April 19th 20 at 12:32
Question : how to limit number of connections to the database
In the configuration of mariadb.
Offtopic: but why change? There is a certain connection limit by default. What kind of problem you want to solve?
and where is this configuration
--
I want to solve problem the lack of a configuration file commented on April 19th 20 at 12:35
--
I want to solve problem the lack of a configuration file commented on April 19th 20 at 12:35
and where is this configuration
usually /etc/my.cnf, if not there, you can look for in the startup scripts, or
locate my.cnf commented on April 19th 20 at 12:38
https://dev.mysql.com/doc/refman/8.0/en/server-sys... - vida commented on April 19th 20 at 12:34