Ubuntu under the MySQL hint changed limits:max_open_files:1024 solution

In the configuration of my MD5 decryption site cmd5.la, mysql5.7 appeared max_open_files:1024, max_connections:214,warning:changed Limits:max_ connections:214 a series of hints. According to the various configuration on the Internet is not possible, the final study found that the original Ubuntu has an operation.

The first step is to take care of the max_open_files limitations of the system first.

vi/etc/security/limits.conf, add two lines to the last face

* Hard Nofile 65535

* Soft Nofile 65535

This sets the system to the maximum of 65535 of all user files.

The second step, this is unique to the Ubuntu system.

MKDIR/ETC/SYSTEMD/SYSTEM/MYSQL.SERVICE.D Create this folder, add a file limits.conf inside. The contents of the file are:

[Service]

Limitnofile = 65535

Get. Reboot the system to do it.

Ubuntu under the MySQL hint changed limits:max_open_files:1024 solution