max_open_files cannot be changed

masterross

• January 27, 2019 09:48

Hi, It looks like mysql (10.1.37-MariaDB, WHM v76.0.18) doesnt accept max_open_files set in my.cnf I have: table_open_cache = 8000 but after restart when I check var: MariaDB [(none)]> show global variables like 'table_open_cache'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | table_open_cache | 5325 | +------------------+-------+ 1 row in set (0.01 sec) Also open_files_limit cannot be changed too! I have set Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration? to NO But this not helping. Any solution? EDIT: I found that if I need to change: /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf LimitNOFILE and then # systemctl daemon-reload # systemctl restart mysql i set LimitNOFILE=16000 And the table_open_cache also changed itself to 7825 automatically. It's strange but it do the job.

• 

  cPanelLauren

  • January 29, 2019 19:53

  Hi @masterross This is a setting that changed in CentOS 7 with systemd. I'm glad you found the solution and were able to implement it! Thank you for letting us know how you resolved it.

  0
• 

  RicRey

  • October 13, 2023 19:29

  I know it's an old topic but I couldn't find the solution, thanks for your help! I'm writing this for future reference :)

  0

Please sign in to leave a comment.