In ubuntu, mysql prompts Changed limits: max_open_files: 1024. solution,

In ubuntu, mysql prompts Changed limits: max_open_files: 1024. solution,

When I configured my md5 decryption website named unzip 5.la, a series of prompts such as max_open_files: 1024, max_connections: 214, warning: Changed limits: max_connections: 214 appeared in mysql5.7. According to the various configurations on the Internet, the final research found that there was another operation under ubuntu.

Step 1: set the system's max_open_files restrictions first.

Vi/etc/security/limits. conf. Add two lines at the end

* Hard nofile 65535

* Soft nofile 65535

In this way, the maximum size of all user files in the system is set to 65535.

Step 2: This is unique to the ubuntu system.

Mkdir/etc/systemd/system/mysql. service. d to create this folder, add a file limits. conf. File Content:

[Service]

Maid = 65535

Done. Restart the system.