I am using MySQL version 5.7.15 , ubuntu0.16.04.1. When I start the MySQL, I am getting below log,
2016-11-06T13:44:56.838233Z 0 [Warning] option 'table_open_cache': unsigned value 33554432 adjusted to 524288
2016-11-06T13:44:56.839061Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 1049386)
2016-11-06T13:44:56.839078Z 0 [Warning] Changed limits: max_connections: 214 (requested 800)
2016-11-06T13:44:56.839082Z 0 [Warning] Changed limits: table_open_cache: 400 (requested 524288)
$ ulimit -Sa | grep "open files"
open files (-n) 1024
In google, It is specified like open_files_limit value need to be increased to have more max_connections.
Will it be enough to set below values on the /etc/mysql/mysql.conf.d/mysqld.cnf and restarting the MySQl server ?
open_files_limit = 2048
max_connections = 800
table_open_cache = 600
Is there any other way to change the values without restarting the MySQL server ?
Is setting the open_files_limit on the MySQL configuration file enough ?