Cpanel / MariaDB - Could not increase number of max_open_files to more than 100000

Waiting for “mysql” to restart ……waiting for “mysql” to initialize ………finished.

Service Status
mariadb (/usr/sbin/mysqld) is running as mysql with PID 3493066 (systemd+/proc check method).

Startup Log
Aug 12 12:07:57 servertest07.offshore-cloud.com systemd[1]: Starting MariaDB 10.3.24 database server...
Aug 12 12:07:57 servertest07.offshore-cloud.com mysqld[3493066]: 2020-08-12 12:07:57 0 [Note] /usr/sbin/mysqld (mysqld 10.3.24-MariaDB) starting as process 3493066 ...
Aug 12 12:07:57 servertest07.offshore-cloud.com mysqld[3493066]: 2020-08-12 12:07:57 0 [Warning] Could not increase number of max_open_files to more than 100000 (request: 525335)
Aug 12 12:07:57 servertest07.offshore-cloud.com systemd[1]: Started MariaDB 10.3.24 database server.

mysql restarted successfully.

 

You've to changed the value in /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf to resolve the issue.

 

For MySQL, same technique with a different file.

You can easily check the current value with a cat/grep :

 

cat /etc/systemd/system/mysql.service | grep LimitNOFILE

 

  • 0 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Articles connexes

NTP - Ajustement de l'heure (Centos)

Installation de NTP :   Centos 6 : yum install ntpchkconfig ntpd onntpdate...

Installer WHM / cPanel sur Centos

yum updateyum upgradeyum install perlcd /homewget -N http://httpupdate.cpanel.net/latestsh latest...

Installation de plugins & Outils utiles

wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpmrpm -Uhv...

Supprimer les anciens kernels

Connaitre sa version kernel actuelle :uname -rNe conserver que l'actuel et sa version antérieure...

Serveur full (/var/tmp/)

rm -rf /tmp/* service mysql restart service httpd restart

Powered by WHMCompleteSolution