[Warning] options --log-slow-admin-statement & Could Not Increase No of max_open_files

[Somesh Zade]

I have done some tweaks for the MariaDB 10.1.4x version and tried to restart the sql server. SQL server restarted sucessfuly but printed the below errors in startup logs,


Startup Log

Aug 23 13:42:15 this-is-my-hostname systemd[1]: Starting MariaDB 10.1.46 database server...

Aug 23 13:42:16 this-is-my-hostname mysqld[22086]: 2020-08-23 13:42:16 139877587523840 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set

Aug 23 13:42:16 this-is-my-hostname mysqld[22086]: 2020-08-23 13:42:16 139877587523840 [Note] /usr/sbin/mysqld (mysqld 10.1.46-MariaDB) starting as process 22086 ...

Aug 23 13:42:16 this-is-my-hostname mysqld[22086]: 2020-08-23 13:42:16 139877587523840 [Warning] Could not increase number of max_open_files to more than 80000 (request: 80171)

Aug 23 13:42:16 this-is-my-hostname systemd[1]: Started MariaDB 10.1.46 database server.


Can anyone help me with this?

 

[cPanelLauren]

Can you show the output of the following:

cat /etc/my.cnf