Shulou(Shulou.com)05/31 Report--

Editor to share with you how to change the invalid open_files_ threshold of too many files problems in mysql. I hope you will get something after reading this article. Let's discuss it together.

[root@hs-79 etc] the value of the # ulimit-n204800 system is correct. Then modify the / etc/my.cnf configuration file. After adding the open_files_limit=65535 restart service, check the show variables like'% open%'; and find that the value of open_files_limit is still 1024. In this case, we need to modify the last place, cat-n / etc/systemd/system/mysql.service, add LimitNOFILE=65535 # newly added content to the mysql.service, add the service restart service on the last line, modify the mysql.server, you may need systemctl daemon-reload.

When innobackupex makes a backup, too many open files finds that the number of files under my mysql is more than 10W, so you need to set ulimit-n 1048576 to fail after restart, so you also need to modify the system configuration file, modify the system configuration file / etc/security/limits.conf * soft nofile 1048576 * hard nofile 1048576 and set my.cnf open-files-limit=1048576 to restart the mysql service after reading this article I believe you have a certain understanding of "what to do if the change of the open_files_ threshold value of too many files problems in mysql is invalid". If you want to know more about it, welcome to follow the industry information channel, thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.