MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

max_open_files warning

CONCEPT21May 13 2017 — edited May 14 2017

Hello all MySQL Friends,

It is me again!

This time, the problem is tougher.

Whenever the mysql server start, it shows these 2 warning:

=============

2017-05-13T16:41:14.418439Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)

2017-05-13T16:41:14.418508Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)

=============

How do I correct them? I even can't find max_open_files from the mysql server information.

My system is Ubuntu 16.04 amd64, MySQL 5.7.18.

Thanks for your opinions.

This post has been answered by Gaz in Oz on May 14 2017

Jump to Answer

Added on May 13 2017

#mysql-faqs, #mysql-user-groups

2 comments

1,774 views