MySQL 10.3.23 [Warning] Could not increase number of max_open_files

[[email protected]]

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]

Setting, WHM > Tweak settings > Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration > Off

After mysql/mariadb restart.

 

[[email protected]]

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?

 

[DigiTimber]

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.

 

[cPanelLauren]

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