How did I fix «[Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)» for MySQL in Ubuntu 20?

dmitrii_fediuk · June 15, 2024, 11:20pm

dmitrii_fediuk · June 16, 2024, 12:09am

I solved it by analogy with How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue?

Step 1

thehcginstitute-com/167.71.186.128/blob/2024-06-16-2/etc/security/limits.conf#L1-L9


      
          # 2024-06-16 Dmitrii Fediuk https://upwork.com/fl/mage2pro
          # 1.1) "[MySQL] «[Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)»":
          # https://github.com/thehcginstitute-com/167.71.186.128/issues/26
          # 1.2) "How did I fix «[Warning] [MY-010140] [Server]
          # Could not increase number of max_open_files to more than 10000 (request: 65535)» for MySQL?": https://df.tips/t/2228
          # 2.1) "How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue?": https://df.tips/t/220
          # 2.2) https://unix.stackexchange.com/a/157910
          mysql hard nofile 65535
          mysql soft nofile 65535

Step 2

reboot

Step 3

github.com

thehcginstitute-com/167.71.186.128/blob/2024-06-16-2/usr/lib/systemd/system/mysql.service#L14-L22


      
          # 2024-06-16 Dmitrii Fediuk https://upwork.com/fl/mage2pro
          # 1.1) "[MySQL] «[Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)»":
          # https://github.com/thehcginstitute-com/167.71.186.128/issues/26
          # 1.2) "How did I fix «[Warning] [MY-010140] [Server]
          # Could not increase number of max_open_files to more than 10000 (request: 65535)» for MySQL?": https://df.tips/t/2228
          # 2.1) "How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue?": https://df.tips/t/220
          # 2.2) https://unix.stackexchange.com/a/157910
          LimitNOFILE=65535
          LimitNPROC=65535

Step 4

systemctl daemon-reload

Step 5

service mysql restart