Gone are the days where simply changing /etc/my.cnf would be sufficient. Enter the new systemd world.
systemd itself has a limit that controls how many files a service can open, regardless if what you configure in /etc/my.cnf or /etc/security/limits.conf.
To increase the open files limit in MariaDB running on a RHEL or CentOS 7 with systemd, do the following.
First, create a new directory that will hold the MariaDB service changes in systemd. By making your changes here, you’ll make sure that package upgrades that would/could overwrite the mariadb.service file don’t remove your own changes.
1
$mkdir-p/etc/systemd/system/mariadb.service.d/
Next, configure systemd so that the MariaDB service can open more files.
In order for systemd to be aware of those changes, you have to reload the systemd daemon. This only reloads the configs that systemd knows about, it does not restart any actual service.
1
$systemctl daemon-reload
The above tells systemd that MariaDB can open 10000 files of it wants. Restart the MariaDB service now to make those changes stick.
1
$systemctl restart mariadb
Выполняем запрос к базе данных
1
SHOW VARIABLES LIKE'Open_files_limit';
Получаем значение
1
2
3
4
5
6
+------------------+-------+
|Variable_name|Value|
+------------------+-------+
|open_files_limit|65535|
+------------------+-------+
1row inset(0.00sec)
And you’re done.
Increase the value in /etc/systemd/system/mariadb.service.d/limits.conf if needed.
These changes are also “documented” in the mariadb.service service file in systemd.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
$cat/usr/lib/systemd/system/mariadb.service
...
# It's not recommended to modify this file in-place, because it will be
# overwritten during package upgrades. If you want to customize, the
# best way is to create a file "/etc/systemd/system/mariadb.service",
# containing
# .include /lib/systemd/system/mariadb.service
# ...make your changes here...
# or create a file "/etc/systemd/system/mariadb.service.d/foo.conf",
# which doesn't need to include ".include" call and which will be parsed
# after the file mariadb.service itself is parsed.
#
# For more info about custom unit files, see systemd.unit(5) or
