MySQL 10.3.23 [Warning] Could not increase number of max_open_files

net@work

• May 14, 2020 05:22

Hello, I have a warning to my database that says: [Warning] Could not increase number of max_open_files to more than 10000 (request: 37190)
When I go and change manually from my.cnf the limit and make restart of the Mysql the error it's the same. open_files_limit=80000
I have WHM 86.0.20 {With that version the CPANEL-32712 it's fixed at least}. Any advice? What I must do to prevent that kind of warning and the database run smooth? Thank you in advance!

• 

  vacancy

  • May 14, 2020 10:30

  Setting, WHM > Tweak settings > Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration > Off After mysql/mariadb restart.

  0
• 

  net@work

  • May 14, 2020 10:57

  First of all thank you for your reply.

  Setting, WHM > Tweak settings > Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration > Off After mysql/mariadb restart.

  
  I already make this with not any success. The error is the same. Any other sugestion?

  0
• 

  DigiTimber

  • May 14, 2020 17:06

  I had the same issue after restarting the db service in 86.0.20, check /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf. Don't forget a 'systemctl --system daemon-reload' if you make any changes, then restart the service.

  0
• 

  cPanelLauren

  • May 15, 2020 21:09

  This is discussed here as well: Could not increase number of max_open_files to more than 1024 (request: 1835)

  0

Please sign in to leave a comment.