Forum Stats

  • 3,838,654 Users
  • 2,262,389 Discussions
  • 7,900,724 Comments

Discussions

max_open_files warning

CONCEPT21
CONCEPT21 Member Posts: 72 Red Ribbon
edited May 14, 2017 6:05AM in MySQL Community Space

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. 

CONCEPT21

Best Answer

Answers