Could not increase number of max_open_files to more than 15000

SamuelM

Technical Analyst Team Lead
Nov 20, 2019
196
39
103
USA
cPanel Access Level
Root Administrator
Hello @albatroz

Can you check if the "Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?" option is enabled in the Tweak Settings interface in WHM?

https://docs.cpanel.net/whm/server-configuration/tweak-settings/#sql

You might also want to try using the "auto-adjust-mysql-limits" script:

https://docs.cpanel.net/whm/scripts/the-auto-adjust-mysql-limits-script/

Please let us know if you continue to observe any issues after testing these options.

Best regards
 

sajithgsm

Well-Known Member
Jun 9, 2020
98
18
83
Sri Lanka
cPanel Access Level
Root Administrator
Hi,

this happened me today. I have run this.
/usr/local/cpanel/scripts/auto-adjust-mysql-limits

But its getting a error like this.

warn [auto-adjust-mysql-limits] Adjust called while MySQL is not running, OpenFiles cannot be adjusted at this time


Is there any way to solve this issue?
 

sajithgsm

Well-Known Member
Jun 9, 2020
98
18
83
Sri Lanka
cPanel Access Level
Root Administrator
Hi,

I was running MariaDB on the server.

[[email protected] ~]# ps aux | grep -i mariadb
root 21204 0.0 0.0 112808 1004 pts/0 S+ 09:37 0:00 grep --color=auto -i mariadb
[[email protected] ~]#

I just tried to upgrade mariadb 10.3 to 10.5 also. It also failed.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
12,499
1,971
363
cPanel Access Level
Root Administrator
Since the upgrade failed it appears there are not any databases running on the machine, so that command wouldn't work.

It might be best to submit a ticket to our team so we can checked the failed database upgrade and the system with you.