Option 1) Adding this to /etc/security/limits.conf
| Code Block |
|---|
mysql soft nofile 65535
mysql hard nofile 65535 |
Option 2)Modifying systemd configuration file
| Code Block |
|---|
# vim /etc/systemd/system/mysql.service |
And you will need to add following lines
| Code Block |
|---|
LimitNOFILE=infinity
LimitMEMLOCK=infinity |
For your information, you can put correct numbers instead of infinity