Could not increase number of max_open_files to more than 15000

[albatroz]

Hello,
I recently got this error message when I restarted the MYSQL service.
Can you tell how to fix this?

 

[SamuelM]

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]

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?

 

[cPRex]

@sajithgsm - that error would seem to indicate that MySQL is not running on the system. Can you send me the output of this command from your server?

ps aux | grep -i mysql

 

[sajithgsm]

this is the result

root 19771 0.0 0.0 112808 1004 pts/0 S+ 09:28 0:00 grep --color=auto -i mysql

 

[cPRex]

Thanks for that output - that would indicate that MySQL is not running on that server. Are you possibly running MariaDB instead?

 

[sajithgsm]

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]

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.